|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
JDBC Connector with DB2 |
« View previous topic :: View next topic » |
Author |
Message
|
Vijji |
Posted: Tue Aug 30, 2005 1:30 pm Post subject: JDBC Connector with DB2 |
|
|
 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 |
|
 |
vennela |
Posted: Tue Aug 30, 2005 1:39 pm Post subject: |
|
|
 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 |
|
 |
Vijji |
Posted: Wed Aug 31, 2005 3:41 pm Post subject: |
|
|
 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 |
|
 |
djeripo |
Posted: Wed Aug 31, 2005 8:03 pm Post subject: |
|
|
 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 |
|
 |
Ratan |
Posted: Fri Sep 02, 2005 9:39 am Post subject: |
|
|
 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 |
|
 |
Vijji |
Posted: Mon Sep 05, 2005 6:11 am Post subject: |
|
|
 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]
How can i solve it.
Thanks in advance. |
|
Back to top |
|
 |
hopsala |
Posted: Mon Sep 05, 2005 3:55 pm Post subject: |
|
|
 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 |
|
 |
|
|
 |
|
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
|
|
|
|