| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem with JDBC connector |
« View previous topic :: View next topic » |
| Author |
Message
|
| garimellasp |
 Posted: Mon Sep 04, 2006 5:34 am Post subject: Problem with JDBC connector |
 |
|
Newbie
Joined: 31 Aug 2006
Posts: 6
|
I'm using JDBC connector along with MB V 5 .
Based on the records in the Event Table I'm trying to retrieve some from another table(Eai_trg_batch) and create a BO which will be posted to a Q.
I'm getting the following error while starting the JDBC connector.
[Version:4.3.0.0][TZ:America/New_York]
[Time: 2006/09/04 08:52:01.786] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Info] [MsgID: 17000] [Mesg: Initialization started. Name: SPDJDBCConnector. ConfigFileName: C:\IBM\WebSphereAdapters\connectors\SPDJDBC\SPDJDBC.cfg. Implementation DLL/Class Name: com.crossworlds.connectors.JDBC.JDBCConnectorAgent.class.]
[Time: 2006/09/04 08:52:01.796] [System: Server] [Thread: wbia_main (#730944395)] [Mesg: Privacy is NOT initialized. Reason: The privacy is NOT turned on.]
[Version:4.3.0.0][TZ:America/New_York]
[Time: 2006/09/04 08:52:02.257] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Trace] [MsgID: 17016] [Mesg: Initializing connector SPDJDBCConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Time: 2006/09/04 08:52:02.277] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Error] [MsgID: 33018] [Mesg: Setting TimingStats to default.]
[Time: 2006/09/04 08:52:02.277] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Internal Warning] [MsgID: 33027] [Mesg: Setting PreparedStatementCacheSize to default.]
[Time: 2006/09/04 08:52:04.049] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Info] [MsgID: 17066] [Mesg: Application state is connected]
[Time: 2006/09/04 08:52:04.209] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Info] [MsgID: 9055] [Mesg: Using Client connection to the Queue Manager.]
[Time: 2006/09/04 08:52:04.660] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: ClientPacketSyncDrvFormatterSPDJDBCConnector (#737203083)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is active.]
[Time: 2006/09/04 08:52:04.790] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: wbia_main (#730944395)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2006/09/04 08:52:05.812] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 occurred]
[Time: 2006/09/04 08:52:05.812] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/09/04 08:52:05.812] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 17050] [Mesg: The call to method poll() in the application connector failed.]
[Time: 2006/09/04 08:52:16.207] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 occurred]
[Time: 2006/09/04 08:52:16.207] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/09/04 08:52:16.207] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 17050] [Mesg: The call to method poll() in the application connector failed.]
[Time: 2006/09/04 08:52:26.622] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 occurred]
can any one help me to find out where i'm doing the mistake.
Thank you
Satya |
|
| Back to top |
|
 |
| djeripo |
| Posted: Mon Sep 04, 2006 10:36 am Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
| Quote: |
| [Time: 2006/09/04 08:52:16.207] [System: ConnectorAgent] [SS: SPDJDBCConnector] [Thread: appPolling (#734565259)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 occurred] |
Is the event picked up from the Event table?If not whats the EVENT_STATUS?
If its picked up by the connector,What the EVENT_STATUS in XWORLDS_ARCHIVE_EVENTS table?
Whats the triggering mechanism you are using? |
|
| Back to top |
|
|
| garimellasp |
| Posted: Mon Sep 04, 2006 1:34 pm Post subject: |
|
|
Newbie
Joined: 31 Aug 2006
Posts: 6
|
Hey aparichithudu,
There is a problem with the event table data, and it was cleared . Now the JDBC is up and running.
Thank you,
Remo..... |
|
| 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
|
|
|
|
