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

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.