Anyone out there using Netezza with Hibernate ? I am used PostgreSQL dialect but cannot execute queries due to error reported by Netezza Driver : “Driver can process one query at one time” .

As per Netezza's suggestions, I've tried setting C3P0 connection provider to use only thread, execute one statement at a time and even removed connection provider but still cannot execute queries. Program does connect fine. I do open and close Session for each request.

Any help greatly appreciated !
The error :
JDBCExceptionReporter - WARN - SQL Error: 11403, SQLState: HY014
JDBCExceptionReporter - ERROR - Driver can process one query at one time
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
a
Caused by: org.netezza.error.NzSQLException: Driver can process one query at one time
at org.netezza.internal.QueryExecutor.sendQuery(QueryExecutor.java:425)
at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:71)
at org.netezza.sql.NzConnection.execute(NzConnection.java:2461)
at org.netezza.sql.NzStatement._execute(NzStatement.java:839)
at org.netezza.sql.NzPreparedStatament.executeQuery(NzPreparedStatament.java:158)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 9 more

I guess you are performing 2 queries with 'cursor' (alternative would be 'select') using the same connection.
Not all drivers support MultipleOpenResults
http://java.sun.com/javase/6/docs/api/j ... enResults()

Please check if your driver supports MultipleOpenResults

I believe is does not and I cannot seem to figure out how to telll Hibernate not to issue multiple queries. I will try the code you provided to check for sure.

Thanks verymuch,
Rich
quote="pb00067"]
I guess you are performing 2 queries with 'cursor' (alternative would be 'select') using the same connection.
Not all drivers support MultipleOpenResults
http://java.sun.com/javase/6/docs/api/j ... enResults()

Please check if your driver supports MultipleOpenResults
[/quote]

Hibernate normally does not not to issue multiple queries, except if you explicitly use ScrollabeResults on queries.