Re: Problem with array ... help!

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(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)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

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