cakent
10-22-2008, 11:07 AM
ClearOrbit is recommending an update to the data source file and the Oracle jdbc driver used by JBoss and RFUI.
We have been testing this configuration within JBoss-4.0.1 for the past month, across Connect/CLM releases 5.4a-5.6SP1. The Oracle database versions that we have connect to are 9.2.0.6 or higher.
This will require the removal of several files after shutting down JBoss:
../lib/classes12.jar (if present)
../server/default/lib/classes12.jar
../server/default/deploy/clr-ds.xml
../server/default/deploy/hsqldb-ds.xml (if still presents)
../server/default/deploy/jms/hsqldb-jdbc2-service.xml (if still present)
../server/default/deploy/jms/hsqldb-jdbc-state-service.xml (if still present)
Delete the JMS_% tables from the 'clr' schema. These will be recreated during the next startup of JBoss.
The attached zip file [server-jdbc.zip] makes two fundamental changes. The method OracleValidConnectionChecker has been added to the clr-ds.xml file. The classes12.jar jdbc driver has been replaced with ojdbc14.jar. This file can be extracted from the $JBOSSDIR directory.
35
We have been testing this configuration within JBoss-4.0.1 for the past month, across Connect/CLM releases 5.4a-5.6SP1. The Oracle database versions that we have connect to are 9.2.0.6 or higher.
This will require the removal of several files after shutting down JBoss:
../lib/classes12.jar (if present)
../server/default/lib/classes12.jar
../server/default/deploy/clr-ds.xml
../server/default/deploy/hsqldb-ds.xml (if still presents)
../server/default/deploy/jms/hsqldb-jdbc2-service.xml (if still present)
../server/default/deploy/jms/hsqldb-jdbc-state-service.xml (if still present)
Delete the JMS_% tables from the 'clr' schema. These will be recreated during the next startup of JBoss.
The attached zip file [server-jdbc.zip] makes two fundamental changes. The method OracleValidConnectionChecker has been added to the clr-ds.xml file. The classes12.jar jdbc driver has been replaced with ojdbc14.jar. This file can be extracted from the $JBOSSDIR directory.
35