| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| db2 - jdbc adapter - java.sql.SQLException?? |
« View previous topic :: View next topic » |
| Author |
Message
|
| shafi |
 Posted: Wed Aug 09, 2006 2:55 am Post subject: db2 - jdbc adapter - java.sql.SQLException?? |
 |
|
Apprentice
Joined: 19 Mar 2006
Posts: 38
|
Hi all,
I am getting the following error
"[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Error] [MsgID: 36001] [Mesg: Could not instantiate the required JDBC driver classes. Reason java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't find library db2jdbc (db2jdbc.dll) in sun.boot.library.path or java.library.path
sun.boot.library.path=C:\IBM\WebSphereAdapters\AdapterJRE\bin
java.library.path=C:\IBM\WebSphereAdapters\AdapterJRE\bin;C:\IBM\WebSphereAdapters\bin;C:\PROGRA~1\IBM\WEBSPH~1\java\lib;;;.]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent JDBCConnector.]
[Time: 2006/08/09 16:08:27.985] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBCConnector.]
" while starting my connector. I am using "COM.ibm.db2.jdbc.app.DB2Driver" for the property 'JDBCDriverClass'.
Please lemme know how to rectify it.
Regards,
Shafi |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Aug 09, 2006 3:02 am Post subject: Re: db2 - jdbc adapter - java.sql.SQLException?? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shafi wrote: |
Hi all,
I am getting the following error
"[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Error] [MsgID: 36001] [Mesg: Could not instantiate the required JDBC driver classes. Reason java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't find library db2jdbc (db2jdbc.dll) in sun.boot.library.path or java.library.path
sun.boot.library.path=C:\IBM\WebSphereAdapters\AdapterJRE\bin
java.library.path=C:\IBM\WebSphereAdapters\AdapterJRE\bin;C:\IBM\WebSphereAdapters\bin;C:\PROGRA~1\IBM\WEBSPH~1\java\lib;;;.]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Time: 2006/08/09 16:08:27.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent JDBCConnector.]
[Time: 2006/08/09 16:08:27.985] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1264451744)] [Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBCConnector.]
" while starting my connector. I am using "COM.ibm.db2.jdbc.app.DB2Driver" for the property 'JDBCDriverClass'.
Please lemme know how to rectify it.
Regards,
Shafi |
Is it there? Is the path (quoted immediately below) the one you expect it to be using?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| djeripo |
| Posted: Thu Aug 10, 2006 6:36 am Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
From the following path,
C:\Program Files\IBM\SQLLIB\BIN (I have my DB2 Installed there),copy
db2jdbc.dll and put it in
C:\IBM\WebSphereAdapters\bin
Then re-start your adapter |
|
| Back to top |
|
|
| shafi |
| Posted: Thu Aug 10, 2006 10:06 pm Post subject: |
|
|
Apprentice
Joined: 19 Mar 2006
Posts: 38
|
Hi friends,
It works now. djeripo, u r right!!!. Also in the same way db2java.zip also has to be moved to the lib folder of WBI adapter.
Thanks,
Shafi. |
|
| Back to top |
|
|
| djeripo |
| Posted: Fri Aug 11, 2006 10:55 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
Its(db2java.zip) not really required to move to lib folder.Instead,You can simply provide the path in start_jdbc.bat.
Something like this,
| Code: |
| SET JDBCDRIVERPATH="%DB2_HOME%"\java\db2java.zip |
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
