pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: tony <tony@tgds.net>
To: pgsql-admin@postgresql.org
Subject: maybe off topic JDBC question
Date: Tue, 20 Dec 2005 10:25:07 +0100
Message-ID: <1135070707.2847.267.camel@hush.localdomain> (raw)

Ok this is probably a JDBC thing but as many admins seem to be running
webapps and it is a version migration problem I shall ask here:

I have migrated the backend from 7.2.1 to 8.1.1
Most of the JSPs work just fine several others don't

§§§§§§§§§§§§§§§§§

org.postgresql.util.PSQLException: ERREUR: Entrée manquante de la  
clause FROM pour la table «individu»

(translation: missing entry in the FROM clause of table...)
         
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu 
torImpl.java:1512)
         
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp 
l.java:1297)
         
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 
188)
         
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme 
nt.java:430)
         
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb 
c2Statement.java:346)
         
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St 
atement.java:250)
         
org.apache.jsp.contact.fiche_005findividu_005fintra_jsp._jspService(org. 
apache.jsp.contact.fiche_005findividu_005fintra_jsp:71)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
         
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja 
va:322)
         
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

§§§§§§§§§§§§§§§§§§

OK so far so good, now the crunch - I have a newer version of one of the
broken pages which uses the exact same JDBC connection code and it
works. The only modifications in the new page are use of style sheets
for layout instead of tables...

I have run the query from the JSP in pgaccess and it works just fine.

Tomcat was also updated from 4 to 5.5 and I have the latest
postgresql.jar for JDK1.5

Any thoughts?

Cheers

Tony
-- 
Tony Grant
www.tgds.net - vente d'ordinateurs mini-itx en ligne
www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for VIA Epia-M




view thread (3+ messages)  latest in thread

Message-ID: <1135070707.2847.267.camel@hush.localdomain>
Permalink:  ../1135070707.2847.267.camel@hush.localdomain/
Also on:    postgresql.org/message-id/1135070707.2847.267.camel@hush.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tony@tgds.net
  Subject: Re: maybe off topic JDBC question
  In-Reply-To: <1135070707.2847.267.camel@hush.localdomain>
  References: <1135070707.2847.267.camel@hush.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox