Re: Connection.setBytes()

On Tue, 18 Jul 2000, Matt Fair wrote:
>
> Here is the code I am using:
> 
>     public PsqlConsole(String url) {
>         try{
>             ... 
>             con = DriverManager.getConnection("jdbc:postgr...");
>             con.setAutoCommit(false);
>         }
>         catch(ClassNotFoundException e) {
>             ...
>         }
>         catch(SQLException e) {
>             ...
>         }
>         finally {
>             //always close the database
>             try {
>                 if(con != null) con.close();

This closes the connection! Once this method returns your connection is
closed. Your subsequent SQL calls in the prompt() method use a closed
connection.

Joachim