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@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Alexey Slynko
> Sent: Tuesday, March 12, 2002 4:50 AM
> To: pgsql-jdbc@postgresql.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@postgresql.org
>
>
>

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