From 05ae05165aae38047b56000ce3bf1d2f1d785621 Mon Sep 17 00:00:00 2001
From: Peter Wu <peter@lekensteyn.nl>
Date: Sat, 10 May 2014 19:16:19 +0200
Subject: Fix timestamp type

Without this cast, setTimestamp would complain that a timestamp is
expected, but a text type is given.
---
 src/database/NamedPreparedStatement.java | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/database/NamedPreparedStatement.java')

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);
     }
 
-- 
cgit v1.2.1