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