PreparedStatement error for date parameter with overlaps

From: Simon Mitchell <simon(at)jseb(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PreparedStatement error for date parameter with overlaps
Date: 2011-05-30 21:30:28
Message-ID: BANLkTimOyZfaWQw9++4+oSZ=Of=pfkSQ9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

jdbc driver issue for PreparedStatement error for date parameter with
overlaps

// some bad code
sqlText = "SELECT (date ?, date ?) OVERLAPS (date ?, date ?);";
System.out.println("Executing this command: "+sqlText+"\n");
PreparedStatement prs = db.prepareStatement(sqlText);
prs.setString(1,"2001-02-16");
prs.setString(2,"2001-12-21");
prs.setString(3,"2001-10-30");
prs.setString(4,"2002-10-30");
System.out.println("Executing this command: "+ prs.toString() +"\n");

ResultSet results = prs.executeQuery();

// error
***Exception:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
Position: 14

Found a work around, changing the query to include brackets around the
question marks works.
sqlText = "SELECT (date (?), date (?)) OVERLAPS (date (?), date (?))";

Is this a bug?

--
simon

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2011-05-31 01:47:58 Re: PreparedStatement error for date parameter with overlaps
Previous Message Simon Mitchell 2011-05-30 12:39:38 PreparedStatement error for date parameter with overlaps