【结贴】[请求]数据库连接不上的问题**

lijunfeng

我们的业务服务器和数据库服务器搭在两台不同的服务器上。每次数据库服务器重启后，必须也要重启业务服务器，否则登录时会报错。

p.s 我们使用版本是X3 2827，数据库用的Oracle。每次登录时报错：“未连接到Oracle”。

望予回答！

atiger

请问你走的是啥服务
JBOSS  参考：http://bbs.justep.com/forum.php?mod=viewthread&tid=17841
TOMCAT  参考：http://bbs.justep.com/forum.php?mod=viewthread&tid=17612
如果是WebLogic或者Websphere就需要找他们的相关的资料了。

不过我们从3002版本开始，这部分加了这些参数。

lijunfeng

我们使用的是TomCat。楼上的帖子我们已经参考了，但数据库还是连不上。望指点！

alang

请提供服务端的错误日志
还有你修改以后的server.xml文件

lijunfeng

service.XML:
<Resource name="dbsys" url="jdbcraclecidb1" username="dbsys" password="dbsys" driverClassName="oracle.jdbc.driver.OracleDriver" auth="Container" type="javax.sql.DataSource" maxActive="2"
removeAbandoned="true" removeAbandonedTimeout="5" logAbandoned="true"/>




数据库日志：
2008-3-5 10:13:03 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-03114: 未连接到 ORALCE

java.lang.Exception: error occur during invoke getRecords method, ORA-03114: 未连接到 ORALCE

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        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 com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        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.Http11AprProcessor.process(Http11AprProcessor.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
        at java.lang.Thread.run(Thread.java:595)
2008-3-5 10:13:03 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-03114: 未连接到 ORALCE

java.lang.Exception: error occur during invoke getRecords method, ORA-03114: 未连接到 ORALCE

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        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 com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        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.Http11AprProcessor.process(Http11AprProcessor.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
        at java.lang.Thread.run(Thread.java:595)

alang

ORA-03114: 未连接到 ORALCE
这个错误是Oracle客户端报的，看看Oracle客户端目录下有什么错误日志没有

shangxy

添加这个参数看一下：
service.XML:
<Resource name="dbsys" url="jdbcraclecidb1" username="dbsys" password="dbsys" driverClassName="oracle.jdbc.driver.OracleDriver" auth="Container" type="javax.sql.DataSource" maxActive="2"
removeAbandoned="true" removeAbandonedTimeout="5" logAbandoned="true"/>
添加：
validationQuery="select count(*) from dual"或者添加这个参数看一下：validationQuery="select 1"

shangxy

经过测试是可以的

lijunfeng

我这边怎么也是试不通的。

<Resource name="dbsys" url="jdbcraclecidb1" username="dbsys" password="dbsys" driverClassName="oracle.jdbc.driver.OracleDriver" auth="Container" type="javax.sql.DataSource" maxActive="2"  removeAbandoned="true" removeAbandonedTimeout="5" logAbandoned="true" validationQuery="select count(*) from dual"/>

lijunfeng

可以了，谢谢啊