aboutsummaryrefslogtreecommitdiff
path: root/src/org/traccar/helper/NamedParameterStatement.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/org/traccar/helper/NamedParameterStatement.java')
-rw-r--r--src/org/traccar/helper/NamedParameterStatement.java21
1 files changed, 8 insertions, 13 deletions
diff --git a/src/org/traccar/helper/NamedParameterStatement.java b/src/org/traccar/helper/NamedParameterStatement.java
index bbb2bcdf3..5fbc57d78 100644
--- a/src/org/traccar/helper/NamedParameterStatement.java
+++ b/src/org/traccar/helper/NamedParameterStatement.java
@@ -114,11 +114,8 @@ public class NamedParameterStatement {
return parsedQuery.toString();
}
-
- /**
- * Execute query with result
- */
- public ResultSet executeQuery() throws SQLException {
+
+ public void prepare() throws SQLException {
try {
if (statement == null) {
statement = connection.getInstance().prepareStatement(parsedQuery);
@@ -127,6 +124,12 @@ public class NamedParameterStatement {
connection.reset();
statement = connection.getInstance().prepareStatement(parsedQuery);
}
+ }
+
+ /**
+ * Execute query with result
+ */
+ public ResultSet executeQuery() throws SQLException {
return statement.executeQuery();
}
@@ -135,14 +138,6 @@ public class NamedParameterStatement {
* Executes query without result
*/
public int executeUpdate() throws SQLException {
- try {
- if (statement == null) {
- statement = connection.getInstance().prepareStatement(parsedQuery);
- }
- } catch (SQLException error) {
- connection.reset();
- statement = connection.getInstance().prepareStatement(parsedQuery);
- }
return statement.executeUpdate();
}