Thank you, I changed it and it doesn't throw a null pointer any more.
Matt Fair
Joachim Achtzehnter wrote:
> 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
