Re: AJ1Stmt.setObject() - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: AJ1Stmt.setObject()
Date
Msg-id 406F50E9.9060702@opencloud.com
Whole thread Raw
In response to AJ1Stmt.setObject()  (Brian Olson <bql@bolson.org>)
List pgsql-jdbc
Brian Olson wrote:
> I think AbstractJdbc1Statement.setObject(int,Object) needs to know how
> to handle Java array types.

How do you specify how to interpret the elements of the array? e.g. how
should this be handled? :

  Object[] awkwardArray = new Object[] { new Integer(42), "42", "foo" };
  statement.setObject(1, awkwardArray);

> My problem is that I don't see any other way in jdbc to set array
> elements of rows. So, this must be it, though unimplemented here.

JDBC2's PreparedStatement.setArray() is the standard way: you wrap the
underlying array in an appropriate Array implementation of your own.
This also solves the problem of deciding how to interpret the array
elements: the Array interface allows you to explicitly provide a SQL
type for the elements.

However the CVS driver does not implement setArray usefully for this
case. I have an unapplied patch that was posted to the list some time
ago that implements this (getting quite old now..), which is a bit of a
nasty hack but does the job. See
http://archives.postgresql.org/pgsql-jdbc/2003-07/msg00294.php

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Storing Large Objects: ClassCastException
Next
From: Edoardo Ceccarelli
Date:
Subject: test, don't read