Hi everyone,

I started experiencing this problem since I migrated to hibernate3.

I've tried many different jdbc drivers and connection pools (jboss, commons dbcp, etc). This error happens when hibernate tries to query anything in the database for the first time.

Hibernate3 final with JBoss 4.0.1 and Postgresql 7.4:

Stack Trace:
org.postgresql.util.PSQLException: The backend currently does not support this feature.
at org.postgresql.jdbc2.AbstractJdbc2Statement.getFetchDirection()I(AbstractJdbc2Statement.java:133)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.<init>(Ljava.sql.PreparedStatement;)V(CachedPreparedStatement.java:62)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(Ljava.lang.String;)Ljava.sql.PreparedStatement;(BaseWrapperManagedConnection.java:349)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Ljava.lang.String;)Ljava.sql.PreparedStatement;(WrappedConnection.java:205)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(Ljava.sql.Connection;Ljava.lang.String;ZZLorg.hibernate.ScrollMode;Z)Ljava.sql.PreparedStatement;(AbstractBatcher.java:379)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(Ljava.sql.Connection;Ljava.lang.String;ZLorg.hibernate.ScrollMode;)Ljava.sql.PreparedStatement;(AbstractBatcher.java:320)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(Ljava.lang.String;ZLorg.hibernate.ScrollMode;)Ljava.sql.PreparedStatement;(AbstractBatcher.java:86)
at org.hibernate.loader.Loader.prepareQueryStatement(Lorg.hibernate.engine.QueryParameters;ZLorg.hibernate.engine.SessionImplementor;)Ljava.sql.PreparedStatement;(Loader.java:1089)
at org.hibernate.hql.classic.QueryTranslatorImpl.iterate(Lorg.hibernate.engine.QueryParameters;Lorg.hibernate.engine.SessionImplementor;)Ljava.util.Iterator;(QueryTranslatorImpl.java:894)
at org.hibernate.impl.SessionImpl.iterate(Ljava.lang.String;Lorg.hibernate.engine.QueryParameters;)Ljava.util.Iterator;(SessionImpl.java:872)
at org.hibernate.impl.QueryImpl.iterate()Ljava.util.Iterator;(QueryImpl.java:41)


Any ideas?

Thank you!

Btw, it seems to be working just fine on Postgres 8.0, but I really need it to work on 7.4. I tried to make hibernate not to use jdbc2 but nothing changed, I still got the same exception.

I tried setting these properties to avoid using jdbc2:
hibernate.jdbc.batch_size=0
hibernate.jdbc.use_scrollable_resultsets=false

Thank you,
Felipe