Re: PreparedStatement error for date parameter with overlaps

On Mon, May 30, 2011 at 8:39 AM, Simon Mitchell <simon(at)jseb(dot)com> wrote:
>     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
>

Doesn't look like a bug. I don't think you can write that SQL in psql.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca