Oracle Database Plugin 1.3
This plugin adds the support for Oracle 10g, Oracle 11g2 and Oracle 12c Edition RDBMS.
- Add a new Database named
- Create a new user
jcmsallowed to managed this Database.
- Go to Admin Area > Properties > Database.
Oracle Database 5in the RDBMS list box.
- Enter the JDBC URL for MySQL 5. Example:
- Enter the name (
jcms) and the password to access to the
- Click on Check Connection...
- Once the database connection has been established successfully , save and restard JCMS
Oracle XE and Oracle Database Server require the use of isolation level 2 = TRANSACTION_READ_COMMITTED.
If you have previously changed this setting, or if you occasionally use other database modules, be sure to set the following property when running the application with an Oracle database:
Adding this property is not necessary if you have no other modules or have never forced its value.
Connection test request
In thencase of Oracle, in order to avoid performance problems, the connection test request must be modified. This setting is explained in the custom.prop file, look for the following property to configure it like :
hibernate.cfg.common.prop.hibernate.c3p0.preferredTestQuery: SELECT 1 FROM DUAL
Oracle Plugin v1.3
Update of the jdbc jar to 184.108.40.206.0 version
Fix for JCMS-7531 : migrate some DB feature detection to properties
Oracle Plugin v1.2
Add new driver ojbbc6.jar and compatibility with Oracle Database 12c
Oracle Plugin v1.1
Compatibility with JCMS 8
Oracle Plugin v1.0