org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLExcepti

这个怎么解决,有大神没
五月 14, 2019 3:52:49 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:dispatch’ did not find a matching property.
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version: Apache Tomcat/7.0.91
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built: Sep 13 2018 19:52:12 UTC
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number: 7.0.91.0
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name: Windows 8.1
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version: 6.3
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture: amd64
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home: C:\Program Files\Java\jdk1.7.0_80\jre
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version: 1.7.0_80-b15
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor: Oracle Corporation
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE: D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME: D:\Toolkit\tomcat\tomcat-7.0.91
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\Toolkit\tomcat\tomcat-7.0.91
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\Toolkit\tomcat\tomcat-7.0.91\endorsed
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
五月 14, 2019 3:52:49 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.7.0_80\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jdk1.7.0_80/bin/…/jre/bin/server;C:/Program Files/Java/jdk1.7.0_80/bin/…/jre/bin;C:/Program Files/Java/jdk1.7.0_80/bin/…/jre/lib/amd64;F:\app\MSI\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\Intel\Intel® Management Engine Components\iCLS;C:\Program Files\Intel\Intel® Management Engine Components\iCLS;C:\Windows\system32;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Intel\Intel® Management Engine Components\DAL;C:\Program Files\Intel\Intel® Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel® Management Engine Components\IPT;C:\Program Files\Intel\Intel® Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\MySQL\MySQL Server 5.5\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;D:\Toolkit\maven\apache-maven-3.5.4\bin;C:\Program Files\Java\jdk1.7.0_80\bin;C:\ProgramData\chocolatey\bin;F:\Program Files\nodejs;F:\Program Files\TortoiseSVN\bin;F:\Program Files\MacType;;D:\eclipse;;.
五月 14, 2019 3:52:49 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler [“http-bio-8080”]
五月 14, 2019 3:52:49 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler [“ajp-bio-8009”]
五月 14, 2019 3:52:49 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 468 ms
五月 14, 2019 3:52:49 下午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
五月 14, 2019 3:52:49 下午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.91
五月 14, 2019 3:52:50 下午 org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
警告: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [432] milliseconds.
五月 14, 2019 3:52:50 下午 org.apache.catalina.loader.WebappClassLoaderBase validateJarFile
信息: validateJarFile(D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\dispatch\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
五月 14, 2019 3:52:53 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
五月 14, 2019 3:52:53 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
五月 14, 2019 3:52:54 下午 org.apache.catalina.startup.TldConfig execute
信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
log4j:WARN Continuable parsing error 79 and column 52
log4j:WARN 必须声明元素类型 “Console”。
log4j:WARN Continuable parsing error 80 and column 92
log4j:WARN 必须声明元素类型 “PatternLayout”。
log4j:WARN Continuable parsing error 89 and column 13
log4j:WARN 元素类型为 “appender” 的内容必须匹配 “(errorHandler?,param*,layout?,filter*,appender-ref*)”。
log4j:WARN Continuable parsing error 90 and column 30
log4j:WARN 需要属性 “name”, 并且必须为元素类型 “logger” 指定该属性。
log4j:WARN Continuable parsing error 154 and column 23
log4j:WARN 元素类型为 “log4j:configuration” 的内容必须匹配 “(renderer*,appender*,(category|logger),root?,categoryFactory?)"。
log4j:WARN No such property [log4j.appender.A1.Encoding] in org.apache.log4j.PatternLayout.
五月 14, 2019 3:52:54 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
五月 14, 2019 3:52:56 下午 org.apache.catalina.core.ApplicationContext log
信息: Set web app root system property: ‘dispatch.root’ = [D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\dispatch]
五月 14, 2019 3:52:56 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing log4j from [D:\software\application.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\dispatch\WEB-INF\classes\log4j.xml]
log4j:WARN Continuable parsing error 79 and column 52
log4j:WARN 必须声明元素类型 “Console”。
log4j:WARN Continuable parsing error 80 and column 92
log4j:WARN 必须声明元素类型 “PatternLayout”。
log4j:WARN Continuable parsing error 89 and column 13
log4j:WARN 元素类型为 “appender” 的内容必须匹配 "(errorHandler?,param,layout?,filter*,appender-ref*)”。
log4j:WARN Continuable parsing error 90 and column 30
log4j:WARN 需要属性 “name”, 并且必须为元素类型 “logger” 指定该属性。
log4j:WARN Continuable parsing error 154 and column 23
log4j:WARN 元素类型为 “log4j:configuration” 的内容必须匹配 "(renderer*,appender*,(category|logger),root?,categoryFactory?)"。
log4j:WARN No such property [log4j.appender.A1.Encoding] in org.apache.log4j.PatternLayout.
log4j:ERROR Attempted to append to closed appender named [HTTP_FILEOUT].
五月 14, 2019 3:52:56 下午 org.apache.catalina.core.ApplicationContext log
信息: QuartzInitializer: Quartz Initializer Servlet loaded, initializing Scheduler…
五月 14, 2019 3:52:56 下午 org.apache.catalina.core.ApplicationContext log
信息: QuartzInitializer: Scheduler has been started…
五月 14, 2019 3:52:56 下午 org.apache.catalina.core.ApplicationContext log
信息: QuartzInitializer: Storing the Quartz Scheduler Factory in the servlet context at key: org.quartz.impl.StdSchedulerFactory.KEY
五月 14, 2019 3:52:57 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler [“http-bio-8080”]
五月 14, 2019 3:52:57 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler [“ajp-bio-8009”]
五月 14, 2019 3:52:57 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 7224 ms
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in com/longtop/sysnet/dao/ibatis/sqlmap/RuntimeTaskManager_SqlMap.xml.
— The error occurred while executing query.
— Check the select (select count(TASK_ID) from DCS_T_TASK_STATUS where EXEC_STATUS = ‘00’) CUR_TASK_NUM, (SELECT count(b.object_name) LOCKED_FLAG FROM vKaTeX parse error: Double subscript at position 99: …_name IN('DCS_T_̲TASK_STATUS','D…locked_object a, dba_objects b WHERE a.object_id = b.object_id and b.object_name IN(‘DCS_T_TASK_STATUS’,‘DCS_T_TASK_STATUS_BAK’)) LOCKED_FLAG , (SELECT COUNT() FROM DCS_T_TASK_STATUS WHERE EXEC_STATUS NOT IN (‘01’,‘05’)) IS_ALL_SUCCESS_FLAG, MAX_TASK_NUM, TASK_SCAN_INTERVAL, TASK_SEND_INTERVAL, STOP_FLAG, MAX_FAILED_NUM, (select count(TASK_ID) from DCS_T_TASK_STATUS where EXEC_STATUS = ‘06’) CUR_TASK_TO_DEAL, (select nvl(sum(case when dealcount < (case when (select count(tt1.task_id) from dcs_T_Task_status tt1 join Dcs_t_Task_Grp_Relation tt2 on tt1.task_id = tt2.task_id and tt1.exec_status =‘06’ where tt2.grp_id = t.grp_id ) > 0 then grp_task_num else 0 end ) then +1 else 0 end),1) scanflag from (select r.grp_id, count(d.task_id) dealcount, gd.grp_task_num from dcs_T_Task_grp_relation r join dcs_T_grp_def gd on r.grp_id = gd.grp_id left join dcs_T_Task_to_deal d on d.task_id = r.task_id group by r.grp_id, gd.grp_task_num) t ) SCANFLAG from DCS_T_DISPATCH_CTRL where rownum = 1 .
— Check the SQL Statement (preparation failed).
— Cause: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
21.8.129.147:1521:crmdb

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at com.longtop.sysnet.dao.ibatis.ExeSqlDAOImpl.queryForString(ExeSqlDAOImpl.java:124)
at com.longtop.sysnet.service.dispatch.RuntimeTaskManager.getSystemInfo(RuntimeTaskManager.java:40)
at com.longtop.sysnet.service.dispatch.RuntimeTaskManager.refreshTaskQueue(RuntimeTaskManager.java:69)
at com.longtop.sysnet.controler.struts2.dispatch.TaskScanAction.scan(TaskScanAction.java:23)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in com/longtop/sysnet/dao/ibatis/sqlmap/RuntimeTaskManager_SqlMap.xml.
— The error occurred while executing query.
— Check the select (select count(TASK_ID) from DCS_T_TASK_STATUS where EXEC_STATUS = ‘00’) CUR_TASK_NUM, (SELECT count(b.object_name) LOCKED_FLAG FROM v$locked_object a, dba_objects b WHERE a.object_id = b.object_id and b.object_name IN(‘DCS_T_TASK_STATUS’,‘DCS_T_TASK_STATUS_BAK’)) LOCKED_FLAG , (SELECT COUNT(*) FROM DCS_T_TASK_STATUS WHERE EXEC_STATUS NOT IN (‘01’,‘05’)) IS_ALL_SUCCESS_FLAG, MAX_TASK_NUM, TASK_SCAN_INTERVAL, TASK_SEND_INTERVAL, STOP_FLAG, MAX_FAILED_NUM, (select count(TASK_ID) from DCS_T_TASK_STATUS where EXEC_STATUS = ‘06’) CUR_TASK_TO_DEAL, (select nvl(sum(case when dealcount < (case when (select count(tt1.task_id) from dcs_T_Task_status tt1 join Dcs_t_Task_Grp_Relation tt2 on tt1.task_id = tt2.task_id and tt1.exec_status =‘06’ where tt2.grp_id = t.grp_id ) > 0 then grp_task_num else 0 end ) then +1 else 0 end),1) scanflag from (select r.grp_id, count(d.task_id) dealcount, gd.grp_task_num from dcs_T_Task_grp_relation r join dcs_T_grp_def gd on r.grp_id = gd.grp_id left join dcs_T_Task_to_deal d on d.task_id = r.task_id group by r.grp_id, gd.grp_task_num) t ) SCANFLAG from DCS_T_DISPATCH_CTRL where rownum = 1 .
— Check the SQL Statement (preparation failed).
— Cause: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
21.8.129.147:1521:crmdb

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 13 more

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
21.8.129.147:1521:crmdb

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
at com.sun.proxy.$Proxy26.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
... 19 more