| Author |
Message
|
| amateur10 |
 Posted: Mon Dec 12, 2005 9:20 am Post subject: jdbc cONNECTOR CONFIGURATION |
 |
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
I am working on JDBC Connector now. When I tested wtih test connector, it worked, that mean my collab and other components are working. now when i replace test connector with jdbc, it does not work. What i did are as follows:
created the table to write data
created three tables, event, archieve, and uid
change jdbcdriverpath in start_jdbc batch file
still it does not work. Can anyone tell me what else need to be done?
thanks in advance |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Dec 12, 2005 9:32 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What is the error?
Also, how did you fix your test connector |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Dec 12, 2005 9:36 am Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
| Quote: |
| still it does not work. Can anyone tell me what else need to be done? |
What do you mean by 'does not work'?Please learn basics .Not in ICS,In asking questions |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 9:42 am Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
VT Connector start problem was with my office comp. This is with my personal computer.
The problem is when i start JDBC connector, it stops after sometime. Before, I tested with test connector, the system worked okey.
i said above what i changed, is there any other thing I need to do in order to run the jdbc connector up and running.
While running ( the start_JDBC), do we need to give any parameter ?
thanks |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 9:59 am Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
The error is as follows:
[Time: 2005/12/12 09:52:54.047] [System: ConnectorController] [SS: INCONN] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14315] [Mesg: Checking to see if recovery is needed...]
[Time: 2005/12/12 09:52:54.047] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 28] [Mesg: Connector "JDBCoutConn" is being initialized.]
[Time: 2005/12/12 09:52:54.109] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14233] [Mesg: Initializing]
[Time: 2005/12/12 09:52:54.109] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Mesg: Attempt to retrieve connector property jms.TransportOptimized failed. Reason: Not found.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14235] [Mesg: Waiting to receive subscription and other metadata information.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14327] [Mesg: Flow controlled resource JDBCoutConn_iqbuf for connector controller created successfully.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14315] [Mesg: Checking to see if recovery is needed...]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 35] [Mesg: The map service is being initialized.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 16016] [Mesg: Binding maps to the business objects supported by the connector JDBCoutConn.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 16016] [Mesg: Binding maps to the business objects supported by the connector INCONN.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 36] [Mesg: The Map Service has been initialized.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 30] [Mesg: Collaborations are being initialized.] |
|
| Back to top |
|
|
| vennela |
| Posted: Mon Dec 12, 2005 11:00 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| amateur10 wrote: |
While running ( the start_JDBC), do we need to give any parameter ?
thanks |
start_JDBC JDBC ICSServerName -cConfigurationfileOfTheConnecotr |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 12:34 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
Hi Vennela
I tried with these options, still the jdbcconnector does not urn.
any other reasons
thanks |
|
| Back to top |
|
|
| vennela |
| Posted: Mon Dec 12, 2005 1:09 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Does it hand or does it give any error? |
|
| Back to top |
|
|
| recallsunny |
| Posted: Mon Dec 12, 2005 1:15 pm Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
Your Log does not indicate the occurance of an error. You need to precisely tell us what you've categorized as an error....Does your connector not pick new event? Or does it not process a request Or If it shuts down after a period of time..?
Without the right information it is very ineffective to debug an error.. |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 1:20 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
when i run start_jdbc with option u gave, even it stops after sometime
i dun know why
what else do i need to configure
tables are there
changed drivepath
run with parameters
what else now |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 1:23 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
My problem is I can not connect to database '
the jdbc connector outbound, |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Dec 12, 2005 1:31 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
Amateur Wrote:
The error is as follows:
| Quote: |
[Time: 2005/12/12 09:52:54.047] [System: ConnectorController] [SS: INCONN] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14315] [Mesg: Checking to see if recovery is needed...]
[Time: 2005/12/12 09:52:54.047] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 28] [Mesg: Connector "JDBCoutConn" is being initialized.]
[Time: 2005/12/12 09:52:54.109] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14233] [Mesg: Initializing]
[Time: 2005/12/12 09:52:54.109] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Mesg: Attempt to retrieve connector property jms.TransportOptimized failed. Reason: Not found.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14235] [Mesg: Waiting to receive subscription and other metadata information.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14327] [Mesg: Flow controlled resource JDBCoutConn_iqbuf for connector controller created successfully.]
[Time: 2005/12/12 09:52:54.172] [System: ConnectorController] [SS: JDBCoutConn] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 14315] [Mesg: Checking to see if recovery is needed...]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 35] [Mesg: The map service is being initialized.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 16016] [Mesg: Binding maps to the business objects supported by the connector JDBCoutConn.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 16016] [Mesg: Binding maps to the business objects supported by the connector INCONN.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 36] [Mesg: The Map Service has been initialized.]
[Time: 2005/12/12 09:52:54.172] [System: Server] [Thread: P=946031:O=0:CT (#683820864)] [Type: Info] [MsgID: 30] [Mesg: Collaborations are being initialized.] |
The error you posted is from Interchangesystem.log.
Ofcourse there is no error in your log as pointed out by recallsunny
We are asking you to post the error you see when you start JDBC adapter.
1.)Were you able to start the ICS.If you successfully started the ICS why did you post the InterchangeSystem.log?
2.)You named the connector as JDBCoutConn.So did you follow all the necessary steps when you create an instance of the connector of your own choice?
Last edited by djeripo on Mon Dec 12, 2005 1:39 pm; edited 1 time in total |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 1:35 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
Yes, My ics is working fine now.
sorry for the wrong log. As I said, I am leanring, so sometime get confused.
I created connector, deployed, and as I said, tested with VT Connector
when i start jdbc |
|
| Back to top |
|
|
| amateur10 |
| Posted: Mon Dec 12, 2005 1:38 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
Yes, My ics is working fine now.
sorry for the wrong log. As I said, I am leanring, so sometime get confused.
I created connector, deployed, and as I said, tested with VT Connector
when i start jdbc, it stops after sometime that is my problem, so asking what configuration do I need to do except I mentioned, |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Dec 12, 2005 1:42 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
| Before it stops what would it write ? I suppose you did not configure any log/trace file for your connector.Copy the contents from the JDBC command window(Edit--->selectall--->copy) and paste it here. |
|
| Back to top |
|
|
|
|
