Skip site navigation (1) Skip section navigation (2)

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

From: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC causing the connection to close after executing a COPY command
Date: 2007-12-13 15:54:52
Message-ID: 689590.40570.qm@web39115.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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.

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-12-13 16:26:03
Subject: Re: JDBC causing the connection to close after executing a COPY command
Previous:From: Dave CramerDate: 2007-12-13 15:37:10
Subject: Re: JDBC causing the connection to close after executing a COPY command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group