org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: //192.98.100.90:1521/cqgasoa ) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) com.crunii.zhongfa.web.filter.HttpWapperFilter.doFilter(HttpWapperFilter.java:37)

root cause

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//192.98.100.90:1521/cqgasoa
)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
	org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:797)
	com.crunii.zhongfa.domain.db.EasyJdbcTemplate.queryForList(EasyJdbcTemplate.java:79)
	com.crunii.zhongfa.service.impl.ZhongFaServiceImpl.getTismColumnMode1(ZhongFaServiceImpl.java:35)
	com.crunii.zhongfa.web.control.ZhongFaControl.Index(ZhongFaControl.java:41)
	sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:100)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:604)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:565)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	com.crunii.zhongfa.web.filter.HttpWapperFilter.doFilter(HttpWapperFilter.java:37)

root cause

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//192.98.100.90:1521/cqgasoa
)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	com.sun.proxy.$Proxy3.getConnection(Unknown Source)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
	org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:797)
	com.crunii.zhongfa.domain.db.EasyJdbcTemplate.queryForList(EasyJdbcTemplate.java:79)
	com.crunii.zhongfa.service.impl.ZhongFaServiceImpl.getTismColumnMode1(ZhongFaServiceImpl.java:35)
	com.crunii.zhongfa.web.control.ZhongFaControl.Index(ZhongFaControl.java:41)
	sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:100)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:604)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:565)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	com.crunii.zhongfa.web.filter.HttpWapperFilter.doFilter(HttpWapperFilter.java:37)

root cause

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//192.98.100.90:1521/cqgasoa

	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
	oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
	oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
	oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
	oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
	org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	com.sun.proxy.$Proxy3.getConnection(Unknown Source)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
	org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:797)
	com.crunii.zhongfa.domain.db.EasyJdbcTemplate.queryForList(EasyJdbcTemplate.java:79)
	com.crunii.zhongfa.service.impl.ZhongFaServiceImpl.getTismColumnMode1(ZhongFaServiceImpl.java:35)
	com.crunii.zhongfa.web.control.ZhongFaControl.Index(ZhongFaControl.java:41)
	sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:100)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:604)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:565)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	com.crunii.zhongfa.web.filter.HttpWapperFilter.doFilter(HttpWapperFilter.java:37)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.45 logs.


Apache Tomcat/6.0.45