[STR-2412] Datasource loses connection

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 1.1.0
• Component/s: Website
• Environment: Operating System: Linux; Platform: PC
• Bugzilla Id: 34269
• Assignee: Paul Benedict
• Reporter: Agustin Brau
• Created: 02/Apr/05 05:18
• Updated: 23/Jun/14 17:11
• Resolved: 23/Jun/14 17:11

Description

(mysql-connector-java-3.0.16-ga-bin.jar)

I have an action which executes some heavy query (creating temporary tables un
mysql). After 8 queries the connection is unexpectly closed and in the next
query returns the query was explicity closed. The pool doesn't start a new
connection and doesn't verify that the returned connection is closed.
You can simulate the error closing the connection from mysql and then when you
use the returned connection you have a broken pipe error instead of a new
connection.
Thanks

The action:

javax.sql.DataSource ds = getDataSource(request);
java.sql.Connection conexion = ds.getConnection();
try{
java.sql.Statement stmt = conexion.createStatement();
try

{ stmt.executeUpdate("drop table "+ tablaTemporal); }

catch(SQLException e)

{ System.out.println("[PrepareMostrarQryAction] Borrando tabla temporal codigo:"+e.getErrorCode()+"-> "+ e.toString()); }

.
.
.
try

{ System.out.println("Cerrando la conexion"); conexion.isClosed(); //antes decia conexion.Close(); }

catch(SQLException e)

{ System.out.println("[PrepareMostrarQryAction] Error cerrando conexion a SQL: " + e.toString()); }

}