any ideas?

org.hibernate.exception.GenericJDBCException: Could not position within a table or org.hibernate.exception.GenericJDBCException: Could not do a physical-order read to fetch next row

with Hibernate 3.0.5, DB Informix (latest release) and WebSphere 6

Erro Code: -244
SQL State: IX000
Origem: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at com.porto.sinistro.dao.AvisoSinistroDAOHibernate.obterAvisosPorPeriodoAviso(AvisoSinistroDAOHibernate.java:315)
at com.porto.sinistro.model.AvisoSinistroModelBean.obterAvisosPorDataAviso(AvisoSinistroModelBean.java:1321)
at com.porto.sinistro.model.EJSRemoteStatelessAvisoSinistroModel_b8489aea.obterAvisosPorDataAviso(EJSRemoteStatelessAvisoSinistroModel_b8489aea.java:983)
at com.porto.sinistro.model._EJSRemoteStatelessAvisoSinistroModel_b8489aea_Tie.obterAvisosPorDataAviso(_EJSRemoteStatelessAvisoSinistroModel_b8489aea_Tie.java:721)
at com.porto.sinistro.model._EJSRemoteStatelessAvisoSinistroModel_b8489aea_Tie._invoke(_EJSRemoteStatelessAvisoSinistroModel_b8489aea_Tie.java:93)
at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java(Compiled Code))
at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java(Compiled Code))
at com.ibm.rmi.iiop.ORB.process(ORB.java(Compiled Code))
at com.ibm.CORBA.iiop.ORB.process(ORB.java(Compiled Code))
at com.ibm.rmi.iiop.Connection.doWork(Connection.java(Compiled Code))
at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java(Compiled Code))
at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.sql.SQLException: Could not do a physical-order read to fetch next row.
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3204)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java(Compiled Code))
at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.a(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java(Inlined Compiled Code))
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java(Compiled Code))
at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java(Compiled Code))
at org.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
at org.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 17 more
Caused by: java.sql.SQLException: ISAM error: record is locked.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
... 32 more

Google is your friend:

http://www-1.ibm.com/support/docview.ws ... wg21211663

I carried through all the listed configurations below but none decided my problem:
http://www-128.ibm.com/developerworks/d ... index.html

Other configurations that I made and that also they did not resolved my problem

- connection.isolation to 1, 2 and 4
- connection.release_mode to after_statement
- connection.datasource via EJB reference with isolation TRANSACTION_NONE and TRANSACTION_READ_UNCOMMITED
- use of LockMode.READ in my CreateCriteria
- datasource with and without support XA

Using direct connection JDBC with lookup datasource through EJB reference, the dirty read it functioned correctly.

Somebody has some idea to resolve my problem? Exists some way it hibernate to effect dirty reading in the DB Informix?

Caused by: java.sql.SQLException

ISAM error: key value locked
ISAM error: record is locked
ISAM error: Lock Timeout Expired