未连接到 ORALCE**

lotus

报错：未连接到 ORALCE，我用PLSQL连接数据库又没问题

2008-11-7 9:00:11 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-12571: TNS: 包写入程序失败

java.lang.Exception: error occur during invoke getRecords method, ORA-12571: TNS: 包写入程序失败

        at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        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-11-7 9:00:11 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.action.database.GetRecordsAction.doExecute(Unknown Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        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)

shangxy

出现这个错误的时候客户端是一个什么样的情况？是根本就用不了？还是就个别功能用不了？
看一下有没有一个表中定义了2个2进制字段的这种情况？

lotus

客户端根本用不了，，一操作就没反应白屏，重新登录也登录不上。。

shangxy

服务端配置工具的数据源能够测试通过么？

lotus

一张表里面没有定义2个2进制字段
重新启动一下TOMCAT就行了。。这个问题如果不解决是很大的一个隐患。

lotus

没有试，，但是PLSQL能够连上数据库

shangxy

plsql可以连接上，如果服务端配置工具中写错连接参数也会连接不上，先检查一下吧。

lotus

我觉得你这种讲话是一种不负责的态度，我讲过重新启动TOMCAT又可以了

附配置，麻烦帮我看一下有什么问题

shangxy

如果是这样也有可能是应用服务器与oracle断掉了，你自己找找为什么会经常断掉吧，tomcat不会重新连接，修改一下tomcat/conf/server.xml文件，
用validationQuery在论坛上搜素，添加一个这个参数看看。

lotus

好的