ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with JDBC connector

Post new topic  Reply to topic
 Problem with JDBC connector « View previous topic :: View next topic » 
Author Message
garimellasp
PostPosted: Mon Sep 04, 2006 5:34 am    Post subject: Problem with JDBC connector Reply with quote

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
View user's profile Send private message
djeripo
PostPosted: Mon Sep 04, 2006 10:36 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
garimellasp
PostPosted: Mon Sep 04, 2006 1:34 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with JDBC connector
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.