I am working on IS 6.0.1 on SP3. The JDBC adapter version is 6.0.3.I have set up IS and JDBC locally and am trying to access DB (ORACLE 9i).The entire system is on VPN .
I am trying to access DB using OCI driver and I am getting this error
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test:TestDBConnection.
[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
If I change the driverType=thin , the connection goes through without any error.
I have placed the classes12.zip in the IS/lib/jars folder as well as in \IntegrationServer\packages\WmJDBCAdapter\code\jars\static too.
I went through the advantage sit too and some solution lists the possibility of trailing spaces in the parameters.I have checked that too.
Any solution would be most helpful.
Thanks in advance