Changeset 32020

Timestamp:

Aug 3, 2011, 4:26:56 PM (15 years ago)

Author:

rhenders

Message:

using exception-handling to check connection is ok; setting everythingOK to False if it fails

File:

• trunk/ippToPsps/jython/mysql.py (modified) (1 diff)

trunk/ippToPsps/jython/mysql.py

@@ -36 +36 @@
         # set up JDBC connection
         self.url = "jdbc:mysql://"+self.dbHost+"/"+self.dbName+"?user="+self.dbUser+"&password="+self.dbPass
-        self.con = DriverManager.getConnection(self.url)
-        self.connectionID = self.getLastConnectionID()
-        self.logger.debug("MySQL connection to %s with ID %d" % (dbType, self.connectionID))
-
-        #self.stmt = self.con.createStatement()
+        try:
+            self.con = DriverManager.getConnection(self.url)
+            self.connectionID = self.getLastConnectionID()
+            self.logger.debug("MySQL connection to %s with ID %d" % (dbType, self.connectionID))
+        except:
+            self.logger.error("Unable to connect to " + self.url)
+            self.everythingOK = False
+            return
+
+        self.everythingOK = True