Jack Zhang commented on Bug HHH-2847

we got very similar error with hibernate3.6.7 + oracle 11.1

FONTPMPO:1073391058:107:W:20121221102755.345:JDBCExceptionReporter.logExceptions:SQL Error: 904, SQLState: 42000
FONTPMPO:1073391058:108:S:20121221102755.346:JDBCExceptionReporter.logExceptions:ORA-00904: "THIS_"."CODE": invalid identifier
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main:uncaught client exception
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main:org.hibernate.exception.SQLGrammarException: could not execute query
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.doList(Loader.java:2536)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.list(Loader.java:2271)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at com.signaldemand.flank.hibernate.dao.GenericDAO.findByExample(GenericDAO.java:150)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at com.signaldemand.flank.etljava.dataexport.DataExporter.setup(DataExporter.java:161)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at com.signaldemand.flank.etljava.dataexport.DataExporter.run(DataExporter.java:375)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at com.signaldemand.flank.etljava.dataexport.DataExporter.main(DataExporter.java:458)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main:Caused by: java.sql.SQLException: ORA-00904: "THIS_"."CODE": invalid identifier
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main:
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.doQuery(Loader.java:802)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: at org.hibernate.loader.Loader.doList(Loader.java:2533)
FONTPMPO:1073391058:109:S:20121221102755.350:DataExporter.main: ... 9 more

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira