| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC adapter Error. |
« View previous topic :: View next topic » |
| Author |
Message
|
| venky |
 Posted: Mon Jun 19, 2006 6:00 pm Post subject: JDBC adapter Error. |
 |
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Hi All,
Iam getting the following error when Iam trying to start the JDBC connector with WBIMB 6.0 as the broker. Has anyone come across this issue ?
is this due to missing jar file in the classpath ? please help.
[System: ConnectorAgent] [SS: -sConnector] [Thread: wbia_main (#727659567)] [Type: Error] [MsgID: 17100] [Mesg: Class com.crossworlds.connectors.JDBC.JDBCConnectorAgent not found. Reason: java.lang.ClassNotFoundException: com.crossworlds.connectors.JDBC.JDBCConnectorAgent]
Thanks a lot,
Venky.. |
|
| Back to top |
|
 |
| vk |
| Posted: Mon Jun 19, 2006 7:37 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
What database is the JDBC connector trying to connect to? What is the jar file which you have?
Make sure that the jar file name and location is given correctly in the connector startup script start_<ConnName>.bat and driver class is given correctly in the configuration file for the connector.
Regards,
VK. |
|
| Back to top |
|
|
| venky |
| Posted: Mon Jun 19, 2006 8:02 pm Post subject: |
|
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Vk,
Iam trying to connect to DB2 V8.2
I have the following lines in the script in start_JDBC.bat:
REM @echo off
REM set the name to be the application connector that starts
set CONNAME=%1
set CONNPACKAGENAME=com.crossworlds.connectors.JDBC.JDBCConnectorAgent
REM Set Connector JAR Name
set CONNJAR=CW%CONNAME%.jar
REM set the server name to be the interchange that is being targeted
set SERVER=%2
REM SET DB2_HOME=C:\PROGRA~1\IBM\SQLLIB
REM Set JVMArgs variable
set JVMArgs=
REM if WBIA_RUNTIME is set use start_adapter launcher to run adapter.
if "%WBIA_RUNTIME%"=="" goto CROSSWORLDS
REM call CWConnEnv
call "%WBIA_RUNTIME%"\bin\CWConnEnv
REM set the directory where the JText adapter resides.
set CONNDIR="%WBIA_RUNTIME%"\connectors\%1
REM goto the connector specific directory
cd /d %CONNDIR%
REM set the variables that are required for the start_adapter callee
SET JDBCDRIVERPATH="%DB2_HOME%"\java\db2java.zip;"%DB2_HOME%"\java\db2jcc.jar;"%DB2_HOME%"\java\db2jcc_license_cu.jar
set DATADIRECT="%WBIA_RUNTIME%"\lib\xwutil.jar;"%WBIA_RUNTIME%"\lib\xwbase.jar;"%WBIA_RUNTIME%"\lib\xwsqlserver.jar;"%WBIA_RUNTIME%"\lib\spy\lib\spy.jar;"%WBIA_RUNTIME%"\lib\xworacle.jar
set JCLASSES=%JCLASSES%;%JDBCDRIVERPATH%;%DATADIRECT%;%CONNDIR%\%CONNJAR%;
call "%WBIA_RUNTIME%\bin\start_adapter" -n%CONNAME%Connector -s%SERVER% -l%CONNPACKAGENAME% %3 %4 %5
Shortcut: In the shortcut bat file, I have the target set as follows:
C:\IBM\WebSphereAdapters\connectors\ConnJDBC\start_JDBC.bat ConnJDBC QUEUE_MANAGER -cC:\IBM\WebSphereAdapters\connectors\ConnJDBC\ConnJDBCConnector.cfg
CWConnJDBC.jar is in the same directrory as the batch files.
Thanks a lot..... |
|
| Back to top |
|
|
| vk |
| Posted: Thu Jun 22, 2006 2:28 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Venky,
What is the JDBCDriverClass property set to in the connector configuration file?
For DB2 v8.2, the jar file is db2jcc.jar and the JDBCDriverClass is com.ibm.db2.jcc.DB2Driver
Regards,
VK. |
|
| 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
|
|
|
|
