Fixed: sonarqube issue - Used try-with-resources for the PreparedStatement
diff --git a/app/src/main/java/org/apache/roller/weblogger/business/startup/DatabaseInstaller.java b/app/src/main/java/org/apache/roller/weblogger/business/startup/DatabaseInstaller.java
index 257dde8..d370579 100644
--- a/app/src/main/java/org/apache/roller/weblogger/business/startup/DatabaseInstaller.java
+++ b/app/src/main/java/org/apache/roller/weblogger/business/startup/DatabaseInstaller.java
@@ -910,8 +910,7 @@
private void setDatabaseVersion(Connection con, int version)
throws StartupException {
- try {
- PreparedStatement stmt = con.prepareStatement("insert into roller_properties values(?,?)");
+ try (PreparedStatement stmt = con.prepareStatement("insert into roller_properties values(?,?)")) {
stmt.setString(1, DBVERSION_PROP);
stmt.setString(2, String.valueOf(version));
stmt.executeUpdate();
@@ -929,8 +928,7 @@
private void updateDatabaseVersion(Connection con, int version)
throws StartupException {
- try {
- PreparedStatement stmt = con.prepareStatement("update roller_properties set value = ? where name = ?");
+ try (PreparedStatement stmt = con.prepareStatement("update roller_properties set value = ? where name = ?")) {
stmt.setString(1, String.valueOf(version));
stmt.setString(2, DBVERSION_PROP);
stmt.executeUpdate();
