Changeset 6865

Timestamp:

2004-02-24T11:01:01+13:00 (20 years ago)

Author:

kjdon

Message:

put a try-catch around creating and testing the connection to the db

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java (modified) (1 diff)

trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java

@@ -17 +17 @@
 
     public boolean setDatabase(String db_name) {
-    connection = GS3SQLConnectionFactory.createConnection(db_name);
-
-    // test the connection
-    String query = "select * from "+GSSQL.DOCUMENT_TABLE+GSSQL.END;
-    if (!connection.execute(query)) {
-        connection = null;
+    try {
+        connection = GS3SQLConnectionFactory.createConnection(db_name);
+        
+        // test the connection
+        String query = "select * from "+GSSQL.DOCUMENT_TABLE+GSSQL.END;
+        if (!connection.execute(query)) {
+        connection = null;
+        return false;
+        }
+        return true;
+    } catch (Exception e) {
+        System.err.println("SQLQuery.setDatabase Exception");
         return false;
     }
-    return true;
     }