[cvs] expresso/expresso-web/WEB-INF/src/com/jcorporate/expresso/core/db DBConnection.java

[JCorporate Ltd]

Update of /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/src/com/jcorporate/expresso/core/db
In directory jcorp2.servlets.net:/tmp/cvs-serv3503/expresso-web/WEB-INF/src/com/jcorporate/expresso/core/db

Modified Files:
	DBConnection.java 
Log Message:
improve logging


Index: DBConnection.java
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/src/com/jcorporate/expresso/core/db/DBConnection.java,v
retrieving revision 1.44
retrieving revision 1.45
diff -C2 -d -r1.44 -r1.45
*** DBConnection.java	22 May 2004 01:37:23 -0000	1.44
--- DBConnection.java	16 Jun 2004 08:52:27 -0000	1.45
***************
*** 70,73 ****
--- 70,74 ----
  import com.jcorporate.expresso.core.db.datasource.JndiDataSource;
  import com.jcorporate.expresso.core.misc.StringUtil;
+ import com.jcorporate.expresso.core.dbobj.DBField;
  import com.jcorporate.expresso.kernel.util.ClassLocator;
  import org.apache.log4j.Logger;
***************
*** 179,183 ****
  
      /** What database data type is being used for date/time fields? */
!     private String dateTimeType = "datetime";
  
      /** Don't time out this connection - it may take a while */
--- 180,184 ----
  
      /** What database data type is being used for date/time fields? */
!     private String dateTimeType = DBField.DATETIME_TYPE;
  
      /** Don't time out this connection - it may take a while */
***************
*** 895,898 ****
--- 896,902 ----
                          (endTimer - beginTimer) +
                          " milliseconds");
+                 sqlLog.debug("Time to execute prepared statement was " +
+                         (endTimer - beginTimer) +
+                         " milliseconds");
              }
          } catch (SQLException se) {
***************
*** 997,1002 ****
              }
  
              if (log.isDebugEnabled()) {
-                 long endTimer = System.currentTimeMillis();
                  log.debug("Update '" + strSQL + "' took " +
                          (endTimer - beginTimer) +
--- 1001,1006 ----
              }
  
+             long endTimer = System.currentTimeMillis();
              if (log.isDebugEnabled()) {
                  log.debug("Update '" + strSQL + "' took " +
                          (endTimer - beginTimer) +
***************
*** 1004,1008 ****
              }
              if (sqlLog.isDebugEnabled()) {
!                 sqlLog.debug("Updated:" + lastUpdateCount + " records");
              }
          } catch (SQLException se) {
--- 1008,1013 ----
              }
              if (sqlLog.isDebugEnabled()) {
!                 sqlLog.debug("Updated:" + lastUpdateCount + " records in " +
!                         (endTimer - beginTimer) + " milliseconds");
              }
          } catch (SQLException se) {