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 » General Discussion » JDBC Connector with DB2

Post new topic  Reply to topic
 JDBC Connector with DB2 « View previous topic :: View next topic » 
Author Message
Vijji
PostPosted: Tue Aug 30, 2005 1:30 pm    Post subject: JDBC Connector with DB2 Reply with quote

Voyager

Joined: 30 Aug 2005
Posts: 83

Hi,

I am new to JDBC adapter(V2.6 and Frame work 2.6).
I got a Business Object from DB2(V7.1) using the JDBC Adapter. I configured the connector and inserted data in to event table. When I tried to start the connector from the StartUp menu, after some time it goes to hang up position.

Please tell me how can I solve the problem.
Thanks in Advance
Back to top
View user's profile Send private message
vennela
PostPosted: Tue Aug 30, 2005 1:39 pm    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

That wont work.
You will have to start the adapter like this:

start_JDBC JDBC -sICSServer -cConfigurationFile.cfg

Also, what else have you done other than creating BO's?
How did you configure your adapter?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Vijji
PostPosted: Wed Aug 31, 2005 3:41 pm    Post subject: Reply with quote

Voyager

Joined: 30 Aug 2005
Posts: 83

vennela wrote:
That wont work.
You will have to start the adapter like this:

start_JDBC JDBC -sICSServer -cConfigurationFile.cfg

Also, what else have you done other than creating BO's?
How did you configure your adapter?


Hi,
Thanks for u reply.I am connecting to WBIMB. I specified the connector specification properties are like the below:

ApplicationPassword db2admin 0 String agent restart
ArchiveProcessed True 0 Boolean agent restart
ArchiveTableName xworlds_archive_events 0 String agent restart
AutoCommit False 0 Boolean agent restart
CheckForEventTableInInit True 0 Boolean agent restart
ChildUpdatePhyDelete False 0 Boolean agent restart
CloseDBConnection False 0 Boolean agent restart
ConnectorID NONE 0 String agent restart
DatabaseURL jdbc:db2:EXAMPLE 0 String agent restart
DateFormat MM/dd/yyyy HH:mm:ss 0 String agent restart
DriverConnectionProperties 0 String agent restart
MaximumDatabaseConnections 5 0 String agent restart
PingQuery 0 String agent restart
PollQuantity 1 0 String The number of items to poll from application agent restart
PreserveUIDSeq True 0 Boolean agent restart
QueryTimeOut False 0 String agent restart
RDBMS.initsession 0 String agent restart
RDBMSVendor DB2 0 String agent restart
RetryCountAndInterval 3,20 0 String agent restart
ReturnDummyBOForSP False 0 String agent restart
SchemaName 0 String agent restart
UniqueIDTableName xworlds_uid 0 String agent restart
UseDefaults False 0 String agent restart
UseDefaultsForCreatingChildBOs False 0 Boolean agent restart
UseDefaultsWhenPolling True 0 String Allows to control setting defaults on BO, on a poll. agent restart
UseDefaultsForRetrieve False 0 Boolean agent restart
DriverSupportForLong True 0 Boolean agent restart
EventKeyDel ; 0 String agent restart
EventOrderBy 0 String agent restart
EventQueryType Fixed 0 String agent restart
EventTableName xworlds_events 0 String agent restart
JDBCDriverClass COM.ibm.db2.jdbc.app.DB2Driver 0 String agent restart
ApplicationUserName db2admin 0 String

agent restart

And i also i have mentoned the .cfg file path in Connector properties.How can i solve it.
Back to top
View user's profile Send private message
djeripo
PostPosted: Wed Aug 31, 2005 8:03 pm    Post subject: Reply with quote

Master

Joined: 25 Jan 2004
Posts: 225

Do you have db2java.zip in the classpath ?
Does your ../WebSphereAdapters/bin point to db2jdbc.dll ?

If you have above them configured correctly,post the error you are getting during the connector start up.
Back to top
View user's profile Send private message Visit poster's website
Ratan
PostPosted: Fri Sep 02, 2005 9:39 am    Post subject: Reply with quote

Grand Master

Joined: 18 Jul 2002
Posts: 1245

Post your log entries in the Connector log file and the trace file.
_________________
-Ratan
Back to top
View user's profile Send private message Send e-mail
Vijji
PostPosted: Mon Sep 05, 2005 6:11 am    Post subject: Reply with quote

Voyager

Joined: 30 Aug 2005
Posts: 83

Ratan wrote:
Post your log entries in the Connector log file and the trace file.


Hi,
I have the db2java.zip in classpath and db2jdbc.dll file in adapterJRE .But it won't work.I'm getting the below trace file


[Version:4.3.0.0][TZ:America/New_York]
[Time: 2005/09/05 10:04:13.100] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Info] [MsgID: 17000] [Mesg: Initialization started. Name: JDBCConnector. ConfigFileName: C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg. Implementation DLL/Class Name: com.crossworlds.connectors.JDBC.JDBCConnectorAgent.class.]
[Time: 2005/09/05 10:04:13.116] [System: Server] [Thread: wbia_main (#1082211103)] [Mesg: Privacy is NOT initialized. Reason: The privacy is NOT turned on.]
[Version:4.3.0.0][TZ:America/New_York]
[Time: 2005/09/05 10:04:13.709] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [MsgID: 17016] [Mesg: Initializing connector JDBCConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Error] [MsgID: 33018] [Mesg: Setting TimingStats to default.]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Internal Warning] [MsgID: 33027] [Mesg: Setting PreparedStatementCacheSize to default.]


And i'm getting the below logfile :




[Version:4.3.0.0][TZ:America/New_York]
[Time: 2005/09/05 10:04:13.287] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: ******* Tracing all property values *******]
[Time: 2005/09/05 10:04:13.303] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PollEndTime PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS HH:MM]
[Time: 2005/09/05 10:04:13.303] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ConfigFile PROPERTY IS from Command Line. PROPERTY VALUE IS C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg]
[Time: 2005/09/05 10:04:13.303] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME CommonEventInfrastructure PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.303] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME BrokerType PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS WMQI]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME EnableOidForFlowMonitoring PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RepositoryDirectory PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS C:\IBM\WebSphereAdapters\Tools\WSWB212\Workspace\JDBC\BusinessObjects]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RFH2MessageDomain PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS mrm]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME SynchronousRequestQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ClassFileName PROPERTY IS from Command Line. PROPERTY VALUE IS com.crossworlds.connectors.JDBC.JDBCConnectorAgent]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME UniqueIDTableName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS xworlds_uid]
[Time: 2005/09/05 10:04:13.350] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME JDBCDriverClass PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS COM.ibm.db2.jdbc.app.DB2Driver]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME UseDefaultsWhenPolling PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS True]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DontSpawnSlaves PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AdminOutQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/ADMINOUTQUEUE]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME MessageFileName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCConnector.txt]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME SendQueue PROPERTY IS default value. PROPERTY VALUE IS AP/JDBCConnector/WMQI_WAS]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ThreadingModel PROPERTY IS default value. PROPERTY VALUE IS MULTI_THREADED]
[Time: 2005/09/05 10:04:13.366] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AdapterHelpName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME CheckForEventTableInInit PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS True]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PreserveUIDSeq PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS True]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME UseDefaultsForCreatingChildBOs PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME EventTableName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS xworlds_events]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RestartRetryCount PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 3]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DLLFileName PROPERTY IS default value. PROPERTY VALUE IS AppConn]
[Time: 2005/09/05 10:04:13.381] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DeliveryTransport PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JMS]
[Time: 2005/09/05 10:04:13.412] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME BiDi.Transformation PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.428] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME QueryTimeOut PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.459] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ConnectorName PROPERTY IS from Command Line. PROPERTY VALUE IS JDBCConnector]
[Time: 2005/09/05 10:04:13.459] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PollQuantity PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 1]
[Time: 2005/09/05 10:04:13.459] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME UseDefaults PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.459] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME SchemaName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.459] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME MaximumDatabaseConnections PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 5]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME CloseDBConnection PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME CDKVersion PROPERTY IS default value. PROPERTY VALUE IS 4.3.0]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME jms.MessageBrokerName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS WBRK_QM]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AgentRole PROPERTY IS default value. PROPERTY VALUE IS Master]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ResponseQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/RESPONSEQUEUE]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME LOG_FILE PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS C:\Documents and Settings\uavuthu\Desktop\log.log]
[Time: 2005/09/05 10:04:13.475] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME Locale PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS en_US]
[Time: 2005/09/05 10:04:13.490] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ResultsSetEnabled PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.490] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DriverSupportForLong PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS True]
[Time: 2005/09/05 10:04:13.490] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME EventKeyDel PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ;]
[Time: 2005/09/05 10:04:13.490] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RunAgentInBackGround PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.490] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ApplicationPassword PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS db2admin]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PollFrequency PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 10000]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PingQuery PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME InterchangeName PROPERTY IS from Command Line. PROPERTY VALUE IS WMQI_WAS]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DeliveryQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/DELIVERYQUEUE]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME jms.NumConcurrentRequests PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 10]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AdminInQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/ADMININQUEUE]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PassPhrase PROPERTY IS default value. PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RestartRetryInterval PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 1]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME SynchronousResponseQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/SYNCHRONOUSRESPONSEQUEUE]
[Time: 2005/09/05 10:04:13.506] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME XMLNameSpaceFormat PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS long]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DriverConnectionProperties PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ApplicationName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCConnector]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DuplicateEventElimination PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME IBM-CW-TEMPLATE-NAME-INTERNAL PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCConnectorTemplate]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME jms.Password PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ********]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME TivoliMonitorTransactionPerformance PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.522] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ChildUpdatePhyDelete PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME WireFormat PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS CwXML]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AvoidTransportLayer PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME LogAtInterchangeEnd PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME EventQueryType PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS Fixed]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DateFormat PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS MM/dd/yyyy HH:mm:ss]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME PollStartTime PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS HH:MM]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME jms.FactoryClassName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS CxCommon.Messaging.jms.IBMMQSeriesFactory]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AgentTraceLevel PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 5]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RestartRetryAttemptNumber PROPERTY IS default value. PROPERTY VALUE IS 0]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RetryCountAndInterval PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 3,20]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ConnectorID PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS NONE]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ArchiveTableName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS xworlds_archive_events]
[Time: 2005/09/05 10:04:13.537] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME NativeConnector PROPERTY IS default value. PROPERTY VALUE IS false]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME JavaConnector PROPERTY IS from Command Line. PROPERTY VALUE IS true]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ApplicationUserName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS db2admin]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ContainerManagedEvents PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ListenQueue PROPERTY IS default value. PROPERTY VALUE IS IC/WMQI_WAS/JDBCConnector]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME EventOrderBy PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ReposPassword PROPERTY IS default value. PROPERTY VALUE IS null]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ArchiveProcessed PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS True]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME UseDefaultsForRetrieve PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.553] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME AutoCommit PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ReadKeyboard PROPERTY IS default value. PROPERTY VALUE IS true]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RequestQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/REQUESTQUEUE]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RDBMSVendor PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS DB2]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME SynchronousRequestTimeout PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS 0]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME FaultQueue PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS JDBCCONNECTOR/FAULTQUEUE]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME ReturnDummyBOForSP PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS False]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME TRACE_FILE PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS C:\Documents and Settings\uavuthu\Desktop\trace.trc]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME RDBMS.initsession PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME DatabaseURL PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS jdbc:db2:EXAMPLE]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME jms.UserName PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS uavuthu]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: PROPERTY NAME CharacterEncoding PROPERTY IS from Config file C:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg PROPERTY VALUE IS ascii7]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: ******* Finished tracing all property values *******]
[Time: 2005/09/05 10:04:13.569] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: Using Message file:C:\IBM\WebSphereAdapters\connectors\messages\JDBCConnector.txt]
[Time: 2005/09/05 10:04:13.631] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :AgentBusObjManager]
[Time: 2005/09/05 10:04:13.694] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: : version :1.8.0]
[Time: 2005/09/05 10:04:13.694] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :Loaded App Connector: com.crossworlds.connectors.JDBC.JDBCConnectorAgent]
[Time: 2005/09/05 10:04:13.694] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: Thread:wbia_main:Application Calls are made directly from calling thread]
[Time: 2005/09/05 10:04:13.709] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :init]
[Time: 2005/09/05 10:04:13.709] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: Thread:wbia_main:executing init call]
[Time: 2005/09/05 10:04:13.709] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :Initializing App Connector.]
[Time: 2005/09/05 10:04:13.709] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17016] [Mesg: Initializing connector JDBCConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.] ]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering Initialization of configuration properties] ]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :applicationName=JDBCConnector]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ApplicationUserName=db2admin]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ApplicationPassword= ***** ]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :databaseURL=jdbc:db2:EXAMPLE]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :archiveProcessed=True]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :archiveTableName=xworlds_archive_events]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :eventKeyDel=;]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :eventTableName=xworlds_events]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :uniqueIDTableName=xworlds_uid]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :pollQuantity=1]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :retryCountAndInterval=3,20]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :retryCount=3]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :retryInterval=20]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :skipRetrieve=null]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :timingStats=0]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :MaximumDatabaseConnections=5]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ConnectorID=NONE]
[Time: 2005/09/05 10:04:13.725] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :RDBMSVendor=DB2]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ReplaceAllStr=false]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ReturnDummyBOForSP=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :PreparedStatementCacheSize=null]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :StrDelimiter=null]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ReplaceStrList=null]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :ChildUpdatePhyDelete=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :PingQuery=]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :JDBCDriverClass=COM.ibm.db2.jdbc.app.DB2Driver]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :EventOrderBy=]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :DateFormat=MM/dd/yyyy HH:mm:ss]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :AutoCommit=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :SchemaName=]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :EventQueryType=Fixed]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :PreserveUIDSeq=True]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :CloseDBConnection=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :SPBeforePollCall=null]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :CheckForEventTableInInit=True]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :DriverConnectionProperties=]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :DriverSupportForLong=True]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :UseDefaultsForCreatingChildBOs=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of configuration properties] ]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :UseDefaultsWhenPolling=True]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :QueryTimeOut=False]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :SelectiveCommitForPoll=null]
[Time: 2005/09/05 10:04:13.740] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of configuration properties] ]
[Time: 2005/09/05 10:04:13.912] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering fetchConnection] ]
[Time: 2005/09/05 10:04:13.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36011] [Mesg: Auto Commit is False] ]
[Time: 2005/09/05 10:04:13.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36004] [Mesg: Obtained connection.] ]
[Time: 2005/09/05 10:04:13.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39015] [Mesg: Number of DB Connections in Use 1] ]
[Time: 2005/09/05 10:04:13.975] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting fetchConnection] ]
[Time: 2005/09/05 10:04:13.990] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering fetchConnection] ]
[Time: 2005/09/05 10:04:14.022] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36011] [Mesg: Auto Commit is False] ]
[Time: 2005/09/05 10:04:14.022] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36004] [Mesg: Obtained connection.] ]
[Time: 2005/09/05 10:04:14.022] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39015] [Mesg: Number of DB Connections in Use 2] ]
[Time: 2005/09/05 10:04:14.022] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting fetchConnection] ]
[Time: 2005/09/05 10:04:18.897] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering releaseConnection] ]
[Time: 2005/09/05 10:04:18.897] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting releaseConnection] ]
[Time: 2005/09/05 10:04:18.928] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :select event_id, connector_id, object_key, object_name, object_verb, event_priority, event_time, event_status, event_comment from xworlds_events where event_status = ? order by event_time, event_priority]
[Time: 2005/09/05 10:04:18.928] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37016] [Mesg: Values that are being set on the PreparedStatement:] ]
[Time: 2005/09/05 10:04:18.928] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :0]
[Time: 2005/09/05 10:04:18.928] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#1082211103)] [Type: Trace] [Mesg: :3] [/list]
Quote:


    How can i solve it.
    Thanks in advance.
    Back to top
    View user's profile Send private message
    hopsala
    PostPosted: Mon Sep 05, 2005 3:55 pm    Post subject: Reply with quote

    Guardian

    Joined: 24 Sep 2004
    Posts: 960

    vijji wrote:
    (#1082211103)] [Type: Trace] [Mesg: :select event_id, connector_id, object_key, object_name, object_verb, event_priority, event_time, event_status, event_comment from xworlds_events where event_status = ? order by event_time, event_priority]

    Hm, It is possible your adapter is working - this line usually denotes that the adapter is polling for events - but it's difficult to tell; it's not that it's "hanged" but maybe simply waiting for events to be written to events table. (p.s the message "error: Timing stats set to default" is not serious, you can ignore it for now)
    First and foremost, you should set Agent and Connector trace level to 5 and look at that log, we'll all be a lot smarter for it. If you see "polling for events" there - it means that you simply have no events in table, or no subscribers for those events.

    Another option is that its waiting for the BO's from the broker - are you using WBI or ICS? In any event, set trace to higher levels, this should give you the answer.
    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 » General Discussion » JDBC Connector with DB2
    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.