Commons DBCP with socketTimeout JTDS driver

[Fernando Franzini]

After I started using socketTimeout=40, the Commons DBCP can not reopen the connection when time out happens. Every moment that time Out happens, I lose a connection ...and to be no connection open. What could I do to tell the Commons DBCP to reopen the socket connection when a timeout happens?

	<Resource 
		auth="Container" name="jdbc/intranet"
		initialSize="5" maxActive="7" maxIdle="3" maxWait="20000" 
		type="javax.sql.DataSource" 
		driverClassName="net.sourceforge.jtds.jdbc.Driver"
		url="jdbc:jtds:sqlserver://ldasrv08;databaseName=sau_dev1;socketTimeout=40;" 
		username="xxx" password="yyyyyyyy$"

  	/>  

Best regards