how to use log4jdbc to log SQL

1. download it from http://code.google.com/p/log4jdbc/

   log4jdbc4-1.2beta2.jar:  for JDBC 4 (JDK 1.6 and 1.7)   Featured  Jun 2010   62.2 KB  4647   
   log4jdbc3-1.2beta2.jar:  for JDBC 3 (JDK 1.4 and 1.5)   Featured  Jun 2010   50.4 KB  2146  

I uses log4jdbc4-1.2beta2.jar donwload it ot desktop.


2. add to your maven server:
http://localhost:8081/nexus/index.html#view-repositories  log in as admin/admin123
click  Repositories on the left menu.
then 3rd party --> then on the bottom right panel click "Artifact Upload":

  GAV Definition: GAV Parameters.
  Group: net.sf.log4jdbc
  Artifact: log4jdbc4
  version: 1.2beta2
  Packaging: jar
Then click "Select Artifacct(s) to Upload... to find the jar file. 
Click "Add Artifact" button
click "Upload Artifact(s)

The artifact is stored in the nexus now. to verify it: click "Brownse Storage" --> Refresh --> net.sf..... you find it.,


3. to use it in your project:

   3.1 add the pom to your pom file:
           <dependency>
               <groupId>net.sf.log4jdbc</groupId>
               <artifactId>log4jdbc4</artifactId>
               <version>1.2beta2</version>
           </dependency>

 
  3.2 suppose that you have setup slf4j log system already.
 
  3.3 Set your JDBC driver class to
  net.sf.log4jdbc.DriverSpy
 
  in your application's configuration
 
 
  3.4 Prepend log4jdbc to the normal jdbc url that you are using.
 
For example, if your normal jdbc url is

      original: jdbc:derby://localhost:1527//db-derby-10.2.2.0-bin/databases/MyDatabase
      new             jdbc:log4jdbc:derby://localhost:1527//db-derby-10.2.2.0-bin/databases/MyDatabase
     
      then You would change it to:
     
      jdbc:log4jdbc:derby://localhost:1527//db-derby-10.2.2.0-bin/databases/MyDatabase
      to use log4jdbc.  
     
   Here is the example:
  
       <bean id="dataSource"
             class="org.apache.commons.dbcp.BasicDataSource"
             destroy-method="close">
           <property name="driverClassName" value="net.sf.log4jdbc.DriverSpy"/>
           <property name="url" value="jdbc:log4jdbc:hsqldb:mem:test"/>
           <property name="username" value="sa"/>
           <property name="password" value=""/>
       </bean>

Original one:

    <bean id="dataSource"
          class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
        <property name="url" value="jdbc:hsqldb:mem:test"/>
        <property name="username" value="sa"/>
        <property name="password" value=""/>
    </bean>



// if you can do it like that, you can wrap it  :


  final Connection conn = ds().getConnection();
   Connection connection = new net.sf.log4jdbc.ConnectionSpy(conn);