| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC Adapter for SQL Server : Broken Pipe issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| vk |
 Posted: Thu Nov 17, 2005 12:42 pm Post subject: JDBC Adapter for SQL Server : Broken Pipe issue |
 |
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
I am using a JDBC adapter for processing request messages from a queue and inserting records into a table in Microsoft SQL Server 2000 database.
Everything works correctly, until the connector remains idle for a long time, say 8-10 hours. After this gap, whenever the connector receives a request, the message is sent to the fault queue with the following error -
[MsgID: 37004] [Mesg: Execution of Prepared Update Statement Failed : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Broken pipe] A failure has happened in the callback function.
If I restart the connector, it starts sending the request messages to the database. Has anyone faced this issue? Any help is appreciated.
Thanks in advance,
VK. |
|
| Back to top |
|
 |
| vk |
| Posted: Mon Nov 21, 2005 9:53 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
The issue occured when the database went down, but the connectons established by the adapter to the database were still open. I had to restart the adapter for the connection status to resolve.
I now set the CloseDBConnection property in the configuration file to True. This will close the database connection after inserting a record corresponding to each Request message.
Although the manual says that setting this property to True will affect performance, I did not see any performance hit.
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
|
|
|
|
