JSTL
Log4j 쿼리출력오류
근우
2023. 5. 27. 12:49
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'net.sf.log4jdbc.sql.jdbcapi.driverspy'
해결
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"
value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy" />
<property name="url"
value="jdbc:log4jdbc:oracle:thin:@localhost:1521:XE" />
<property name="username" value="system" />
<property name="password" value="k2980935" />
</bean>
root-context.xml
net.sf.log4jdbc.sql.jdbcapi.driverspy > net.sf.log4jdbc.sql.jdbcapi.DriverSpy 로 수정
<dependency>
<groupId>org.bgee.log4jdbc-log4j2</groupId>
<artifactId>log4jdbc-log4j2-jdbc4</artifactId>
<version>1.16</version>
</dependency>
pom.xml 의존성추가