On Thu, 29 Jul 2010, Jason Long wrote:
> I am having a problem deploying my application on Postgres 9.0. This
> could have something to do with "Failed restore connection's original
> auto commit setting." The application does connect to the database just
> fine because if I disable the QuartzDispatcher the application works.
> Even with it enabled, Hibernate is still able to validate my tables
> before the QuartzDispatcher starts up. I have no problems with any
> other version of Postgres. The app is currently running perfectly on
> 8.4.4.
>
> java.lang.ArrayIndexOutOfBoundsException: 2
> at org.postgresql.util.PGbytea.toBytes(PGbytea.java:76)
> atorg.postgresql.jdbc2.AbstractJdbc2ResultSet.getBytes(AbstractJdbc2ResultSet
> .java:2271)
You need to either use a 9.0 JDBC driver or change your server's setting
of bytea_output to escape because the 8.4 driver does not understand hex
format.
You can get the 9.0 development driver here, it just hasn't been linked
into the website yet.
http://jdbc.postgresql.org/download/postgresql-9.0dev-800.jdbc4.jar
Kris Jurka