Issue with Weblogic Db connection

[Naveen Chowdary]

Hi,

for our application we are using weblogic 8.1 as application server and are connecting to IBM DB2. However everything works fine in DB operations until suddenly we got this exception

java.sql.SQLException:[BEA][DB2 JDBC Driver]:End of Stream was detected on a read

later on for every insert/read on DB2 we are getting this exception

java.sql.SQLException:[BEA][DB2 JDBC Driver]:Write Failed: Broken Pipe

can you please help me in this issue.

Thank You,
Naveen Chowdary

[sudipto shekhar]

The Broken pipe indicates a connection loss between the Weblogic server and the Database server.

This could have been caused due to

1. Closing the connection object before the Prepared Statement objects in the code.

2. Database server was restarted.

3. The network connectivity was lost.

To resolve such instances in the you use the following features provided by Weblogic connection pools

1. TestConnectionsOnReserve - Test the connection when the connection is reserved back to the pool.

2. TestFrequency - Tests connection pool at regular intervals and close the stale connections and recreate new connections.

3. TestConnectionsOnRelease - Test the connection when a connection is released for use to a client.


Hope this helps!!