Can JDBC OCI and JDBC Thin driver co-exist on the same Instance.
Iam getting the following error when I try to use the OCI driver:
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource IntegrationDataStore:IntegrationDataStore_OCI_NoTx_JDBCAdapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL
The following are the configuration settings for the adapter:
Connection Type JDBC Adapter Connection
Package Name DatabaseConnections
Connection Properties
Transaction Type --NO_TRANSACTION
DataSource Class --oracle.jdbc.pool.OracleDataSource
serverName ---- dlxksoradb1e.lex.lexmark.com
user ------ b2blxk
password -----
Retype password
databaseName — wmidden1
portNumber —1649
networkProtocol — TCP
Other Properties ---- drivetTyp=oci
The Server Configurations settings made in server.sh are :
CLASSPATH=${CLASSPATH}:/oracle/product/9.2.0.1/jdbc/lib/classes12.jar
System path
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/product/9.2.0.1/lib
Oracle home
ORACLE_HOME=/oracle/product/9.2.0.1/
My OCI driver client is installed properly because I tested it by writing a sample Java Program.
The cause for the error Iam getting seems to be like its using Thin driver.
Any help is greatly appreciated.
thanks
ucbabu