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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
