Archive for February, 2013

How to specify SCS source to use type 2 JDBC connection for Oracle?

February 28, 2013

I have tried the following:

– With scs_admin_config object, attribute jdbc_driver does not matter to set to oracle.jdbc.driver.OracleDriver or oracle.jdbc.pool.OracleDataSource.

– Add $ORACLE_HOME/jdbc/lib to LIBPATH

– Under /opt/documentum/share/jboss4.3.0/server/DctmServer_WEBCACHE/deploy/scs.ear/APP-INF/lib:

* File ojdbc5.jar was renamed to ojdbc5.jar.000.
* File ojdbc6.jar was copied from $ORACLE_HOME/jdbc/lib

Actually only the last step made any difference. It seemed when ojdbc6.jar was used, SCS source could enable type 2 connection automatically.