Skip site navigation (1) Skip section navigation (2)

Re: Quartz/JBoss App fails to deploy on Postgres 9.0

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jason Long <mailing(dot)lists(at)octgsoftware(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Quartz/JBoss App fails to deploy on Postgres 9.0
Date: 2010-07-29 20:04:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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(
>     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 

You can get the 9.0 development driver here, it just hasn't been linked 
into the website yet.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2010-07-29 20:13:58
Subject: Re: Idle in TX / Java process hang's in the vicinity of JDBC
Previous:From: Jason LongDate: 2010-07-29 18:32:52
Subject: Quartz/JBoss App fails to deploy on Postgres 9.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group