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

JDBC causing the connection to close after executing a COPY command

From: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC causing the connection to close after executing a COPY command
Date: 2007-12-13 15:24:57
Message-ID: 669991.48395.qm@web39114.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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?

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

       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2007-12-13 15:37:10
Subject: Re: JDBC causing the connection to close after executing a COPY command
Previous:From: Ken JohansonDate: 2007-12-13 07:17:37
Subject: Re: RETURNING clause: how to specifiy column indexes?

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