Jboss7 + Oracle 11g - ocijdbc11.dll: Can't find dependent libraries

[Paulo Bianchin]

Hi

I want connection for Oracle 11g from Jboss7 (win 32)


I followed the steps of http://javalabor.blogspot.com/2011/08/oracle-datasource-in-jboss-as-7.html?showComment=1326727838716#c30497072491729579


module.xml

<module xmlns="urn:jboss:module:1.0" name="com.oracle.db">
    <resources>
        <resource-root path="ojdbc6.jar"/>
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
    </dependencies>
</module>

standalone.xml

<datasource jndi-name="java:/jdbc/ifosAppDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
    <connection-url>
        jdbc:oracle:thin:@localhost:1521:XE
    </connection-url>
    <driver>
        oracle
    </driver>
    ...
<drivers>
    <driver name="oracle" module="com.oracle.db">
        <xa-datasource-class>
            oracle.jdbc.xa.client.OracleXADataSource
        </xa-datasource-class>
    </driver>
	

but get an error "Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path"

I added the key java.library.path

So show me the following error:

Caused by: java.lang.UnsatisfiedLinkError: C:\app\product\11.2.0\client_3\BIN\ocijdbc11.dll: Can't find dependent libraries
	at java.lang.ClassLoader$NativeLibrary.load(Native Method) [:1.7.0_01]
	at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1928) [:1.7.0_01]
	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854) [:1.7.0_01]

Anybody seen this?

[Peter Johnson]

This error means that some DLL on which ocijdbc11.dll depends cannot be found in the path. The best way to find out which DLL is missing is to use the dependency walker: http://www.dependencywalker.com/

[Paulo Bianchin]

Tanks for reply

I install dependency walker and fixed one dependency. but the problem remains


Do you have any other way without using these dll?

Caused by: java.lang.UnsatisfiedLinkError: C:\app\product\11.2.0\client_3\BIN\ocijdbc11.dll: Can't find dependent libraries
	at java.lang.ClassLoader$NativeLibrary.load(Native Method) [:1.6.0_03]
	at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751) [:1.6.0_03]
	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676) [:1.6.0_03]
	at java.lang.Runtime.loadLibrary0(Runtime.java:823) [:1.6.0_03]
	at java.lang.System.loadLibrary(System.java:1030) [:1.6.0_03]
	at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3506)
	at java.security.AccessController.doPrivileged(Native Method) [:1.6.0_03]
	at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3502)
	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:252)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:148)
	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
	... 30 more

[Peter Johnson]

You could use a different Oracle driver that doesn't need a native DLL. The drivers are listed at:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Looks like you need one that handles XA. (I don't use Oracle or I might be able to tell you a specific driver to use.)