| Author |
Message
|
| mqseries123 |
 Posted: Wed Oct 11, 2006 7:52 pm Post subject: Issue relate to the JDBC Connector[solved] |
 |
|
Apprentice
Joined: 04 Jan 2006
Posts: 26
|
Hi,
The configuration of the system is :
OS : Windows 2000
WICS 4.3.1
MQ 5.3
DB2 8.2
It is required that the JDBC Adapter inserts a record to the table. The records are inserted fine if initially the application table is empty.
But if there are some records already in the same application table, it keeps inserting the same record in the table, hence there is a SQL exception (unique key constraint).
Last edited by mqseries123 on Tue Oct 17, 2006 8:05 pm; edited 1 time in total |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Oct 12, 2006 11:16 am Post subject: Re: Issue relate to the JDBC Connector |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| mqseries123 wrote: |
But if there are some records already in the same application table, it keeps inserting the same record in the table, hence there is a SQL exception (unique key constraint). |
Don't you think it is working as designed?
What seems to be the problem |
|
| Back to top |
|
|
| mqseries123 |
| Posted: Thu Oct 12, 2006 8:23 pm Post subject: |
|
|
Apprentice
Joined: 04 Jan 2006
Posts: 26
|
ICS picks the message from the queue, and the JDBC adapter inserts the record to the application table TABLE1. So it not an event based polling.
The messages come from workflow to a queue from which ICS has to pick it up.
There is an application table TABLE1 in which there are already records inserted. Now, when the JDBC connector agent is started, it goes on inserting the same record in the table hence giving an exception(unique key constraint). We are not able to figure out this behaviour.
We are also facing one more problem. In the interchange server console, the error
"MQJE001: Completion Code 2, Reason 2033" is shown.
We tried to debug, but now ICS is not picking the message from the queue. |
|
| Back to top |
|
|
| vk |
| Posted: Sat Oct 14, 2006 6:24 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
| Quote: |
| ICS picks the message from the queue, and the JDBC adapter inserts the record to the application table TABLE1. So it not an event based polling. |
I an using JDBC adapter with WMQI\WMB. Here the flow delivers a message to the queue. The adapter picks up the message from the queue and inserts into the database.
Is this different in ICS? If ICS is picking up the message from queue, how is the message passed on to the adapter?
Regards,
VK. |
|
| Back to top |
|
|
| Ratan |
| Posted: Mon Oct 16, 2006 9:02 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Turn the tracing to 5 on the JDBC Adapter and check the data in the BO going out. Looks like you are sending out the same data.
_________________
-Ratan |
|
| Back to top |
|
|
| mqseries123 |
| Posted: Tue Oct 17, 2006 8:02 pm Post subject: |
|
|
Apprentice
Joined: 04 Jan 2006
Posts: 26
|
Thanks a lot.
We resolved the issue. the problem was with the installation of Fixpack 1. Installed the fixpack once again. Everything seems to work fine. |
|
| Back to top |
|
|
|
|
