Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sam Gehouse
Ranch Hand
Posts: 281
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic