[code="java"]
ibernate: select sysright0_.ID as ID34_, sysright0_.TEXT as TEXT34_, sysright0_.PID as PID34_, sysright0_.LEAF as LEAF34_ from DTJC.SYS_RIGHT sysright0_ where sysright0_.PID=0
2011-8-28 11:29:02 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet default threw exception
java.lang.IllegalStateException
at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
at org.apache.struts2.dispatcher.Dispatcher.sendError(Dispatcher.java:752)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:505)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
[/code]
freemarker.template.TemplateModelException: Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.SQLGrammarException: [color=red]could not execute query [/color]
这是sql执行不了啊
确定两件事：
1、数据库是否连接上（配置，网络等）
2、如果能连接，这个sql能否执行：
select sysright0_.ID as ID34_, sysright0_.TEXT as TEXT34_, sysright0_.PID as PID34_, sysright0_.LEAF as LEAF34_ from DTJC.SYS_RIGHT sysright0_ where sysright0_.PID=0
没有更多的错误信息了吗
另外一点就是这个语句是hibernate生成的还是你写的：
select sysright0_.ID as ID34_, sysright0_.TEXT as TEXT34_, sysright0_.PID as PID34_, sysright0_.LEAF as LEAF34_ from DTJC.SYS_RIGHT sysright0_ where sysright0_.PID=0
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:130)
SimpleMethodModel第130行有必要发出来瞧瞧
数据库版本一致吗？
1，查看数据库连接语句，还有，对于mysql这样的，连接语句里面得加上编码，编码不对连不上，比如
[code="java"]jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8[/code]
2，oracle的话数据库版本可能有问题，你先用数据库客户端连接，并操作一下，看能否完成，不能的话，可能就是数据库监听的问题咯。
3，你copy到你电脑后，数据库备份你是怎样的，你是从别的电脑copy的？