Changeset 16258 for greenstone3

Timestamp:

2008-07-01T15:39:13+12:00 (16 years ago)

Author:

xiao

Message:

 

File:

• greenstone3/trunk/src/java/org/greenstone/gsdl3/sql/derby/DerbyDBWrapper.java (modified) (3 diffs)

greenstone3/trunk/src/java/org/greenstone/gsdl3/sql/derby/DerbyDBWrapper.java

@@ -39 +39 @@
         String key = (String)ite.next();
         Object value = arow.get(key);
-        logger.info(key + "=>" +value);
+        //logger.info(key + "=>" +value);
         if (value == null || value.equals("")) continue;
         info.addInfo(key.toLowerCase(),sqlState.undoDBSafe(value));
@@ -58 +58 @@
     public boolean openConnection(String databasepath){
     connection = sqlServer.connect(databasepath);
+    
     if (connection == null) return false;
 
     try{
+        connection.setAutoCommit(false);    
         statement = connection.createStatement();
     }
@@ -73 +75 @@
     public ArrayList executeQuery(String query_statement){
     //the database hasn't been correct yet
-    if (statement == null){
-        logger.info("the database hasn't been correct yet");
-        return new ArrayList();
-    }
+    try{    
+        
+        if (statement == null){
+            logger.info("the database hasn't been correct yet");
+            return new ArrayList();
+        }
     
-    ArrayList results = new ArrayList();
+        ArrayList results = new ArrayList();
 
-    try{
-       ResultSet rs = statement.executeQuery(query_statement);
-       ResultSetMetaData rsmd = rs.getMetaData();
-       int numOfColumns = rsmd.getColumnCount();
-       while(rs.next()){
+    
+        ResultSet rs = statement.executeQuery(query_statement);
+        ResultSetMetaData rsmd = rs.getMetaData();
+        int numOfColumns = rsmd.getColumnCount();
+        while(rs.next()){
            HashMap arow = new HashMap();
            for(int i = 1; i <= numOfColumns ; i++){