浏览 3240 次
|
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
|---|---|
| 作者 | 正文 |
|
最后更新时间:2004-07-15
也许是个很简单的问题,但我确实折腾了很久,也许钻进哪条死胡同了,谁能拉我一把。。。。
主要是这个“无法转换为内部表示 ”的问题搞不明白,以前没遇到过,BINDING都是正常的。 还有,能不能请大家介绍一下你们是怎么调试HQL的 软件环境: Hibenate2.1.2 Tomcat 4.1[/code] 配置文件: [code:1]<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping> <class name="com.cetc38.pdo.personnel.Group" table="GROUPS" schema="JASON"> <id name="groupid" column="GROUPID" type="string"> <generator class="uuid.hex"/> </id> <property name="name" column="NAME" type="string" length="255" not-null="true"/> <property name="grouptypeid" column="GROUPTYPEID" type="string" length="255" not-null="true"/> <property name="grouptag" column="GROUPTAG" type="string" length="255" not-null="true"/> <property name="valid" column="VALID" type="byte" length="255" not-null="true"/> </class> </hibernate-mapping>[/code:1] 错误提示信息: [code:1]Hibernate: select * from ( select group0_.GROUPID as GROUPID, group0_.NAME as NAME, group0_.GROUPTYPEID as GROUPTYP3_, group0_.GROUPTAG as GROUPTAG, group0_.VALID as VALID from JASON.GROUPS group0_ ) where rownum <= ? 09:49:37,093 WARN JDBCExceptionReporter:38 - SQL Error: 17059, SQLState: null 09:49:37,093 ERROR JDBCExceptionReporter:46 - 无法转换为内部表示 09:49:37,173 WARN JDBCExceptionReporter:38 - SQL Error: 17059, SQLState: null 09:49:37,173 ERROR JDBCExceptionReporter:46 - 无法转换为内部表示 09:49:37,183 ERROR JDBCExceptionReporter:38 - Could not execute query java.sql.SQLException: 无法转换为内部表示 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273) at oracle.jdbc.driver.OracleStatement.getLongValue(OracleStatement.java:3194) at oracle.jdbc.driver.OracleStatement.getByteValue(OracleStatement.java:3123) at oracle.jdbc.driver.OracleResultSetImpl.getByte(OracleResultSetImpl.java:317) at oracle.jdbc.driver.OracleResultSet.getByte(OracleResultSet.java:1398) at net.sf.hibernate.type.ByteType.get(ByteType.java:18) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53) at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:66) at net.sf.hibernate.loader.Loader.hydrate(Loader.java:611) at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:552) at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:511) at net.sf.hibernate.loader.Loader.getRow(Loader.java:426) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:209) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:950) at net.sf.hibernate.loader.Loader.list(Loader.java:941) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at com.cetc38.bdo.personnel.GroupPerson.getInitGroups(GroupPerson.java:45) at com.cetc38.bdo.personnel.GroupTree.init(GroupTree.java:35) at com.cetc38.bdo.personnel.GroupTree.<init>(GroupTree.java:26) at com.cetc38.webApp.webAppMan.action.WebappAction.execute(WebappAction.java:118) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.cetc38.db.SetEncodeFilter.doFilter(SetEncodeFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) net.sf.hibernate.JDBCException: Could not execute query at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1515) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at com.cetc38.bdo.personnel.GroupPerson.getInitGroups(GroupPerson.java:45) at com.cetc38.bdo.personnel.GroupTree.init(GroupTree.java:35) at com.cetc38.bdo.personnel.GroupTree.<init>(GroupTree.java:26) at com.cetc38.webApp.webAppMan.action.WebappAction.execute(WebappAction.java:118) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.cetc38.db.SetEncodeFilter.doFilter(SetEncodeFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: 无法转换为内部表示 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273) at oracle.jdbc.driver.OracleStatement.getLongValue(OracleStatement.java:3194) at oracle.jdbc.driver.OracleStatement.getByteValue(OracleStatement.java:3123) at oracle.jdbc.driver.OracleResultSetImpl.getByte(OracleResultSetImpl.java:317) at oracle.jdbc.driver.OracleResultSet.getByte(OracleResultSet.java:1398) at net.sf.hibernate.type.ByteType.get(ByteType.java:18) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53) at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:66) at net.sf.hibernate.loader.Loader.hydrate(Loader.java:611) at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:552) at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:511) at net.sf.hibernate.loader.Loader.getRow(Loader.java:426) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:209) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:950) at net.sf.hibernate.loader.Loader.list(Loader.java:941) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512) ... 43 more[/code:1] 你的分析: 调用的代码为: [code:1]public List getInitGroups() throws HibernateException { String querystr = "from Group"; Query query = super.session.createQuery(querystr); this.setQueryPage(query); System.out.println("The init Group selected :"+ query.list().size()); return query.list(); } [/code:1] 这是最简单的查询了,可还是通不过,在服务器启动时没有出现任何错误,而且提示binding也是正常的。可一运行上面的代码就出现错误,同时部署的其他类都可以很好的工作,实在想不出什么原因了,昨天折腾了一下午,今天上午又快过去了。请哪位高手救救我吧。哪怕只是看了我的问题,我也谢谢你了。 声明:JavaEye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
|
|
| 返回顶楼 | |
|
最后更新时间:2004-07-15
没人回答吗,痛苦ing......!
|
|
| 返回顶楼 | |
|
最后更新时间:2004-07-15
应该是你的那个byte 类型的属性,用 blob
|
|
| 返回顶楼 | |
|
最后更新时间:2004-07-15
谢谢楼上的回答,我明天再改一下试试。
|
|
| 返回顶楼 | |
|
最后更新时间:2004-07-16
果然是属性设置在byte的问题,我改了一下就好了,谢谢SANWA网友的提示,真的非常感谢。
|
|
| 返回顶楼 | |





