Re: SQLException: Cannot be less than zero

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: xavier(dot)marquis(at)cegetel(dot)net
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: SQLException: Cannot be less than zero
Date: 2005-07-12 22:01:41
Message-ID: 42D43DC5.9090803@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


This is completely the wrong list to ask this question - you need to ask
on the lists at

http://jdbc.postgresql.org/lists.html

cheers

andrew

xavier(dot)marquis(at)cegetel(dot)net wrote:

> Hi,
>
> I use PostgreSQL 8.0.3 and following associated drivers :
>
> postgresql-8.0-311.jdbc2.jar
> postgresql-8.0-311.jdbc2ee.jar
> postgresql-8.0-311.jdbc3.jar
>
> I want to use CachedRowSetImpl to populate one row in the following
> table :
>
> CREATE TABLE "Form2"
> (
> form2member3 int4,
> form2member5 int8[],
> )
> WITHOUT OIDS;
> The second column (an array of bigint) seems to cause the following
> exception when try to populate :
>
> java.sql.SQLException: Invalid column display size. Cannot be less
> than zero
> at
> javax.sql.rowset.RowSetMetaDataImpl.setColumnDisplaySize(RowSetMetaDataImpl.java:267)
> at com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:679)
> at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:597)
> at
> com.sun.rowset.internal.CachedRowSetReader.readData(CachedRowSetReader.java:170)
> at com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:736)
> at ...
> at MainTester.main(MainTester.java:41)
>
>
> After reading the only few related subjects, I can't find any
> solution that I be able to use.
> (*Nebojsa Vasiljevic *made a patch but didn't say how to do it ...)
>
> Has someone yet met and solved this unexpected problem (even momently) ?
> Otherwise, Is there another way to deal with variable-length lists ?
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Denis Lussier 2005-07-12 22:07:47 Re: dbt2 & opteron performance
Previous Message Joshua D. Drake 2005-07-12 21:56:08 Re: Vacuum summary?

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-07-12 22:41:53 Re: PL/Perl list value return causes segfault
Previous Message xavier.marquis 2005-07-12 21:52:09 SQLException: Cannot be less than zero ( BUG ? )