Re: BIGINT <-> java.lang.String auto cast

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pg(at)fastcrypt(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: BIGINT <-> java.lang.String auto cast
Date: 2005-05-27 01:04:33
Message-ID: 42967221.20505@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dave Cramer wrote:
> Where do you see the driver doing such conversions.

In AbstractJdbc2Statement.setObject(int,Object,int,int), e.g.:

> // Helper method that extracts numeric values from an arbitary Object.
> private String numericValueOf(Object x)
> {
> if (x instanceof Boolean)
> return ((Boolean)x).booleanValue() ? "1" : "0";
> else if (x instanceof Integer || x instanceof Long ||
> x instanceof Double || x instanceof Short ||
> x instanceof Number || x instanceof Float)
> return x.toString();
> else
> //ensure the value is a valid numeric value to avoid
> //sql injection attacks
> return new BigDecimal(x.toString()).toString();
> }

[...]

> switch (targetSqlType)
> {
> case Types.INTEGER:
> bindLiteral(parameterIndex, numericValueOf(x), Oid.INT4);
> break;

[...]

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-05-27 01:09:42 Re: BIGINT <-> java.lang.String auto cast
Previous Message Dave Cramer 2005-05-27 00:44:30 Re: BIGINT <-> java.lang.String auto cast