Changeset 38853

Timestamp:

Oct 13, 2015, 11:41:29 AM (11 years ago)

Author:

eugene

Message:

abort on error in executeQuery

File:

• trunk/ippToPsps/jython/mysql.py (modified) (2 diffs)

trunk/ippToPsps/jython/mysql.py

@@ -285 +285 @@
     def createIndex(self, table, column):
 
-        #self.logger.debug("Creating index on column '"+column+"' for table '"+table+"'")
+        self.logger.debug("Creating index on column '"+column+"' for table '"+table+"'")
 
         sql = "CREATE INDEX "+table+"_"+column+"_index ON "+table+" ("+column+")"
-        try:
-            self.execute(sql)
-        except: pass
-            #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
+        self.execute(sql)
 
     def addPrimaryKeyWithIgnore(self, table, column):
@@ -351 +348 @@
   
         stmt = self.con.createStatement()
-        rs = stmt.executeQuery(sql)
-        #stmt.close()
+
+        try: rs = stmt.executeQuery(sql)
+        except Exception, e:
+            print "--- Error in executeQuery: "
+            print "--- sql: " + sql
+            print "--- " + str(e)
+            os._exit(2)
+
+#       stmt.close()
         return rs