当前位置: 代码迷 >> Java Web开发 >> 可以生成sql语句,在数据库执行成功-该怎么解决
  详细解决方案

可以生成sql语句,在数据库执行成功-该怎么解决

热度:6976   发布时间:2013-02-25 21:21:52
可以生成sql语句,在数据库执行成功---
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)
  相关解决方案
本站暂不开放注册!
内测阶段只得通过邀请码进行注册!