Your name :Kexin Wang
Your email address :wangkx@wbu.edu
Your name :Geoffrey Ritchey
Your email address :ritcheyg@wbu.edu
System Configuration
---------------------
Architecture (example: Intel Pentium) :Intel Pentium
Operating System (example: Linux 2.0.26 ELF) :Linux Mandrake 8.0
PostgreSQL version (example: PostgreSQL-7.1.3):PostgreSQL-7.1.3
Compiler used (example: gcc 2.95.2) :gcc 2.96
Please enter a FULL description of your problem:
------------------------------------------------
When running the following query I get the following stack trace. The
problem seems to only happen after running for hours and sometimes a couple
days. The query is usually executed every 2 minutes or so. The actual
value of the 'response type' seems to be relatively random.
It is running from a tomcat jsp/servlet using the jdbc driver.
Execute: select id, reverse_name, ssn, address1, address2, address3,
street1, street2, city, state
, zip1, zip2, phone, work_phone, fax, email from nap where id = -1;
Unknown Response Type ^H
Unknown Response Type ^H
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:117)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
The problem seems to happen randomly. We can't reproduce it at will. We
are using connection pooling. Perhaps a problem with more than one thread
using the same connection???
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------