Error creating JDBC connection using OCI driver mode

, ,
1

I am trying to create an adapter connection using OCI driver mode. I have downloaded “instantclient-basic-win32-10.2.0.3-20061115.zip” from Oracle.

Extracted the files to a location on the disk.

Set the PATH (environment variable) pointing above location.

Copied ojdbc14.jar to <IS_HOME>\lib\jars.

Environment:

wM 6.5, JDBC Adapter 6.5, Oracle 10g RAC (10.2.0.2.0), Windows XP Professional

Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName
user username
password ******
databaseName DBNAME
portNumber 1521
networkProtocol tcp
Other Properties url=jdbc:oracle:oci:@(DESCRIPTION=(failover=on)(failover_mode=(type=session)(method=basic))(address_list=(ADDRESS=(PROTOCOL=TCP)(Host=host1)(Port=1521))(ADDRESS=(PROTOCOL=TCP)(Host=host2)(Port=1521))(load_balance=on))(CONNECT_DATA=(service_name=)))

also tried:

Other Properties driverType=oci

I am getting following error:

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource test.flowService:testConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
C:\instantclient\ocijdbc10.dll: The specified procedure could not be found

When driverType is set as “Thin” it is working perfectly.

I think OCI drivers are backward compatible, as i got 10.2.0.3 drivers and my DB version is 10.2.0.2.

Thanks in advance!

Raheel

2

Hi,

I got the Oracle 10.2.0.1.0 Client Installed now. Now I am able to see the connection enabled.

I’ve tested the connection with a custom adapter service, and it works fine. :slight_smile:

When i tried with a select adapter template, the thread just hangs and server is down in no time.

I see the below error in java core dump:

An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x61D
32910
Function=xaolog+0x6294
Library=C:\ORACLE\product\10.2.0\client_1\bin\OraClient10.Dll

JVM:

Java VM: Java HotSpot™ Server VM (1.4.2_07-b05 mixed mode)

Any help will be appreciated.

Raheel