Oracle

• Add a new Database named jcmsdb with AL32UTF8 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 the jcmsdb 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