We apologize for untranslated text, you can use the Google Translation button to get an automatic translation of the web page in the language of your choice.

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 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

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

Information

Version
  • 1.3
Stability
  • Stable
Compatibility
  • JCMS 6.0
    JCMS 6.1
    JCMS 7
    JCMS 8
    JCMS 9
    JPlatform 10
Certified by Jalios
  • Yes
Price
  • Free Plugin
Support
  • Jalios Support
Author
  • Jalios SA
License
  • Jalios
Size
  • 2.49 MB
Updated
  • 1/11/21
Download
  • 10
Domains