1. Informix wants to prefix all tables for some reason forum.hibernate.orgI've been involved in porting an app from one database to another (not so simple, I know.) In any case, its at least working code to start from. I'm seening a behaviour I didn't see before: Hibernate seems to want to prefix all table names with the login user under informix. Thus if I have login user X and Y, all ... |
2. Informix - Could not position within a table forum.hibernate.orgErro 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 ... |