aspose file tools*
The moose likes JDBC and the fly likes UnsatisfiedLinkError Driver.SQLAllocEnv() - WSAD and DB2 7.x Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "UnsatisfiedLinkError Driver.SQLAllocEnv() - WSAD and DB2 7.x" Watch "UnsatisfiedLinkError Driver.SQLAllocEnv() - WSAD and DB2 7.x" New topic
Author

UnsatisfiedLinkError Driver.SQLAllocEnv() - WSAD and DB2 7.x

Sam Gehouse
Ranch Hand

Joined: Jul 21, 2003
Posts: 281
I am trying to connecting to DB2 7.x from WSAD. db2java.zip is in classpath of WSAD.

However, I am getting the error below. Any help will be appreciated.

COM/ibm/db2/jdbc/app/DB2Driver.SQLAllocEnv()I
java.lang.UnsatisfiedLinkError: COM/ibm/db2/jdbc/app/DB2Driver.SQLAllocEnv()I
at java.lang.Throwable.<init>(Throwable.java:59)
at java.lang.Throwable.<init>(Throwable.java:73)
at java.lang.UnsatisfiedLinkError.<init>(UnsatisfiedLinkError.java:49)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:244)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:129)
at java.lang.Class.initializeImpl(Native Method)
at java.lang.Class.initialize(Class.java)
at COM.ibm.db2.jdbc.DB2BaseDataSource.isLoaded(DB2BaseDataSource.java:354)
at COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource.getPooledConnection(DB2ConnectionPoolDataSource.java:100)
at COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource.getPooledConnection(DB2ConnectionPoolDataSource.java:72)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:759)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:111)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:754)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:641)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:726)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1281)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1065)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1603)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:677)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:461)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:217)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:192)
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2499
    
    8

db2java.zip is in classpath of WSAD
Did you install the DB2 client software? The UnsatisfiedLinkError indicates that your driver can't find DB2's client libraries.

Configure DB2 remote connectivity with WebSphere DataStage Enterprise Edition.
Step 1. Install DataStage Enterprise Edition(DS/EE) and DB2 client

Regards, Jan
[ May 02, 2007: Message edited by: Jan Cumps ]

OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: UnsatisfiedLinkError Driver.SQLAllocEnv() - WSAD and DB2 7.x