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

Re: web-app not working after upgrade 7.4 to 8.1

From: João Paulo Ribeiro <jp(at)mobicomp(dot)com>
To: Wolfgang Rinnert <wrinnert(at)web(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: web-app not working after upgrade 7.4 to 8.1
Date: 2006-12-04 12:41:44
Message-ID: 45741788.6000601@mobicomp.com (view raw or flat)
Thread:
Lists: 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(at)web(dot)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(at)mobicomp(dot)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 the individual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any use whatsoever 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 not accept liability for any fact which may interfere with the integrity of its content.

In response to

Responses

pgsql-jdbc by date

Next:From: Marc HerbertDate: 2006-12-04 16:11:17
Subject: Re: Backup with Java
Previous:From: Wolfgang RinnertDate: 2006-12-02 12:35:08
Subject: web-app not working after upgrade 7.4 to 8.1

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