Fix timestamp type

Without this cast, setTimestamp would complain that a timestamp is
expected, but a text type is given.

1 files changed, 2 insertions, 2 deletions

diff --git a/src/database/NamedPreparedStatement.java b/src/database/NamedPreparedStatement.java
index 398ef60..089e2c7 100644
--- a/src/database/NamedPreparedStatement.java
+++ b/src/database/NamedPreparedStatement.java
@@ -25,12 +25,12 @@ public class NamedPreparedStatement {
 
     public NamedPreparedStatement(Connection conn, String query) throws SQLException {
         fields = new ArrayList<>();
-        Pattern pattern = Pattern.compile(":(\\w+)");
+        Pattern pattern = Pattern.compile("(?<!:):(\\w+)(::\\w+)?");
         Matcher matcher = pattern.matcher(query);
         while (matcher.find()) {
             fields.add(matcher.group(1));
         }
-        String sql = query.replaceAll(pattern.pattern(), "?");
+        String sql = query.replaceAll(pattern.pattern(), "?$2");
         stmt = conn.prepareStatement(sql);
     }