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
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 |