首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Web开发 >

大侠们快来帮忙模糊查询小弟我的控制台报这样的异常是什么意思,如何改啊

2011-12-27 
大侠们快来帮忙模糊查询我的控制台报这样的错误是什么意思,怎么改啊?fromBookinfotabasbi,Bookcatalogtaba

大侠们快来帮忙模糊查询我的控制台报这样的错误是什么意思,怎么改啊?
from   Bookinfotab   as   bi,Bookcatalogtab   as   bc   where   1=1   and   bc.bookId=bi.bookId   and   bi.shopId=1
from   Bookinfotab   as   bi,Bookcatalogtab   as   bc   where   1=1   and   bc.bookId=bi.bookId   and   bi.shopId=1   and   bc.author   like   '%李% '
org.hibernate.exception.GenericJDBCException:   could   not   execute   query
at   org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at   org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at   org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at   org.hibernate.loader.Loader.doList(Loader.java:2148)
at   org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at   org.hibernate.loader.Loader.list(Loader.java:2024)
at   org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at   org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at   org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at   org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at   org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at   dao.BaseDao.findAll(BaseDao.java:34)
at   dao.booksell.BookSellDao.queryBookin(BookSellDao.java:54)
at   service.booksell.BooksellService.queryBookinfo(BooksellService.java:53)
at   view.booksell.BooksellDBean.queryBooksell(BooksellDBean.java:168)
at   view.booksell.BooksellDBean.queryReturn(BooksellDBean.java:137)
at   sun.reflect.NativeMethodAccessorImpl.invoke0(Native   Method)
at   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at   java.lang.reflect.Method.invoke(Method.java:585)
at   org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
at   org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
at   javax.faces.component.UICommand.broadcast(UICommand.java:106)
at   org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:180)
at   org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:158)
at   org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:329)
at   org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
at   org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
at   javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at   org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)


at   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at   org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at   org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at   org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at   org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at   java.lang.Thread.run(Thread.java:595)
Caused   by:   java.sql.SQLException:   Cannot   convert   value   '5 '   from   column   5(5   )   to   TIMESTAMP.
at   com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:3995)
at   com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:1896)
at   com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:1910)
at   org.hibernate.type.TimestampType.get(TimestampType.java:30)
at   org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at   org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at   org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at   org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:1899)
at   org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1372)
at   org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1300)
at   org.hibernate.loader.Loader.getRow(Loader.java:1197)
at   org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:569)
at   org.hibernate.loader.Loader.doQuery(Loader.java:689)
at   org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at   org.hibernate.loader.Loader.doList(Loader.java:2145)
...   42   more

[解决办法]
Cannot convert value '5 ' from column 5(5 ) to TIMESTAMP从这里看感觉是你做映射的时候数据类型不匹配了

热点排行