web developer👩🏻‍💻

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory 본문

DB

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

natrue 2020. 11. 17. 17:48
728x90

 톰캣을 실행 시 이런 오류 발생 

org.apache.commons.dbcp.SQLNestedException:

2020-11-17 17:32:32,713 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer 
2020-11-17 17:32:32,719 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] RuntimeException case :: RuntimeException 
2020-11-17 17:32:32,722 ERROR [egovframework.example.sample.service.impl.FileServiceImpl] Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (����������: "플젝명" ������������ ����)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (����������: "플젝명" ������������ ����)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-1.4.jar:1.4]
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:58) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]

 

원인은?

톰캣과 DB연결이 제대로 연동되지 않아서 

 

해결방법?

DB 커낵션, sqlsession등 스프링 내 jdbc 연결을 담당하는 root-context.xml 파일 DB설정 확인