Bug report (with solution) on org.postgresql.jdbc2.EscapedFunctions

From: "Christophe Janton" <christophe(dot)janton(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Bug report (with solution) on org.postgresql.jdbc2.EscapedFunctions
Date: 2008-11-05 14:59:05
Message-ID: 70cc7f800811050659w2d606775p1e476dd98232ed58@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

There is a bug on :

org.postgresql.jdbc2.EscapedFunctions.constantToInterval method.

Value parameter have not to contain an integer. For example : ? a prepared
statment JDBC parameter

each return of constantToInterval method like :
*return "'"+value+" day'";*
must be replaced by :
*return "CAST(" + value + " || ' day' as interval)";*

This modification required to remove the interval keyword of all method
using constantToInterval.

Sorry for my English.

Have a nice day.

Christophe JANTON

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gopalakrishnan, Mythili 2008-11-06 21:42:13 DatabaseMetaData.getTypeInfo()
Previous Message Alexander Panzhin 2008-11-04 22:42:23 Re: Retrieve auto-generated key.