deleteStmt.addBatch(query_sub);
deleteStmt.addBatch(query_pub);
deleteStmt.executeBatch();
} catch (ClassNotFoundException e){
log.warn("Could not load jdbc driver for database configured in olat_config.xml. Driver: "+ driverClass, e);
throw new StartupException("Could not load jdbc driver for database configured in olat_config.xml. Driver: "+ driverClass, e);
} catch (SQLException e) {
log.warn("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%");
log.warn("%%% Please upgrade your database! %%%");
log.warn("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%");
log.warn("Could not execute system upgrade! Your database does not support the following syntax: 'WHERE experession IN (subquery)'."
+ "First query: "+ query_sub +" Second query: "+ query_pub,
e);
} finally {
try {
deleteStmt.close();
} catch (SQLException e2){
log.warn("Could not close sql delete statement of system upgrade 5.1.0", e2);
throw new StartupException("Could not close sql delete statement of system upgrade 5.1.0", e2);
} finally {
try {
con.close();
} catch (SQLException e3){
log.warn("Could not close db connection.", e3);
throw new StartupException("Could not close db connection.", e3);
}
}
}
cleaned = true;
uhd.setBooleanDataValue(TASK_CLEAN_UP_OF_PUB_AND_SUB_OF_RETURNBOXES_DONE, cleaned);