X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id C7AE211F633C for ; Wed, 19 Apr 2006 05:05:05 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.638 X-Spam-Level: X-Spam-Status: No, score=-0.638 required=5 tests=[BAYES_00=-2.599, DATE_IN_FUTURE_03_06=1.961] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id gqGsPyeCvrZY for ; Wed, 19 Apr 2006 05:05:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp103.biz.mail.re2.yahoo.com (smtp103.biz.mail.re2.yahoo.com [68.142.229.217]) by postgresql.org (Postfix) with SMTP id 5265C11F6B77 for ; Wed, 19 Apr 2006 05:05:01 -0300 (ADT) Received: (qmail 25493 invoked from network); 19 Apr 2006 07:58:21 -0000 Received: from unknown (HELO ?192.168.10.240?) (danish.siddiqui@hovservices.com@220.225.41.152 with plain) by smtp103.biz.mail.re2.yahoo.com with SMTP; 19 Apr 2006 07:58:21 -0000 Message-ID: <44463A7B.8040000@hovservices.com> Date: Wed, 19 Apr 2006 13:26:19 +0000 From: "danish.siddiqui@hovservices.com" User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc3 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: tomcat postgresql database conectivity error Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/230 X-Sequence-Number: 21399 Hi All, I get this error when I try to connect a web application running on tomcat, to a postgreesql database..... Below is the data from tomcat logs-- --- com.rapidigm.bacs.db.BacsDBException: (executing StatementCallback): encountered SQLException [ERROR: No parser with id 17555]; nested exception is java.sql.SQL Exception: ERROR: No parser with id 17555 ---- And the next one is from postgresql logs.... $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start postmaster starting [postgres@myMachinename ~]$ LOG: database system was shut down at 2006-04-19 13:01:36UTC LOG: checkpoint record is at 0/110ED9C LOG: redo record is at 0/110ED9C; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 12957; next OID: 18422 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" [postgres@myMachinename ~]$ ERROR: No parser with id 17555 ------------ Please advise....ive tried searchign a lot but havent found any clue Thanks-- -- Danish Siddiqui