HTTP Status 500 - Could not get JDBC Connection; nested exception is java.sql.SQLRecoverableException: Listener refused the connection with the following error:


type Exception report

message Could not get JDBC Connection; nested exception is java.sql.SQLRecoverableException: Listener refused the connection with the following error:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
	org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
	edu.utah.oit.business.UnidExclusionManager.isExcludedUnid(UnidExclusionManager.java:39)
	edu.utah.oit.business.PersonManager.profilePerson(PersonManager.java:85)
	edu.utah.uit.web.interceptor.SlashFilter.doFilter(SlashFilter.java:98)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

root cause

java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
	oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
	oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
	oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
	org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
	org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:760)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:619)
	org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
	org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
	org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
	edu.utah.oit.business.UnidExclusionManager.isExcludedUnid(UnidExclusionManager.java:39)
	edu.utah.oit.business.PersonManager.profilePerson(PersonManager.java:85)
	edu.utah.uit.web.interceptor.SlashFilter.doFilter(SlashFilter.java:98)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

root cause

oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
	oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:275)
	oracle.net.ns.NSProtocol.connect(NSProtocol.java:264)
	oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452)
	oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)
	oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
	oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
	org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
	org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:760)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:619)
	org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
	org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
	org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
	edu.utah.oit.business.UnidExclusionManager.isExcludedUnid(UnidExclusionManager.java:39)
	edu.utah.oit.business.PersonManager.profilePerson(PersonManager.java:85)
	edu.utah.uit.web.interceptor.SlashFilter.doFilter(SlashFilter.java:98)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

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


Apache Tomcat/7.0.57