Re: JDBC causing the connection to close after executing a COPY command

Altaf,
On 13-Dec-07, at 10:24 AM, Altaf Malik wrote:

> 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 ?

Dave
> Thanks,
> Altaf Malik
> EnterpriseDB
> http://www.enterprisedb.com/
>
> Looking for last minute shopping deals? Find them fast with Yahoo!
> Search.