| From: | Alex <alex(at)meerkatsoft(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | SQL Exception Relation xxx does not exist |
| Date: | 2004-01-20 05:00:43 |
| Message-ID: | 400CB5FB.4030503@meerkatsoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
Hi,
I am getting the following error when running an update from a JAVA
program using a Tomcat Connection Pool.
SQLException: Error Relation 215106760 does not exist
In the server log I see additional info Error occured while executing
PL/pgSQL function funcName
line 105 at select into variables
I dont think that the Function has a problem as I am able to run it with
the same parameters from within psql returning me a result.
The strange thing is that it works for a couple of day. Once I restart
tomcat the problem goes away... for a few days. Although I use many
objects from the same Servlet, only this particular PL/pgSQL function
has a problem.
Question:
1. Is that problem known in PG7.3.4?
2. Could this be a problem with the connection pool of tomcat or the
postgres JDBC driver ?
3. how do i find out the name of the actual object referred by 215106760
in the error message?
Thanks for any help
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-01-20 05:16:32 | Re: SQL Exception Relation xxx does not exist |
| Previous Message | Bruce Momjian | 2004-01-20 03:50:01 | Re: Organizing the OSCON presence |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-01-20 05:16:32 | Re: SQL Exception Relation xxx does not exist |
| Previous Message | Aurangzeb M. Agha | 2004-01-20 04:48:49 | Re: no space left on device |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-01-20 05:16:32 | Re: SQL Exception Relation xxx does not exist |
| Previous Message | Matthew T. O'Connor | 2004-01-20 03:38:22 | Re: VACUUM delay (was Re: What's planned for 7.5?) |