False alarm! I made a mistake in a different part of the code, and once
I fixed it, I am not getting the error anymore. Apologies for not
finding this before e-mailing the list, and thanks to everyone for the
good work!
On 08/09/2015 10:08 PM, "Gabriel E. Sánchez Martínez" wrote:
> Hello everyone,
>
> Is there a known bug that makes the postgres JDBC driver treat long
> variables as int variables, in the context of prepared statements?
>
> I am getting the following error:
>
> org.postgresql.util.PSQLException: Bad value for type int : 2759496100
>
> while executing a prepared statement with the following Java code:
>
> StringBuilder sb = new StringBuilder();
> sb.append("SELECT * FROM table ");
> sb.append("WHERE timestamp BETWEEN ? AND ? ");
> sb.append("AND id IN ( ");
> for (int i = 0; i < ids.size() - 1; i++) {
> sb.append("?, ");
> }
> sb.append("? );");
> final String query = sb.toString();
>
> try (Connection c = db.getConnection()) {
> PreparedStatement p = c.prepareStatement(query);
> p.setDate(1, new java.sql.Date(startDate.getTime()));
> p.setDate(2, new java.sql.Date(endDate.getTime()));
>
> for (int i = 0; i < ids.size(); i++) {
> int arg = 3 + i;
> long id = ids.get(i);
> p.setLong(arg, id);
> }
>
> ResultSet r = p.executeQuery();
>
> This code is being executed by tomcat7 on Ubuntu 14.04, and I am using
> the current version of the driver, 9.4-1201. The query executes well
> on pgAdmin in all cases, and in tomcat7 only when all the long ids are
> in the int range.
>
> Help will be greatly appreciated!
>
> Regards,
> Gabriel
>