| Author |
Message
|
| veggiehui |
 Posted: Wed Mar 22, 2006 10:38 pm Post subject: Ask for your help---jdbc adapter startup |
 |
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Dear all,
when I start my jdbc adapter, some messages as below,pls kindly tell me if it's normal.or something in process is incorrect.
| Code: |
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17008] [Mesg: Polling every 10000 milliseconds.] ]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: Thread:appPolling:ex
ecuting poll call]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :Polling App Connect
or.]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33007] [Mesg: Unable to complete TLS setup. A key store file was specifiedw
ithout all the corresponding private key and/or identity certificateinformation.
] ]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33024] [Mesg: A duplicate transport-layer security context already existsfo
r component {2} of type {1}.] ]
[Time: 2006/03/23 14:41:41.734] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552666816)] [Type: Trace] [Mesg: :checkStatus] |
|
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Mar 22, 2006 10:55 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Are you using SSL?
What is your adapter configuration (what have you done so far???) |
|
| Back to top |
|
|
| veggiehui |
| Posted: Wed Mar 22, 2006 11:07 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
| I'm working with a synchronize from one database to another, both are oracle database,I have two Asbos, a GBO, and are supported to corresponding connector, Associated Map is up for them.the connectors are OK within Test Connector. |
|
| Back to top |
|
|
| veggiehui |
| Posted: Wed Mar 22, 2006 11:09 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
I think my adapter config is ok.
[color=#444444]JDBCDRIVERPATH=C:\Oracle\Ora81\jdbc\lib\classes12.zip[/color]
....
%CWJAVA% -mx128m -ms64m -Djava.ext.dirs="%MQ_LIB%";%JRE_EXT_DIRS% -Djava.library.path="%CROSSWORLDS%"\bin;%CONNDIR%;C:\Oracle\Ora81\bin;"%MQ_LIB%";%JRE_EXT_DIRS% %ORB_PROPERTY% -Duser.home="%CROSSWORLDS%" -cp %JCLASSES%;%CONNDIR%\%CONNJAR%; AppEndWrapper -l%CONNPACKAGENAME% -n%CONNAME%Connector -s%SERVER% %3 %4 %5 |
|
| Back to top |
|
|
| veggiehui |
| Posted: Wed Mar 22, 2006 11:28 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
this is the details:
When I start up my JDBC Adapter , I found if there's one record or no record in xworlds_events,the messges should be:
| Quote: |
[Time: 2006/03/23 15:22:47.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Error] [MsgID: 17050] [Mesg: The c
all to method poll() in the application connector failed.]
[Time: 2006/03/23 15:22:47.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :getTypeForDeliveryT
ransport = IDL]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17008] [Mesg: Polling every 10000 milliseconds.] ]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: Thread:appPolling:ex
ecuting poll call]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :Polling App Connect
or.]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33007] [Mesg: Unable to complete TLS setup. A key store file was specifiedw
ithout all the corresponding private key and/or identity certificateinformation.
] ]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33024] [Mesg: A duplicate transport-layer security context already existsfo
r component {2} of type {1}.] ]
[Time: 2006/03/23 15:22:57.438] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :checkStatus] |
if there's two or more records in xworlds_events,below messages will be displayed:
| Quote: |
[Time: 2006/03/23 15:22:13.656] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17008] [Mesg: Polling every 10000 milliseconds.] ]
[Time: 2006/03/23 15:22:13.656] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: Thread:appPolling:ex
ecuting poll call]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :Polling App Connect
or.]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33007] [Mesg: Unable to complete TLS setup. A key store file was specifiedw
ithout all the corresponding private key and/or identity certificateinformation.
] ]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Error] [MsgID: 17109] [Mesg: Excep
tion caught in the method BusObjJavaInterface::poll. Reason: java.lang.NullPoint
erException]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Error] [MsgID: 17050] [Mesg: The c
all to method poll() in the application connector failed.]
[Time: 2006/03/23 15:22:13.672] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552668343)] [Type: Trace] [Mesg: :getTypeForDeliveryT
ransport = IDL] |
|
|
| Back to top |
|
|
| vennela |
| Posted: Thu Mar 23, 2006 8:53 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What is your trace level?
If it is not at the highest level, increase it and see |
|
| Back to top |
|
|
| veggiehui |
| Posted: Thu Mar 23, 2006 5:07 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Dear vennela,
thanks for your reply, I had already set it 5.I try to fix the adapter shortcut , set the target field from:C:\IBM\WebSphereServer\connectors\JDBC_GZSAMP\start_JDBC.bat JDBC_GZSAMP WebSphereICS
to C:\IBM\WebSphereServer\connectors\JDBC_GZSAMP\start_JDBC.bat
JDBC_GZSAMP WebSphereICS
-cconnectors\JDBC_GZSAMP\JDBC_GZSAMPConnector.cfg;
now,it's ok when start up the adapter,but when insert into a record to source table, still some errors occured,
| Quote: |
[Time: 2006/03/24 09:03:51.359] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17008] [Mesg: Polling every 10000 milliseconds.] ]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :[Type: Trace] [MsgI
D: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: Thread:appPolling:ex
ecuting poll call]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :Polling App Connect
or.]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :[Type: Warning] [Ms
gID: 33007] [Mesg: Entering pollForEvents] ]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Error] [MsgID: 17109] [Mesg: Excep
tion caught in the method BusObjJavaInterface::poll. Reason: java.lang.NullPoint
erException]
[Time: 2006/03/24 09:03:57.000] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/03/24 09:03:57.016] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Error] [MsgID: 17050] [Mesg: The c
all to method poll() in the application connector failed.]
[Time: 2006/03/24 09:03:57.016] [System: ConnectorAgent] [SS: JDBC_GZSAMPConnect
or] [Thread: appPolling (#1552437785)] [Type: Trace] [Mesg: :getTypeForDeliveryT
ransport = IDL] |
Is it caused by my adapter configure?or the problem from my compoments and their relationship? |
|
| Back to top |
|
|
| vk |
| Posted: Fri Mar 24, 2006 6:06 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Can you post the configuration file values for the connector?
| Quote: |
[Mesg: Excep
tion caught in the method BusObjJavaInterface::poll. Reason: java.lang.NullPoint
erException] |
Has the event table name been mentioned correctly?
Regards,
VK. |
|
| Back to top |
|
|
| veggiehui |
| Posted: Sun Mar 26, 2006 5:24 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Dear VK,
Eventtablename has been set correctly.I got below messages when I start up ICS, note the bold part, Is it reason caused?Please kindly tell me action required.
| Quote: |
[Time: 2006/03/27 09:22:28.750] [System: Server] [Thread: main (#511725536)] [Type: Info] [MsgID: 123] [Mesg: Stack Tracing related variable STACK_TRACE_ENABLED not found in the configuration file, using the default value of false for this config parameter]
[Time: 2006/03/27 09:22:28.750] [System: Server] [Thread: main (#511725536)] [Type: Info] [MsgID: 159] [Mesg: Using default value 0 for configuration parameter MQSERIES_TRACE_LEVEL in subsystem TRACING.]
[Time: 2006/03/27 09:22:28.750] [System: Server] [Thread: main (#511725536)] [Type: Info] [MsgID: 159] [Mesg: Using default value C:\IBM\WebSphereServer\mqseries\CwMQ.trc for configuration parameter MQSERIES_TRACE_FILE in subsystem TRACING.]
[Time: 2006/03/27 09:22:28.781] [System: Server] [Thread: main (#511725536)] [Type: Info] [MsgID: 22] [Mesg: WebSphere InterChange Server. Initializing server "WebSphereICS", Version = 4.3.1.0.]
[Time: 2006/03/27 09:22:33.109] [System: Server] [Thread: P=548828:O=0:CT (#511725536)] [Type: Warning] [MsgID: 188] [Mesg: Error in loading com.ibm.db2.jdbc.app.DB2Driver, the Driver cannot be used in User Defined Database connections or in Relationships by the ICS.] [Time: 2006/03/27 09:22:33.281] [System: Server] [Thread: P=548828:O=0:CT (#511725536)] [Type: Info] [MsgID: 23] [Mesg: Begin engine initialization.]
[Time: 2006/03/27 09:22:33.281] [System: Server] [Thread: P=548828:O=0:CT (#511725536)] [Type: Info] [MsgID: 2788] [Mesg: Initializing server in Production-mode.]
[Time: 2006/03/27 09:22:33.297] [System: Server] [Thread: P=548828:O=0:CT (#511725536)] [Type: Info] [MsgID: 5531] [Mesg: The value specified in the InterchangeSystem config file for the parameter MAX_DEADLOCK_RETRY_COUNT could not be read. A default value of 5 will be used instead.] |
|
|
| Back to top |
|
|
| vk |
| Posted: Sun Mar 26, 2006 6:26 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
I am not familiar with ICS. I used JDBC adapter with WMQI broker. So I cannot help you with starting of ICS.
What is the version of the DB2 database you are connecting to? For 8.2 database he driver class path is -
com.ibm.db2.jcc.DB2Driver
Check if you hve the correct driver JAR file.
Regards,
VK. |
|
| Back to top |
|
|
| veggiehui |
| Posted: Mon Mar 27, 2006 4:39 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
My program has been suspended for several days,for my ICS warning for error loading com.ibm.db2.jcc.DB2Driver,if I can ignore it?
The primary problem is I have no any experience in Collaboration, so I doubt something wrong with it.I will post my program details here for your reference, hope you can help me.thanks in advance.
by the way, who can show me some examples for Collaboration dev?thanks in advance again. |
|
| Back to top |
|
|
| Curry |
| Posted: Mon Mar 27, 2006 4:44 pm Post subject: |
|
|
Newbie
Joined: 22 Feb 2006
Posts: 7
|
Check the message file. Make sure that you have JDBCConnector.txt file in %WBI%\connectors\messages folder. Also ensure that the error number matches with the error number in the file. I've seen these errors when the connector message file did not exist or if it was pointing to a wrong location..
Good luck |
|
| Back to top |
|
|
| veggiehui |
| Posted: Mon Mar 27, 2006 5:03 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Yes, I had copied the JDBCConnetor.txt there and rename it,and configure it in related Connector, I don't understand what "error number matches with the error number in the file", which error number should I get, the message ID?
million thanks |
|
| Back to top |
|
|
| Kram |
| Posted: Tue Mar 28, 2006 6:52 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006
Posts: 87
|
[Mesg: Error in loading com.ibm.db2.jdbc.app.DB2Driver, the Driver cannot be used in User Defined Database connections or in Relationships by the ICS.]
The Error is a warning .. yes you can ignore it. the problem you will get is when you have relationship tables or DBconnection pools to be deployed. This error has nothing to do with the JDBCconnector.txt file since this is a ICS generated warning.
_________________
Regards,
Ram |
|
| Back to top |
|
|
|
|
