### 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 의존성추가

+ Recent posts