From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Lewis Foti <lewis(dot)foti(at)mentation(dot)com> |
Cc: | <pgsql-bugs(at)postgresql(dot)org>, <lowen(at)pari(dot)edu> |
Subject: | Re: Jdbc connection pooling and PG 7.4 consistently fails |
Date: | 2003-12-19 18:27:17 |
Message-ID: | Pine.LNX.4.33.0312191313190.4565-100000@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-jdbc |
On Thu, 18 Dec 2003, Lewis Foti wrote:
> Hi
>
> Having downloaded and installed the rpms for 7.4 I upgraded the database and
> began testing. As the system under development is based on servlets we are
> using the JDBC3 Jdbc3PoolingDataSource to provide the connections. All
> attempts to read from the database via jdbc pooled connections now fail.
> Looking in syslog the following error is being reported;
>
> Dec 18 19:06:04 neptune postgres[1986]: [4-1] LOG: statement: set
> autocommit = off;
> Dec 18 19:06:04 neptune postgres[1986]: [5-1] ERROR: SET AUTOCOMMIT TO OFF
> is no longer supported
>
> This then causes a Java exception and the query fails. The jdbc jar file
> being used is /usr/share/pgsql/pg73jdbc3.jar as provided in the
> postgresql-jdbc-7.4-0.5PGDG rpm. Is this the correct one to use or should we
> replace it with the /usr/share/pgsql/devpgjdbc3.jar?
The RPMs do not have the correct jar file. Try one of those available
from http://jdbc.postgresql.org/download.html
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-19 18:31:16 | Re: Bugs in bigint indexes |
Previous Message | Nishad Prakash | 2003-12-19 18:17:32 | Re: Bugs in bigint indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2003-12-19 20:38:19 | Re: Jdbc connection pooling and PG 7.4 consistently fails |
Previous Message | Lewis Foti | 2003-12-18 19:17:12 | Jdbc connection pooling and PG 7.4 consistently fails |