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
copy link · copy postgr.es
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