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

web-app not working after upgrade 7.4 to 8.1

From: Wolfgang Rinnert <wrinnert(at)web(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: web-app not working after upgrade 7.4 to 8.1
Date: 2006-12-02 12:35:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hello experts,

I have recently upgraded my database from 7.4 to 8.1 and migrated all data.

In order to be able to use my web-app, I replaced the old jdbc.jar with 
postgresql-8.1-407.jdbc3.jar in WEB-INF/lib/.

Restarted Tomcat (4.1.31) - and later even redeployed the webapp.

I keep getting no database connection - as if the postmaster were not 

Apparently I have ignored something basic - but no idea what to look at.
This is actually my first fully working webapp using Struts and Tomcat 
on Linux - so maybe my problem is really a Tomcat issue.

I have attached part of my coding of the Struts-Action, the exception 
occurs with the message "Presumably database is down."

Any hint is apreciated.


public ActionForward execute( ActionMapping mapping,
                                   ActionForm form,
                                   HttpServletRequest request,
                                   HttpServletResponse response )
                 throws Exception
    HttpSession sitzg = request.getSession();
    ConnectionPool pool = (ConnectionPool) sitzg.getAttribute( JDBC );
    if (pool == null)
          pool = new ConnectionPool( driver, dburl, username, password, 
initConn );
          sitzg.setAttribute( JDBC, pool );
       catch ( SQLException e )
          System.out.println( e.getMessage() );
          System.out.println( "Cannot connect to database " + database );
       catch ( ClassNotFoundException e )
          System.out.println( e.getMessage() );
          System.out.println( "Falscher Treibername in den Properties: " 
+ driver );
       if (pool == null)
          throw new SQLException( "ERROR: NULL pool created!  Presumably 
database is down." );



Wolfgang Rinnert


pgsql-jdbc by date

Next:From: João Paulo RibeiroDate: 2006-12-04 12:41:44
Subject: Re: web-app not working after upgrade 7.4 to 8.1
Previous:From: Kris JurkaDate: 2006-12-01 23:20:00
Subject: Re: Locking on PGStream.ReceiveChar(

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