X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4055E9DC822 for ; Tue, 20 Dec 2005 05:25:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39616-06 for ; Tue, 20 Dec 2005 05:25:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tgds.net (tgds.net [212.100.249.157]) by postgresql.org (Postfix) with ESMTP id B45EC9DC82B for ; Tue, 20 Dec 2005 05:25:07 -0400 (AST) Received: from hush.localdomain (localhost [127.0.0.1]) by mail.tgds.net (Postfix) with ESMTP id 1A92F1435F7 for ; Tue, 20 Dec 2005 09:24:12 +0000 (GMT) Subject: maybe off topic JDBC question From: tony To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-15 Date: Tue, 20 Dec 2005 10:25:07 +0100 Message-Id: <1135070707.2847.267.camel@hush.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.027 required=5 tests=[AWL=0.027] X-Spam-Score: 0.027 X-Spam-Level: X-Archive-Number: 200512/212 X-Sequence-Number: 19932 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