| Author |
Message
|
| venky |
 Posted: Wed May 10, 2006 1:12 pm Post subject: JDBC Adapter with Process server. |
 |
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Hi All,
Iam trying to start the JDBC Adapter and its giving me the following error. Can anyone please help me in this.
after executing a set of commands, the adapter fails at this point....
C:\IBM\WebSphereAdapters\connectors\Caesar>call "C:\IBM\WebSphereAdapters\bin\start_adapter" -nCaesarConnector -sWMQI_WAS -lcom.crossworlds.connectors.JDBC.JDBCConnectorAgent -cC:\IBM\WebSphereAdapters\connectors\CaesarConnector.cfg
Usage: java [-options] class [args...]
(to execute a class)
or java [-jar] [-options] jarfile [args...]
(to execute a jar file)
where options include:
-cp -classpath <directories and zip/jar files separated by ;>
set search path for application classes and resources
-D<name>=<value>
set a system property
-verbose[:class|gc|jni]
enable verbose output
-version print product version
-showversion print product version and continue
-? -help print this help message
-X print help on non-standard options
-assert print help on assert options
Press any key to continue . . .
Regards
Venky |
|
| Back to top |
|
 |
| venky |
| Posted: Wed May 10, 2006 3:59 pm Post subject: |
|
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Hi All,
I have this new problem when starting the JDBC Adapter. My DB2 V is 8.2. I successfuly configured the JDBC Adapter and when trying to start it I got the following error.
The CLASSPATH is set and is pointing to db2jcc.jar
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Trace] [Mesg: :QueryTimeOut=False]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Trace] [Mesg: :SelectiveCommitForPoll=null]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of configuration properties] ]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Error] [MsgID: 36001] [Mesg: Could not instantiate the required JDBC driver classes. Reason java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver.]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/10 18:53:26.719] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.][Time: 2006/05/10 18:53:26.734] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Trace] [Mesg: :getTypeForDeliveryTransport = JMS]
[Time: 2006/05/10 18:53:26.734] [System: ConnectorAgent] [SS: CaesarConnector] [Thread: wbia_main (#723886355)] [Type: Fatal Error] [MsgID: 17518] [Mesg: Exhausted the configured number of 3 restart retries for serial connector agent CaesarConnector. Shutting down.]
Press any key to continue . . .
Any help is appreciated.
Regards,
Venky.. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed May 10, 2006 5:26 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| You should have db2java.zip in the classpath |
|
| Back to top |
|
|
| venky |
| Posted: Wed May 10, 2006 7:05 pm Post subject: |
|
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Yes, I do have db2java.zip in my classpath - Still Iam facing the same problem.
My DB2 Level is as follows - DB2 v8.1.7.445
Here is a snap shot of my CLASSPATH Variables.
C:\IBM\SQLLIB\java\db2java.zip;
C:\IBM\SQLLIB\java\db2jcc.jar;
C:\IBM\SQLLIB\java\sqlj.zip;
C:\IBM\SQLLIB\java\db2jcc_license_cu.jar;
C:\IBM\SQLLIB\bin;
C:\IBM\SQLLIB\java\common.jar;
C:\IBM\WebSphere MQ\Java\lib\providerutil.jar;
C:\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\IBM\WebSphere MQ\Java\lib\ldap.jar;
C:\IBM\WebSphere MQ\Java\lib\jta.jar;
C:\IBM\WebSphere MQ\Java\lib\jndi.jar;
C:\IBM\WebSphere MQ\Java\lib\jms.jar;
C:\IBM\WebSphere MQ\Java\lib\connector.jar;
C:\IBM\WebSphere MQ\Java\lib\fscontext.jar;
C:\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar;
C:\Program Files\IBM\CICS Transaction Gateway\classes\ctgsamples.jar;
C:\Program Files\IBM\CICS Transaction Gateway\classes\cicsj2ee.jar;
C:\Program Files\IBM\CICS Transaction Gateway\classes\ctgserver.jar;
C:\Program Files\IBM\CICS Transaction Gateway\classes\ctgclient.jar;.;
Regards...
Venky |
|
| Back to top |
|
|
| shafi |
| Posted: Mon May 15, 2006 12:21 am Post subject: |
|
|
Apprentice
Joined: 19 Mar 2006
Posts: 38
|
Hi,
I got the same problem: it was due to me not installing JMS along with MQ....once i did that, the problem got resolved.
or, compare with other systems that u've got all jar files in the MQ folder right?
Regards,
Shafi. |
|
| Back to top |
|
|
| vennela |
| Posted: Mon May 15, 2006 1:51 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| shafi wrote: |
Hi,
I got the same problem: it was due to me not installing JMS along with MQ....once i did that, the problem got resolved.
|
I don't agree.
Why would an app complain about DB2 jar files if the MQ jars are not installed?
I think even though the db2java.zip is in systems, CLASSPATH, it is not in the apps CLASSPATH. You should look at the start_adapter or one of those adapters and set some env variables to get rid of the problem. |
|
| Back to top |
|
|
|
|
