Re: Problem with array ... help!

> Alexey,
>
> I believe there is has been a patch for this and the development driver
> should solve this problem.

Well, I solve this problem. I've patched the latest development version of
JDBC. There is a patch:

*** src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java.orig
Tue Mar 12 14:49:59 2002
--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Tue Mar 12
14:50:22 2002
***************
*** 767,772 ****
--- 767,774 ----
case Types.BINARY:
case Types.VARBINARY:
return getBytes(columnIndex);
+ case Types.ARRAY:
+ return getArray(columnIndex);
default:
String type = field.getPGType();
// if the backend doesn't know the type
then coerce to String

>
>
> Dave
> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Alexey Slynko
> Sent: Tuesday, March 12, 2002 4:50 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] Problem with array ... help!
>
>
> I have a table with column type int[], for example:
> CREATE TABLE test (
> id int[],
> description text
> );
>
> When I try to get some data from this table (i.e. SELECT * FROM test),
> JDBC create an exception: "Class names may not have _ in them. You
> supplied {0}." What does it mean ? Can anyone post example for working
> with arrays in JDBC ? Please, help...
>
> Thanks,
>
> Alexey Slynko
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>

Alexey Slynko
Stack Technology
E-mail: slynko(at)stack(dot)net
Tel.: +7(095)939-85-86 (130)