[SPRING] log4sql을 이용한 쿼리 로그 출력

1.라이브러리를 다운받는다.

https://sourceforge.net/projects/log4sql/files/ <== 라이브러리 다운

2.프로젝트에 라이브러리를 추가한다. 

경로를 WEB-INF아래 lib 폴더를 추가하여 log4sql.jar를 복사한다음

프로젝트 우클릭 -> Properties -> Java Build Path 에서 라이브러리 추가

3.사용자의 데이터베이스에 맞는 드라이버를 찾아 적용한다.

http://log4sql.sourceforge.net/  에 접속한 후 Usage에 들어가 확인

※디비 종류에 따른 log4sql을 적용하기 위한 드라이버 클래스

JDBC TYPE	Origin Your Driver Class	->	log4sql Driver Class
[ORACLE DRIVER CLASS]	oracle.jdbc.drirver.OracleDriver	->	core.log.jdbc.driver.OracleDriver
[MYSQL DRIVER CLASS]	com.mysql.jdbc.Driver' or'org.gjt.mm.mysql.Driver	->	core.log.jdbc.driver.MysqlDriver
[SYBASE DRIVER CLASS]	com.sybase.jdbc2.jdbc.SybDriver	->	core.log.jdbc.driver.SybaseDriver
[DB2 DRIVER CLASS]	com.ibm.db2.jcc.DB2Driver	->	core.log.jdbc.driver.DB2Driver
[INFOMIX DRIVER CLASS]	com.informix.jdbc.IfxDriver	->	core.log.jdbc.driver.InfomixDriver
[POSTGRESQL DRIVER CLASS]	org.postgresql.Driver	->	core.log.jdbc.driver.PostgresqlDriver
[MAXDB DRIVER CLASS]	com.sap.dbtech.jdbc.DriverSapDB	->	core.log.jdbc.driver.MaxDBDriver
[FRONTBASE DRIVER CLASS]	com.frontbase.jdbc.FBJDriver	->	core.log.jdbc.driver.FrontBaseDriver
[HSQL DRIVER CLASS]	org.hsqldb.jdbcDriver	->	core.log.jdbc.driver.HSQLDriver
[POINTBASE DRIVER CLASS]	com.pointbase.jdbc.jdbcUniversalDriver	->	core.log.jdbc.driver.PointBaseDriver
[MIMER DRIVER CLASS]	com.mimer.jdbc.Driver	->	core.log.jdbc.driver.MimerDriver
[PERVASIVE DRIVER CLASS]	com.pervasive.jdbc.v2.Driver	->	core.log.jdbc.driver.PervasiveDriver
[DAFFODILDB DRIVER CLASS]	in.co.daffodil.db.jdbc.DaffodilDBDriver	->	core.log.jdbc.driver.DaffodiLDBDriver
[JDATASTORE DRIVER CLASS]	com.borland.datastore.jdbc.DataStoreDriver	->	core.log.jdbc.driver.JdataStoreDriver
[CACHE DRIVER CLASS]	com.intersys.jdbc.CacheDriver	->	core.log.jdbc.driver.CacheDriver
[DERBY DRIVER CLASS]	org.apache.derby.jdbc.ClientDriver	->	core.log.jdbc.driver.DerbyDriver
[ALTIBASE DRIVER CLASS]	Altibase.jdbc.driver.AltibaseDriver	->	core.log.jdbc.driver.AltibaseDriver
[MCKOI DRIVER CLASS]	com.mckoi.JDBCDriver	->	core.log.jdbc.driver.MckoiDriver
[JSQL DRIVER CLASS]	com.jnetdirect.jsql.JSQLDriver	->	core.log.jdbc.driver.JsqlDriver
[JTURBO DRIVER CLASS]	com.newatlanta.jturbo.driver.Driver	->	core.log.jdbc.driver.JturboDriver
[JTDS DRIVER CLASS]	net.sourceforge.jtds.jdbc.Driver	->	core.log.jdbc.driver.JTdsDriver
[INTERCLIENT DRIVER CLASS]	interbase.interclient.Driver	->	core.log.jdbc.driver.InterClientDriver
[PURE JAVA DRIVER CLASS]	org.firebirdsql.jdbc.FBDriver	->	core.log.jdbc.driver.PureJavaDriver
[JDBC-ODBC DRIVER CLASS]	sun.jdbc.odbc.JdbcOdbcDriver	->	core.log.jdbc.driver.JdbcOdbcDriver
[MSSQL 2000 DRIVER CLASS]	com.microsoft.jdbc.sqlserver.SQLServerDriver	->	core.log.jdbc.driver.MssqlDriver
[MSSQL 2005 DRIVER CLASS]	com.microsoft.sqlserver.jdbc.SQLServerDriver	->	core.log.jdbc.driver.Mssql2005Driver
[CUBRID DRIVER CLASS]	cubrid.jdbc.driver.CUBRIDDriver	->	core.log.jdbc.driver.CUBRIDDriver

나는 MySQL을 사용했으므로 설정을 아래와 같이 바꿔준다.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

        <property name="driverClassName" value="core.log.jdbc.driver.MysqlDriver"></property>

        <property name="url" value="jdbc:mysql://localhost:3306/디비명"></property>

        <property name="username" value="아이디"></property>

        <property name="password" value="비번"></property>

</bean>