Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC causing the connection to close after executing a COPY command - Mailing list pgsql-jdbc

From Altaf Malik
Subject Re: JDBC causing the connection to close after executing a COPY command
Date
Msg-id 689590.40570.qm@web39115.mail.mud.yahoo.com
Whole thread Raw
In response to Re: JDBC causing the connection to close after executing a COPY command  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: JDBC causing the connection to close after executing a COPY command  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view
Hi,
At what point can you determine the connection is closed ? Can you do con.createStatement after the exception ?
If you see, i have placed the the
stmt.execute("COPY abc TO STDOUT WITH DELIMITER '|'");
in a try-catch block, and after the try-catch block, i have executed again
stmt.execute("Select * from abc")
which throws an IO Exception. Also if i enable logging in JDBC, and only execute the COPY statement, log shows that FrontEnd sent a Terminate message.


Thanks,
Altaf Malik
EnterpriseDB
http://www.enterprisedb.com/

Never miss a thing. Make Yahoo your homepage.

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC causing the connection to close after executing a COPY command
Next
From: Kris Jurka
Date:
Subject: Re: JDBC causing the connection to close after executing a COPY command