Hi, JDBC is causing the connection to close on executing a simple COPY query which the driver does not support. The code shows that driver throws an exception however explicitly the connection is not closed. Consider the following case. <code> Class.forName("org.postgresql.Driver"); Connection con = DriverManager.getConnection("jdbc:postgresql://localhost/postgres","altaf","");
Statement stmt = con.createStatement(); stmt.execute("create table abc(a int4)"); try{ stmt.execute("COPY abc TO STDOUT WITH DELIMITER '|'"); }catch(Exception e) { e.printStackTrace(); } stmt.execute("Select * from abc");
</code>
Can anybody tell what's happening?
At what point can you determine the connection is closed ? Can you do con.createStatement after the exception ?