Re: JBoss w/int8 primary keys in postgres ... - Mailing list pgsql-jdbc

From Rod Taylor
Subject Re: JBoss w/int8 primary keys in postgres ...
Date
Msg-id 1063114720.67981.9.camel@jester
Whole thread Raw
In response to Re: JBoss w/int8 primary keys in postgres ...  (Paul Thomas <paul@tmsl.demon.co.uk>)
Responses Re: JBoss w/int8 primary keys in postgres ...
List pgsql-jdbc
> With the proposed modifications to the JDBC driver enabled
>
> PreparedStatement pstmt = con.prepareStatement("select name from test
> where id = ?");
> pstmt.setLong(1, 42);
> pstmt.executeQuery();
>
> would actually produce:
>
> select name from test where id = 42::int8

Silly question, but why don't you simply ensure any ?'s are quoted?

select name from test where id = '42'

This allows PostgreSQL to choose the best type for the job -- in this
case it will try to match that of id.  It will work that way on all
older and newer versions of PostgreSQL.

Attachment

pgsql-jdbc by date:

Previous
From: Paul Thomas
Date:
Subject: Re: JBoss w/int8 primary keys in postgres ...
Next
From: João Ribeiro
Date:
Subject: Re: JBoss w/int8 primary keys in postgres ...