Home > mailing lists

Re: postgresql server version & JDBC driver version - Mailing list pgsql-general

From	Orestis Tsakiridis
Subject	Re: postgresql server version & JDBC driver version
Date	July 3, 2014 16:26:22
Msg-id	CAEadVm9Tw2UxNVd9u6=NKpM5YKVQrLL3xCKNx8Yx85buFsvbbQ@mail.gmail.com Whole thread Raw
In response to	Re: postgresql server version & JDBC driver version (Dave Cramer <pg@fastcrypt.com>)
Responses	Re: postgresql server version & JDBC driver version (Dave Cramer <pg@fastcrypt.com>)
List	pgsql-general

Tree view

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.postgresql.xa.PGXAConnection@12fd60c0 on Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@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, 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 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@fastcrypt.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@gmail.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

pgsql-general by date:

From: Adrian Klaver
Date: 03 July 2014, 16:15:16
Subject: Re: Failed to build transaction for opengeo-server

From: Dave Cramer
Date: 03 July 2014, 16:32:27
Subject: Re: postgresql server version & JDBC driver version

Re: postgresql server version & JDBC driver version - Mailing list pgsql-general

Previous

Next