Reboot database system

[Sez Sez <se...@yahoo.es>]

Hi people,
I connect with torque to as400 database (db2). This
as400 reboot and it do batch works every night. When i
trying connect with torque, i get this error

java.sql.SQLException: Communication link
failure.(Connection reset)
	at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:460)
	at
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2534)
	at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1292)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:182)
	at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1805)
	at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1628)
	at
org.apache.commons.dbcp.cpdsadapter.PooledConnectionImpl.prepareStatement(PooledConnectionImpl.java:271)
	at
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.prepareStatement(ConnectionImpl.java:372)
	

and

org.apache.torque.TorqueException:
java.sql.SQLException: PooledConnection was reused,
withoutits previous Connection being closed.
	at
org.apache.torque.Torque.getConnection(Torque.java:944)

I can do in my source a catch to work with exception
and re-connect to db... What can i do this??? Any more
ideas?



		
______________________________________________________________________
Correo Yahoo! - 6MB, más protección contra el spam ¡Gratis!
http://correo.yahoo.es

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org