Re: JDBC

Michael,

I am not sure why you are using addDataType(). You should be able to
just use getArray() and setArray() with the 7.2 driver.

thanks,
--Barry

Michael Welter wrote:
> I'm trying to use JDBC to extract data from a ResultSet. Everything
> works fine except for columns defined as arrays. The JDBC array type
> names are preceded by a "_" (_text, _float8, _date, _timestampz, etc.)
>
> The exception I get is "Class names may not have _ in them. You supplied
> {0}". This is with conn.addDataType( "_text","org.postgres.PGobject" );
>
> I'm using Postgres 7.2. I wasn't able to compile with j2sdk1.4 so I had
> to drop back to jdk1.3.
>
> Does pg JDBC come with data handlers for arrays? Is anyone else using
> arrays with JDBC?
>
> Thanks for your help.
> Mike
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>