Hibernate:
select
*
from
( select
buyorder0_.ID as ID16_,
buyorder0_.ORDER_CODE as ORDER2_16_,
buyorder0_.APPLY_CHECKTIME as APPLY3_16_,
buyorder0_.BILL_ID as BILL4_16_,
buyorder0_.CHECK_TIME as CHECK5_16_,
buyorder0_.CREATE_DATE as CREATE6_16_,
buyorder0_.SEND_TIME as SEND7_16_,
buyorder0_.INFORM_TIME as INFORM8_16_,
buyorder0_.IN_HOUSETIME as IN9_16_,
buyorder0_.SORT_TIME as SORT10_16_,
buyorder0_.IS_INFORM as IS11_16_,
buyorder0_.ISVALID as ISVALID16_,
buyorder0_.MODIFIOR as MODIFIOR16_,
buyorder0_.MODIFY_DATE as MODIFY14_16_,
buyorder0_.ORDER_TIME as ORDER15_16_,
buyorder0_.RECEIVE_TIME as RECEIVE16_16_,
buyorder0_.REPORTOR as REPORTOR16_,
buyorder0_.SENDOR as SENDOR16_,
buyorder0_.STATUS as STATUS16_,
buyorder0_.SUM_MONEY as SUM20_16_,
buyorder0_.SUPPLY_ID as SUPPLY21_16_
from
gur_buyorder_main buyorder0_
where
buyorder0_.ISVALID=0
and buyorder0_.STATUS=3
order by
buyorder0_.ORDER_CODE ASC )
where
rownum <= ?
2012-04-24 14:03:07,550 [mpc] WARN [http-8082-2] JDBCExceptionReporter.logExceptions(71) | SQL Error: 17004, SQLState: null
2012-04-24 14:03:07,559 [mpc] ERROR [http-8082-2] JDBCExceptionReporter.logExceptions(72) | 无效的列类型: getInt not implemented for class oracle.jdbc.driver.T4CDateAccessor
2012-04-24 14:05:51,956 [mpc] ERROR [http-8082-2] runtime.error(96) |
Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.GenericJDBCException: could not execute query
The problematic instruction:
----------
==> ${msg[0]} [on line 68, column 29 in org/apache/struts2/dispatcher/error.ftl]
----------
Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.GenericJDBCException: could not execute query
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:136)
at freemarker.ext.beans.SimpleMethodModel.get(SimpleMethodModel.java:146)
at freemarker.core.DynamicKeyName.dealWithNumericalKey(DynamicKeyName.java:111)
at freemarker.core.DynamicKeyName._getAsTemplateModel(DynamicKeyName.java:90)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.Expression.getStringValue(Expression.java:93)
at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.IfBlock.accept(IfBlock.java:82)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:172)
at freemarker.core.Environment.visit(Environment.java:351)
at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.IfBlock.accept(IfBlock.java:82)