java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

[wen]

Hi all,

I’ve been having issue with my dev environment. Have anyone seen this
error before or have any idea on how to fix it? My environment:

DAS 6.3 patch3
ATG7.1 patch1
Oracle 10g
Apache-ant 1.7.1

I have the following variables set up in my environment:
System variables:
ORACLE_HOME= C:\Oracle\instantclient_10_2
TNS_ADMIN= C:\Oracle\instantclient_10_2

User variables:
CLASSPATH= C:\Oracle\instantclient_10_2\ojdbc14.jar

When DRP startup, the CLASSPATH dynamo server prints out as
CLASSPATH: .\locallib;C:\ATG\ATG7.1\Gamelink\locallib;C:\ATG
\ATG7.1\Gamelink\cl
asses;C:\ATG\ATG7.1\home\servers\Dino5Development\startDynamo.jar

I tried to add the CLASSPATH at startup using
set CLASSPATH=%ORACLE_HOME%\ojdbc14.jar

Also tried editing postEnviroment.bat to add the path to CLASSPATH.
Nothing works so far.

Any help would be much appreciated. Thank you!

----------------------------------- error message
-------------------------------------------------------
/ Unable to resolve component /atg/dynamo/service/jdbc/JTDataSource
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
/ at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1491)
/ at java.lang.Runtime.loadLibrary0(Runtime.java:788 )
/ at java.lang.System.loadLibrary(System.java:834)
/ at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:313
5 )
/ at java.security.AccessController.doPrivileged(Native Method)
/ at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnect
ion.java:3131 )
/ at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221
)
/ at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnecti
on.java:414)
/ at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:13
2 )
/ ....stack trace CROPPED after 10 lines.
/

[Naga]

You are using JTDS pointing to FakeXA ? Can you attach your property files or paste their contents here please??

Naga

--
http://www.linkedin.com/in/nagarajanseshadri

[Belmont, Adam]

It looks like your are trying to load the OCI drivers?
Maybe you are missing a .so file location in your LD_LIBRARY_PATH
variable.
Well on Windows that would be a DLL file not .so and I assume it goes in
Windows/System32.

Check the oracle docs on the driver, they should probably say where
native libraries should be loaded and what system properties are
required.

The other thing could be that you are loading OCI by accident and you
really want the pure java driver.
In that case check your driver classname in your datasource. You
probably entered the wrong one.

-- Adam

[Ronak]

I have seen same error in solaris and it was resolved by puting
LD_LIBRARY_PATH=/oracle/product/9i/lib32.
default LD_ LIBRARY_PATH was pointing to 64 bit.

[George Oprica]

If its Windows, you need to add the library path to your Windows PATH
environment variable as indicated in the installation notes for the
Oracle JDBC drivers:

http://www.oracle.com/technology/tech/oci/instantclient/index.html

"3. Set the library loading path in your environment to the directory
in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH
is the appropriate environment variable. On Windows, PATH should be
used."

- George

[srini_r]

Hi,


Please checkup your FakeXADataSource.properties file. The URL you have
used is not for thin driver, but OCI driver.

It is better to use thin driver. so change the same.


regards


srini

On Oct 16, 12:29 am, "George Oprica" <gopr...@gmail.com> wrote:
> If its Windows, you need to add the library path to your Windows PATH
> environment variable as indicated in the installation notes for the
> Oracle JDBC drivers:
>
> http://www.oracle.com/technology/tech/oci/instantclient/index.html
>
> "3. Set the library loading path in your environment to the directory
> in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH
> is the appropriate environment variable. On Windows, PATH should be
> used."
>
> - George
>