Re: web-app not working after upgrade 7.4 to 8.1 - Mailing list pgsql-jdbc
From | João Paulo Ribeiro |
---|---|
Subject | Re: web-app not working after upgrade 7.4 to 8.1 |
Date | |
Msg-id | 45741788.6000601@mobicomp.com Whole thread Raw |
In response to | web-app not working after upgrade 7.4 to 8.1 (Wolfgang Rinnert <wrinnert@web.de>) |
Responses |
Re: web-app not working after upgrade 7.4 to 8.1
(Wolfgang Rinnert <wrinnert@web.de>)
|
List | pgsql-jdbc |
Its possible that your upgrade missed up the postgres configuration. Verifiy if the postgres is waiting for connections at port 5342. As root try: netstat -ntlp | grep 5432 You should see somenting like: tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 3668/postmaster tcp 0 0 :::5432 :::* LISTEN 3668/postmaster If not, postgres is not waiting for connections and you'll get the "no database connection" error. JP Wolfgang Rinnert wrote: > 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 > started. > > 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) > { > try > { > 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 ); > e.printStackTrace(); > } > catch ( ClassNotFoundException e ) > { > System.out.println( e.getMessage() ); > System.out.println( "Falscher Treibername in den Properties: > " + driver ); > e.printStackTrace(); > } > if (pool == null) > { > throw new SQLException( "ERROR: NULL pool created! > Presumably database is down." ); > } > > ----------------------------------- > > Regards, > > Wolfgang Rinnert > wrinnert@web.de > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- João Paulo Ribeiro | Senior Software Engineer jp@mobicomp.com PHONE: + 351 253 305 250 FAX : + 351 253 305 250 www.mobicomp.com ________________________________________________________________ About Solutions | Wireless World CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for theindividual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any usewhatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender. DISCLAIMER: The sender of this message can not ensure the security of its electronic transmission and consequently does notaccept liability for any fact which may interfere with the integrity of its content.
pgsql-jdbc by date: