按钮是不可用状态,ping项目,提示:
to Test Connection;
Test connection failed;
Cannot build directory item for key '[税务项目_ntss_db@jdbc:mercuryracle://192.168.1.193:1521;sid=irpteng(税务项目_ntss_db)]' in TD Tables Struct Dir;
[Mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
;
Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.mercury.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.executeQuery(CTdPreparedStatement.java:510)
at com.mercury.optane.core.sequence.CSequenceManager.getMultipleCurrentSequenceValues(CSequenceManager.java:257)
wrapped in com.mercury.optane.core.sequence.CSequencesException:
at com.mercury.optane.core.sequence.CSequenceManager.getMultipleCurrentSequenceValues(CSequenceManager.java:283)
at com.mercury.optane.core.sequence.CSequenceManager.getCurrentSequenceValue(CSequenceManager.java:227)
at com.mercury.td.CTdDatabaseFieldsInfo.obtainInfo(CTdDatabaseFieldsInfo.java:83)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:77)
at com.mercury.td.CTdDatabaseFieldsInfo.<init>(CTdDatabaseFieldsInfo.java:58)
at com.mercury.td.CTdTablesStructDirectory.createDirectoryItem(CTdTablesStructDirectory.java:167)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:81)
wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[税务项目_ntss_db@jdbc:mercuryracle://192.168.1.193:1521;sid=irpteng(税务项目_ntss_db)]' in TD Tables Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:87)
at com.mercury.td.CTdTablesStructDirectory.getDirectoryItem(CTdTablesStructDirectory.java:151)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:101)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1311)
at com.mercury.td.saserver.api.logics.CAdminLogic.testConnection(CAdminLogic.java:610)
wrapped in com.mercury.optane.core.CTdException: Test connection failed
at com.mercury.td.saserver.api.logics.CAdminLogic.testConnection(CAdminLogic.java:624)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectTestConnection(CTdSiteAdminServlet.java:724)
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:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
wrapped in com.mercury.optane.core.CTdException: Failed to Test Connection
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
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:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)作者: FLY000 时间: 2009-3-23 12:13
还有的是,PING也是成功的,但就是激活或删除的按钮状态是不可用作者: bill_hen 时间: 2009-4-24 01:50
懂不懂这句话的意思啊:
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist