Re: postgresql server version & JDBC driver version

Thanks for your quick response.

There are several layers between the application and the JDBC. There is
hibernate ORM and Bitronix transaction manager so it's hard to tell exactly
what causes the problem. It all boils down to this exception (i've tried to
throw out the irrelevant parts).

...
...
Caused by: org.hibernate.exception.GenericJDBCException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:606)
... 34 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of
a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE
with usage count 1 wrapping org(dot)postgresql(dot)xa(dot)PGXAConnection(at)12fd60c0 on
Pooled connection wrapping physical connection
org(dot)postgresql(dot)jdbc4(dot)Jdbc4Connection(at)38dae6fd
at
bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at
bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at
bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy18.prepareStatement(Unknown Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 42 more
Caused by: bitronix.tm.internal.BitronixSystemException: transaction timed
out
at
bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:63)
at
bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 55 more

I've looked into the jdbc list (http://jdbc.postgresql.org/download.html).
According to this list i should have picked the 9.1-903 JDBC 3
<http://jdbc.postgresql.org/download/postgresql-9.1-903.jdbc3.jar>, since
i'm using 9.1.* postgres version and the JDBC4 driver is not fully
implemented according to
(quoting)

- *JDK 1.6 - JDBC4. Support for JDBC4 methods is not complete, but the
majority of methods are implemented.*

I'm just asking to see whether is is worth the fuss of switching to 9.1-903
JDBC 3 <http://jdbc.postgresql.org/download/postgresql-9.1-903.jdbc3.jar>
and see if there is any chance this problem is solved with another driver.

Anyway, thanks for your help

On Thu, Jul 3, 2014 at 3:03 PM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:

> Can you elaborate as to your problems. That driver should work fine
> depending on what you are doing. Also it would be better to use the jdbc
> list.
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On 3 July 2014 06:25, Orestis Tsakiridis <otsakir(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> I'm running a postgresql server with version:
>>
>> # psql --version
>> psql (PostgreSQL) 9.1.12
>>
>>
>> What is the correct jdbc driver version for this server?
>>
>> I'm currently using postgresql-9.2-1002.jdbc4.jar and having some
>> problems with it and was thinking that maybe i'm using
>> the wrong driver.
>>
>> Also, if it makes any difference i'm using JDK 1.6
>>
>>
>>
>>
>