It is getting better and better with each release, easier to configure and use. More Oracle shops are getting interested and start using it.
If you have any questions or issues, please let me know. I am always willing to help.
There are a number of smaller enhancements like:
- Warning, if script file is empty: When installing scripts, we now check for 0 bytes. If the file is empty, you will get a warning.
- copyFiles should be able to copy directories recursively
- validateConnections() should skip empty passwords: Sometimes you don't have access to the production database and thus no password. Validate would connect anyhow and lock the account after a few tries
- Upgraded libraries to SQLcl 21.4.1
- log4j dependencies upgraded to log4j-2.17.1 and all log4j-1x dependencies removed
- simplified and cross-operating system file filters: the regular expressions for matching the connection pools and the encodings (based on the path of the scripts in the sql subfolder) have a simplified alternative syntax. This is also required to support cross operating system development teams.
Install scripts for both environments: windows and linux
We have streamlined the experience for development teams that have developers working with Windows AND Linux/MacOS machines on the same project.
Manual install script
It is now possible to easily generate a zip file including all files for the installation including driving scripts for sqlcl and sqlplus.
This way the whole installation is not dependent on the opal-tools but will run with plain sqlplus or sqlcl.
This is an important feature when you have to hand the installation scripts to the DBAs and they have to do the install.