informix 出现 Database not selected yet,紧急求助!!!!
数据库采用informix , 应用服务 采用websphere6.1(正版) ,jdk5.0 , 每天都会当机N次, 然后重启应用后过了一会还会当机,不知道什么原因??? 换了tomcat6.0 也是一样,所以不是应用的问题, 也不是数据库的问题,可能是 连接配置有问题,但不知道怎么解决??? 以下是报错的情况: (请高手帮忙,看看怎么解决,小弟先谢了!!!必有重谢,
小弟QQ: 15159909 )
[09-6-4 13:20:01:848 GMT] 0000002e SystemOut O hql=select distinct pb.id, pb.projectType, pb.projName, pb.loanLimitForm, pb.projLoanLimit, pb.projLoanLimitBal, pb.status, pb.appstat ,ci.name from CoopProjBaseInfo pb, CustomerInfo ci where pb.custcd = ci.id and ci.custType = '2' and pb.projName like ? and pb.brcode = '0013' and pb.status = '0' and pb.appstat = '0' and not exists (select po.projectno from CoopProjApply po where po.projectno = pb.projectno and po.status = '0')
[09-6-4 13:20:03:466 GMT] 0000002e SystemOut O org.hibernate.util.JDBCExceptionReporter 2009-06-04 13:20:03,466 -- WARN -- SQL Error: -349, SQLState: IX000
[09-6-4 13:20:03:466 GMT] 0000002e SystemOut O org.hibernate.util.JDBCExceptionReporter 2009-06-04 13:20:03,466 -- WARN -- SQL Error: -349, SQLState: IX000
[09-6-4 13:20:03:466 GMT] 0000002e SystemOut O org.hibernate.util.JDBCExceptionReporter 2009-06-04 13:20:03,466 -- ERROR -- Database not selected yet.
[09-6-4 13:20:03:466 GMT] 0000002e SystemOut O org.hibernate.util.JDBCExceptionReporter 2009-06-04 13:20:03,466 -- ERROR -- Database not selected yet.
[09-6-4 13:20:03:479 GMT] 0000002e SystemOut O org.hibernate.event.def.DefaultLoadEventListener 2009-06-04 13:20:03,467 -- INFO -- Error performing load command
org.hibernate.exception.GenericJDBCException: could not load an entity: [com.huateng.ebank.entity.data.Loaninfo#gd200906030068]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1799)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:93)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:161)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:869)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:788)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:781)
at org.springframework.orm.hibernate3.HibernateTemplate$3.doInHibernate(HibernateTemplate.java:490)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.load(HibernateTemplate.java:484)
at org.springframework.orm.hibernate3.HibernateTemplate.load(HibernateTemplate.java:478)
at com.huateng.ebank.entity.dao.LoaninfoDAO.query(LoaninfoDAO.java:53)
at com.huateng.ebank.business.loanapply.LoanApplyService.getBasicInfo(LoanApplyService.java:2451)
at com.huateng.ebank.business.inquiryprint.cqGetter.loan.LoaninfoGetter.call(LoaninfoGetter.java:50)
at com.huateng.commquery.process.call._CallGetter.process(_CallGetter.java:110)
at com.huateng.ebank.web.commQuery.BaseGetter.process(BaseGetter.java:50)
at com.huateng.commquery.process.call.BaseCallGetterProcess.processAsync(BaseCallGetterProcess.java:49)
at com.huateng.commquery.process.base._ResultViewProcess.processAsyncBean(_ResultViewProcess.java:587)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:696)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:641)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1425)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:92)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:193)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:725)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:847)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)
Caused by:
java.sql.SQLException: Database not selected yet.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:349)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3039)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3349)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2250)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2170)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1079)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1820)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
... 62 more
-------------以上就是报错信息-------
[解决办法]
问题出在连接的管理上