Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: Hibernate 2.1.8

Code between sessionFactory.openSession() and session.close():

Transaction t = session.beginTransaction();
Session session = HibernateSessionFactory.currentSession();
Criteria criterios = session.createCriteria(Nota.class);

//Nota.class extends Documento.class, and I've configured a discriminator column
//in Documento.hbm.xml, the discriminator column is cod_tipo.
//Here, there are many criterios.add() controlled by if blocks, that i'm not executing, //cause i choose only filter by cod_tipo.

Collection documentos = criterios.list();
t.commit();
HibernateSessionFactory.currentSession();


My SessionFactory class is provided by MyEclipse ide plugin for eclipse.

Full stack trace of any exception that occurs:
The FIRST time i tried execute the query below, i get this exception:
DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.SQLException: General exception error has occurred in the optimizer.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: -874, SQLState: IX000
ERROR [net.sf.hibernate.util.JDBCExceptionReporter] General exception error has occurred in the optimizer.
DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] Unable to perform find
java.sql.SQLException: General exception error has occurred in the optimizer.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: -874, SQLState: IX000
ERROR [net.sf.hibernate.util.JDBCExceptionReporter] General exception error has occurred in the optimizer.
net.sf.hibernate.exception.GenericJDBCException: Unable to perform find
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3663)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: General exception error has occurred in the optimizer.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
... 45 more
java.lang.NullPointerException
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:238)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)



The SECOND time i get this:
Hibernate:
DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.SQLException: System or internal error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2198)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: -79716, SQLState: IX000
ERROR [net.sf.hibernate.util.JDBCExceptionReporter] System or internal error
DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] Unable to perform find
java.sql.SQLException: System or internal error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2198)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: -79716, SQLState: IX000
ERROR [net.sf.hibernate.util.JDBCExceptionReporter] System or internal error
net.sf.hibernate.exception.GenericJDBCException: Unable to perform find
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3663)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at ar.gov.rosario.notas.struts.services.documento.DocumentoService.buscarDocumentos(DocumentoService.java:782)
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: System or internal error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2198)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
... 45 more
java.lang.NullPointerException
at ar.gov.rosario.notas.struts.actions.GeneralDispatchAction.buscarDocumentos(GeneralDispatchAction.java:238)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at ar.gov.rosario.notas.struts.actions.CustomBaseDispatchAction.execute(CustomBaseDispatchAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
INFO [org.apache.struts.util.PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true



Name and version of the database you are using:
IBM Informix Dynamic Server Version 7.31.UD8

The generated SQL (show_sql=true):
(1)
select this.id_documento as id_docum1_26_, this.imp_sellado as imp_sel27_26_, this.anio_expte as anio_expte26_, this.nro_expte as nro_expte26_, this.id_persona as id_persona26_, this.id_direccion as id_dire31_26_, this.numero as numero26_, this.anio as anio26_, this.fec_ing_sist as fec_ing_5_26_, this.descripcion as descripc6_26_, this.fec_creacion as fec_crea7_26_, this.fojas as fojas26_, this.incremento as incremento26_, this.fojas_totales as fojas_t10_26_, this.rel_padre as rel_padre26_, this.nro_anexo as nro_anexo26_, this.nro_paquete_archiv as nro_paq13_26_, this.ubicacion_archivo as ubicaci14_26_, this.observacion as observa15_26_, this.fec_ult_operacion as fec_ult16_26_, this.fec_est_resolucion as fec_est17_26_, this.cod_area_actual as cod_are18_26_, this.cod_area_cr as cod_are19_26_, this.cod_area_origen as cod_are20_26_, this.cod_area_futura as cod_are21_26_, this.cod_asunto as cod_asunto26_, this.cod_estado_actual as cod_est23_26_, this.origen as origen26_, this.cod_usuario_cr as cod_usu25_26_, this.cod_tipo as cod_tipo26_, this.id_documento_padre as id_docu26_26_, persona1_.id_persona as id_persona0_, persona1_.apellidos as apellidos0_, persona1_.nombres as nombres0_, persona1_.sexo as sexo0_, persona1_.nro_documento as nro_docu5_0_, persona1_.cod_tipo_identif as cod_tipo6_0_, tipoidenti2_.cod_tipo_identif as cod_tipo1_1_, tipoidenti2_.dsc_tipo_identif as dsc_tipo2_1_, tipoidenti2_.dsc_reducida as dsc_redu3_1_, tipoidenti2_.fecha_cr as fecha_cr1_, tipoidenti2_.fecha_mod as fecha_mod1_, tipoidenti2_.abreviatura as abreviat6_1_, tipoidenti2_.cod_usuario_cr as cod_usua7_1_, tipoidenti2_.cod_usuario_mod as cod_usua8_1_, usuario3_.cod_usuario as cod_usua1_2_, usuario3_.email as email2_, usuario3_.cod_area as cod_area2_, area4_.cod_oficina as cod_ofic1_3_, area4_.desc_oficina as desc_ofi2_3_, area4_.direccion as direccion3_, area4_.fecha_hora as fecha_hora3_, area4_.usuario as usuario3_, direccion5_.id_direccion as id_direc1_4_, direccion5_.calle as calle4_, direccion5_.cod_calle as cod_calle4_, direccion5_.numero as numero4_, direccion5_.letra as letra4_, direccion5_.bis as bis4_, direccion5_.interseccion as intersec7_4_, direccion5_.piso as piso4_, direccion5_.cod_calle_int as cod_call9_4_, direccion5_.departamento as departa10_4_, direccion5_.monoblock as monoblock4_, direccion5_.localidad as localidad4_, area6_.cod_oficina as cod_ofic1_5_, area6_.desc_oficina as desc_ofi2_5_, area6_.direccion as direccion5_, area6_.fecha_hora as fecha_hora5_, area6_.usuario as usuario5_, area7_.cod_oficina as cod_ofic1_6_, area7_.desc_oficina as desc_ofi2_6_, area7_.direccion as direccion6_, area7_.fecha_hora as fecha_hora6_, area7_.usuario as usuario6_, area8_.cod_oficina as cod_ofic1_7_, area8_.desc_oficina as desc_ofi2_7_, area8_.direccion as direccion7_, area8_.fecha_hora as fecha_hora7_, area8_.usuario as usuario7_, area9_.cod_oficina as cod_ofic1_8_, area9_.desc_oficina as desc_ofi2_8_, area9_.direccion as direccion8_, area9_.fecha_hora as fecha_hora8_, area9_.usuario as usuario8_, asunto10_.cod_asunto as cod_asunto9_, asunto10_.dsc_asunto as dsc_asunto9_, asunto10_.activo as activo9_, asunto10_.fec_creacion as fec_crea4_9_, asunto10_.fec_modificacion as fec_modi5_9_, asunto10_.cod_usuario_cr as cod_usua6_9_, asunto10_.cod_usuario_mod as cod_usua7_9_, estado11_.cod_estado as cod_estado10_, estado11_.nombre as nombre10_, estado11_.dsc_reducida as dsc_redu3_10_, estado11_.fecha_cr as fecha_cr10_, estado11_.fecha_mod as fecha_mod10_, estado11_.cod_usuario_cr as cod_usua6_10_, estado11_.cod_usuario_mod as cod_usua7_10_, origen12_.cod_origen as cod_origen11_, origen12_.nombre as nombre11_, origen12_.dsc_reducida as dsc_redu3_11_, origen12_.fecha_cr as fecha_cr11_, origen12_.fecha_mod as fecha_mod11_, origen12_.cod_usuario_cr as cod_usua6_11_, origen12_.cod_usuario_mod as cod_usua7_11_, tipodocume13_.cod_tipo as cod_tipo12_, tipodocume13_.dsc_tipo as dsc_tipo12_, tipodocume13_.fec_creacion as fec_crea3_12_, tipodocume13_.fec_modificacion as fec_modi4_12_, tipodocume13_.dsc_reducida as dsc_redu5_12_, tipodocume13_.cod_usuario_cr as cod_usua6_12_, tipodocume13_.cod_usuario_mod as cod_usua7_12_, documento14_.id_documento as id_docum1_13_, documento14_.cod_tipo as cod_tipo13_, documento14_.numero as numero13_, documento14_.anio as anio13_, documento14_.fec_ing_sist as fec_ing_5_13_, documento14_.descripcion as descripc6_13_, documento14_.fec_creacion as fec_crea7_13_, documento14_.fojas as fojas13_, documento14_.incremento as incremento13_, documento14_.fojas_totales as fojas_t10_13_, documento14_.rel_padre as rel_padre13_, documento14_.nro_anexo as nro_anexo13_, documento14_.nro_paquete_archiv as nro_paq13_13_, documento14_.ubicacion_archivo as ubicaci14_13_, documento14_.observacion as observa15_13_, documento14_.fec_ult_operacion as fec_ult16_13_, documento14_.fec_est_resolucion as fec_est17_13_, documento14_.cod_area_actual as cod_are18_13_, documento14_.cod_area_cr as cod_are19_13_, documento14_.cod_area_origen as cod_are20_13_, documento14_.cod_area_futura as cod_are21_13_, documento14_.cod_asunto as cod_asunto13_, documento14_.cod_estado_actual as cod_est23_13_, documento14_.origen as origen13_, documento14_.cod_usuario_cr as cod_usu25_13_, documento14_.id_documento_padre as id_docu26_13_, documento14_.imp_sellado as imp_sel27_13_, documento14_.anio_expte as anio_expte13_, documento14_.nro_expte as nro_expte13_, documento14_.id_persona as id_persona13_, documento14_.id_direccion as id_dire31_13_, documento14_.nro_oficio as nro_oficio13_, documento14_.juzgado as juzgado13_, documento14_.tipo_consejo as tipo_co34_13_, documento14_.nro_consejo as nro_con35_13_, documento14_.nro_expte_consejo as nro_exp36_13_, documento14_.anio_expte_consejo as anio_ex37_13_, documento14_.anio_doc_origen as anio_do38_13_, documento14_.cod_tipo_origen as cod_tip39_13_, documento14_.nro_doc_origen as nro_doc40_13_, area15_.cod_oficina as cod_ofic1_14_, area15_.desc_oficina as desc_ofi2_14_, area15_.direccion as direccion14_, area15_.fecha_hora as fecha_hora14_, area15_.usuario as usuario14_, area16_.cod_oficina as cod_ofic1_15_, area16_.desc_oficina as desc_ofi2_15_, area16_.direccion as direccion15_, area16_.fecha_hora as fecha_hora15_, area16_.usuario as usuario15_, area17_.cod_oficina as cod_ofic1_16_, area17_.desc_oficina as desc_ofi2_16_, area17_.direccion as direccion16_, area17_.fecha_hora as fecha_hora16_, area17_.usuario as usuario16_, area18_.cod_oficina as cod_ofic1_17_, area18_.desc_oficina as desc_ofi2_17_, area18_.direccion as direccion17_, area18_.fecha_hora as fecha_hora17_, area18_.usuario as usuario17_, asunto19_.cod_asunto as cod_asunto18_, asunto19_.dsc_asunto as dsc_asunto18_, asunto19_.activo as activo18_, asunto19_.fec_creacion as fec_crea4_18_, asunto19_.fec_modificacion as fec_modi5_18_, asunto19_.cod_usuario_cr as cod_usua6_18_, asunto19_.cod_usuario_mod as cod_usua7_18_, estado20_.cod_estado as cod_estado19_, estado20_.nombre as nombre19_, estado20_.dsc_reducida as dsc_redu3_19_, estado20_.fecha_cr as fecha_cr19_, estado20_.fecha_mod as fecha_mod19_, estado20_.cod_usuario_cr as cod_usua6_19_, estado20_.cod_usuario_mod as cod_usua7_19_, origen21_.cod_origen as cod_origen20_, origen21_.nombre as nombre20_, origen21_.dsc_reducida as dsc_redu3_20_, origen21_.fecha_cr as fecha_cr20_, origen21_.fecha_mod as fecha_mod20_, origen21_.cod_usuario_cr as cod_usua6_20_, origen21_.cod_usuario_mod as cod_usua7_20_, tipodocume22_.cod_tipo as cod_tipo21_, tipodocume22_.dsc_tipo as dsc_tipo21_, tipodocume22_.fec_creacion as fec_crea3_21_, tipodocume22_.fec_modificacion as fec_modi4_21_, tipodocume22_.dsc_reducida as dsc_redu5_21_, tipodocume22_.cod_usuario_cr as cod_usua6_21_, tipodocume22_.cod_usuario_mod as cod_usua7_21_, direccion23_.id_direccion as id_direc1_22_, direccion23_.calle as calle22_, direccion23_.cod_calle as cod_calle22_, direccion23_.numero as numero22_, direccion23_.letra as letra22_, direccion23_.bis as bis22_, direccion23_.interseccion as intersec7_22_, direccion23_.piso as piso22_, direccion23_.cod_calle_int as cod_call9_22_, direccion23_.departamento as departa10_22_, direccion23_.monoblock as monoblock22_, direccion23_.localidad as localidad22_, direccion24_.id_direccion as id_direc1_23_, direccion24_.calle as calle23_, direccion24_.cod_calle as cod_calle23_, direccion24_.numero as numero23_, direccion24_.letra as letra23_, direccion24_.bis as bis23_, direccion24_.interseccion as intersec7_23_, direccion24_.piso as piso23_, direccion24_.cod_calle_int as cod_call9_23_, direccion24_.departamento as departa10_23_, direccion24_.monoblock as monoblock23_, direccion24_.localidad as localidad23_, direccion25_.id_direccion as id_direc1_24_, direccion25_.calle as calle24_, direccion25_.cod_calle as cod_calle24_, direccion25_.numero as numero24_, direccion25_.letra as letra24_, direccion25_.bis as bis24_, direccion25_.interseccion as intersec7_24_, direccion25_.piso as piso24_, direccion25_.cod_calle_int as cod_call9_24_, direccion25_.departamento as departa10_24_, direccion25_.monoblock as monoblock24_, direccion25_.localidad as localidad24_, direccion26_.id_direccion as id_direc1_25_, direccion26_.calle as calle25_, direccion26_.cod_calle as cod_calle25_, direccion26_.numero as numero25_, direccion26_.letra as letra25_, direccion26_.bis as bis25_, direccion26_.interseccion as intersec7_25_, direccion26_.piso as piso25_, direccion26_.cod_calle_int as cod_call9_25_, direccion26_.departamento as departa10_25_, direccion26_.monoblock as monoblock25_, direccion26_.localidad as localidad25_ from documentos this left outer join personas persona1_ on this.id_persona=persona1_.id_persona left outer join tipos_identif tipoidenti2_ on persona1_.cod_tipo_identif=tipoidenti2_.cod_tipo_identif left outer join usuarios usuario3_ on tipoidenti2_.cod_usuario_cr=usuario3_.cod_usuario left outer join areas area4_ on usuario3_.cod_area=area4_.cod_oficina left outer join direcciones direccion5_ on this.id_direccion=direccion5_.id_direccion left outer join areas area6_ on this.cod_area_actual=area6_.cod_oficina left outer join areas area7_ on this.cod_area_cr=area7_.cod_oficina left outer join areas area8_ on this.cod_area_origen=area8_.cod_oficina left outer join areas area9_ on this.cod_area_futura=area9_.cod_oficina left outer join asuntos asunto10_ on this.cod_asunto=asunto10_.cod_asunto left outer join estados estado11_ on this.cod_estado_actual=estado11_.cod_estado left outer join origenes origen12_ on this.origen=origen12_.cod_origen left outer join tipos_documento tipodocume13_ on this.cod_tipo=tipodocume13_.cod_tipo left outer join documentos documento14_ on this.id_documento_padre=documento14_.id_documento left outer join areas area15_ on documento14_.cod_area_actual=area15_.cod_oficina left outer join areas area16_ on documento14_.cod_area_cr=area16_.cod_oficina left outer join areas area17_ on documento14_.cod_area_origen=area17_.cod_oficina left outer join areas area18_ on documento14_.cod_area_futura=area18_.cod_oficina left outer join asuntos asunto19_ on documento14_.cod_asunto=asunto19_.cod_asunto left outer join estados estado20_ on documento14_.cod_estado_actual=estado20_.cod_estado left outer join origenes origen21_ on documento14_.origen=origen21_.cod_origen left outer join tipos_documento tipodocume22_ on documento14_.cod_tipo=tipodocume22_.cod_tipo left outer join direcciones direccion23_ on documento14_.id_direccion=direccion23_.id_direccion left outer join direcciones direccion24_ on documento14_.id_direccion=direccion24_.id_direccion left outer join direcciones direccion25_ on documento14_.id_direccion=direccion25_.id_direccion left outer join direcciones direccion26_ on documento14_.id_direccion=direccion26_.id_direccion where 1=1 and this.cod_tipo=1 order by this.cod_tipo asc, this.anio asc, this.numero asc

Debug level Hibernate log excerpt:
DEBUG

Hi all, I need help with this problem:

Informix engine throws the first exception before this query (1), the collection of instantiated objects stays NULL, and i can continue executing queries, but when i try to execute the query (1) again, the db engine hangs up. If i change the where condition for another field, (using criteria.add()), the db engine returns the expected results.
This error is weird, because i ran this query a million times, but with others registers...
Before, there was 1000 records in documentos table... but now, there are 11000.
A lot of thanks for read my thread!

Happy christmas!

Me again... sorry, the last line of code for the section "code between open session and close session" is HibernateSessionFactory.closeSession(), NOT HibernateSessionFactory.currentSession().

Me again.
I have solved the problem but I have no time to analyze if is it a Hibernate's 2.1.8 bug or an Informix's bug.
The problem is that Hibernate generates a prepared statement with session.createCriteria(Nota.class); (Nota.class extends Documento.class, and hibernate creates a new instance of Nota from the discriminator column value) and then, the where condition on the query is hardcoded to cod_tipo = 1 (not to be replaced with a parameter) (cod_tipo is the discriminator column).
When informix compile the query, its optimizer hangs up. I solved the problem using
Criteria criteria = session.createCriteria(Documento.class);
criteria.add(Expression.eq("cod_tipo", new Integer(1));
then, hibernate creates an entirely prepared statement, and Informix works fine.

Happy new year!