ConnectionPool connections dropping

[ashuy]

I am using weblogic 6.0 which connects to a remote DB2 on AS400 using
the toolbox driver for JDBC thru' a connection pool
The connectivity between the weblogic box and the AS400 machine is
broken occasionally because of network failure or some backup job
going on AS400 .
The problem that I face is that even when the network connectivity is
restored b/w the machines , the application does not work as the
connection pool fails to connects giving the following message :

trying driver[className=weblogic.jdbc.pool.Driver,weblogic.jdbc.pool.Driver@61fb6c]
getConnection returning
driver[className=weblogic.jdbc.pool.Driver,weblogic.jdbc.pool.Driver@61fb6c]
java.net.SocketException: Connection reset by peer: JVM_recv in socket
input stream read
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at com.ibm.as400.access.DataStream.readFromStream(DataStream.java:48)
at com.ibm.as400.access.ClientAccessDataStream.construct(ClientAccessDataStream.java:39)
at com.ibm.as400.access.AS400ThreadedServer.run(AS400ThreadedServer.java:216)
at java.lang.Thread.run(Thread.java:484)
SQLException: SQLState(HY000) vendor code(-99999)
java.sql.SQLException: Internal driver error.(Connection reset by
peer: JVM_recv in socket input stream read)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:336)
at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:1714)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:537)
at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:643)
at weblogic.jdbc.pool.PreparedStatement.execute(PreparedStatement.java:45)
at com.mccrackenfs.oasis.fw.db.OasisDatabase.execChgCurLib(OasisDatabase.java:79)
at com.mccrackenfs.oasis.fw.security.User.init(User.java:186)
at com.mccrackenfs.oasis.fw.security.User.validate(User.java:140)
at com.mccrackenfs.oasis.cm.action.loginAction.performAction(loginAction.java:33)
at com.mccrackenfs.oasis.fw.web.BaseAction.perform(BaseAction.java:49)
at com.mccrackenfs.oasis.fw.web.BaseServlet.process(BaseServlet.java:264)
at com.mccrackenfs.oasis.fw.web.BaseServlet.doPost(BaseServlet.java:189)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)

Can anybody help me out on this ?

Ashu Yadav

[Sree Bodapati]

hi ashu

set the testConnsOnReserve=true property in your connection pool and provide
a testTableName. That should fix the issue.

hth
/
sree

"ashuy" <ashu...@yahoo.com> wrote in message
news:a096c645.01081...@posting.google.com...