| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Issue while configuring JDBC Adapter |
« View previous topic :: View next topic » |
| Author |
Message
|
| burman.abhishek |
 Posted: Thu Feb 15, 2007 9:30 am Post subject: Issue while configuring JDBC Adapter |
 |
|
Apprentice
Joined: 23 Aug 2006
Posts: 37
|
Hi,
I am configuring a JDBC adapter.I have created the xworlds_events and xworlds_archive_events tables as per the script given in C:\IBM\WebSphereAdapters\connectors\JDBC\dependencies but when i start the adapter i get an error "Event/archive tables not defined". How do i resolve this?
_________________
With warm Regards,
Burman |
|
| Back to top |
|
 |
| sarat |
| Posted: Thu Feb 15, 2007 9:51 pm Post subject: |
|
|
Centurion
Joined: 29 Jun 2005
Posts: 136
Location: India
|
hi,
In which database u've created the event and archive tables?
paste the complete error here.
_________________
With Regards,
Sarat. |
|
| Back to top |
|
|
| burman.abhishek |
| Posted: Fri Feb 16, 2007 4:26 am Post subject: |
|
|
Apprentice
Joined: 23 Aug 2006
Posts: 37
|
Hi,
I have created a local Database Customer in DB2 V8 installed on my PC. This database has the xworlds_events and xworlds_archive_events defined. The base table Table1 is also created in the same database using which i have created the BO's for the adapter.
The error message is as shown below:
[Thread: wbia_main (#109876098)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 900 19] [Mesg: Exiting fetchConnection] ]
[Time: 2007/02/16 17:50:06.354] [System: ConnectorAgent] [SS: JDBCMDMConnector]
[Thread: wbia_main (#109876098)] [Type: Error] [MsgID: 33022] [Mesg: Event/Archive table xworlds_events does not exist in the database.]
[Time: 2007/02/16 17:50:06.354] [System: ConnectorAgent] [SS: JDBCMDMConnector]
[Thread: wbia_main (#109876098)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering releaseConnection] ]
[Time: 2007/02/16 17:50:06.354] [System: ConnectorAgent] [SS: JDBCMDMConnector]
[Thread: wbia_main (#109876098)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting releaseConnection] ]
[Time: 2007/02/16 17:50:06.354] [System: ConnectorAgent] [SS: JDBCMDMConnector]
[Thread: wbia_main (#109876098)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2007/02/16 17:50:06.364] [System: ConnectorAgent] [SS: JDBCMDMConnector]
[Thread: wbia_main (#109876098)] [Type: Fatal Error] [MsgID: 17058] [Mesg: Application call to method init() returned failure. The application could not be contacted.]
Warm regards,
Abhishek
_________________
With warm Regards,
Burman |
|
| Back to top |
|
|
| sourdas2 |
| Posted: Fri Feb 16, 2007 5:56 am Post subject: |
|
|
Voyager
Joined: 21 Apr 2006
Posts: 90
Location: Kolkata,India
|
Have created the tables under default schema, if not, have you mentioned the schema name in connector configuration file?
_________________
Thanks and Warm Regards
Sourav |
|
| Back to top |
|
|
| vk |
| Posted: Mon Feb 19, 2007 2:28 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
What have you configured for DatabaseURL and JDBCConnectorClass?
Regards,
VK. |
|
| 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
|
|
|
|
