This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 2491
    
    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
 
Similar Threads
WSAD 5.1.2 - DB2 DSRA8100E: Unable to get a XAConnection from the DataSource
no db2jdbc in java.library.path
WSAD DatastoreAdapterException
Error while connecting DB2 from WSAD(Urgent Pls)
UnsatisfiedLinkError: SQLAllocEnv in DB2 Connection