Re: Problem with array ... help! - Mailing list pgsql-jdbc

Someone has applied this patch to CVS.  Thanks.

---------------------------------------------------------------------------

Alexey Slynko wrote:
>
> > 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)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026