| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC adapter Request processing problem. |
« View previous topic :: View next topic » |
| Author |
Message
|
| venky |
 Posted: Wed Oct 10, 2007 10:24 am Post subject: JDBC adapter Request processing problem. |
 |
|
Master
Joined: 08 Jul 2003
Posts: 205
|
We are sending 1000's of messages to the JDBC adapter's request queue form where the JDBC adapter pulls the messages and does insert/update operation on target database table.
In the above scenario we have been noticing a strange problem, when there is 1 bad message (for example, unique constraint error, etc), the adapter not only fails that message, but also fails another 5 - 10 good messages along with the bad one.
JDBC adapter - V2.6.7
Has anyone been through such a problem?
Any suggestions?
Thanks,
V |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Sat Oct 13, 2007 7:09 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
did you specify any commit transaction with the database.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mqseries0209 |
| Posted: Mon Oct 15, 2007 7:35 am Post subject: |
|
|
Voyager
Joined: 30 Mar 2006
Posts: 90
|
| Quote: |
| In the above scenario we have been noticing a strange problem, when there is 1 bad message (for example, unique constraint error, etc), the adapter not only fails that message, but also fails another 5 - 10 good messages along with the bad one. |
Now how did you come to a conclusion that the adapter is failing other 5-10 good messages ?.
Did you the adapter logs/trace files for the good messages and see why they are failing?.
More Info on this problem will be helpful in solving this issue.
-chinku. |
|
| 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
|
|
|
|
