|   | 
	 
  
    | 
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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |