Oracle Database Plugin 1.3
Description
This plugin adds the support for Oracle 10g, Oracle 11g2 and Oracle 12c Edition RDBMS.
Installation
Oracle
- Add a new Database named
jcmsdb
withAL32UTF8
encoding. - Create a new user
jcms
allowed to managed this Database.
JCMS
- Go to Admin Area > Properties > Database.
- Select
Oracle Database 5
in the RDBMS list box. - Enter the JDBC URL for MySQL 5. Example:
jdbc:oracle:thin:@host:port:SID
- Enter the name (
jcms
) and the password to access to thejcmsdb
database. - Click on Check Connection...
- Once the database connection has been established successfully , save and restard JCMS
Isolation Level
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:
hibernate.cfg.common.prop.hibernate.connection.isolation: 2
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
Changes
Oracle Plugin v1.3
Update of the jdbc jar to 11.2.0.3.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
First release