aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 2531
    
  10

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