Re: Invalid column display size. Cannot be less than zero

From: "Roman Chervotkin" <roman(dot)chervotkin(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Invalid column display size. Cannot be less than zero
Date: 2006-07-25 15:18:17
Message-ID: c1b06e90607250818p39aee483u3a3238ef47bc8a59@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi alan.

I guess you should cast your db table column type from varchar/text to
varchar(n).

Roman.

On 25 Jul 2006 03:42:36 -0700, alan <a(dot)alerta(at)mainfield(dot)com> wrote:
>
> Hi all!
>
> I'm using postgresql-8.1-407.jdbc3.jar.
>
> The following code:
> CachedRowSet cachedRowSet = new CachedRowSetImpl();
> cachedRowSet.populate(resultSet);
>
> raise the following exception:
> 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:702)
> at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java
> :620)
> at com.mainfield.test.TestJoinRowSet.run(TestJoinRowSet.java:47)
> at com.mainfield.test.TestJoinRowSet.main(TestJoinRowSet.java:71)
>
> Last informations available about this issue it's on this mailing list
> one year ago.
> Someone has news about this issue?
>
> Many thanks!
> Regards.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message chris997 2006-07-25 16:15:28 Re: "Ghost" colmumn with primary key
Previous Message Christian Schoenebeck 2006-07-25 14:59:03 Re: CASE statement and SETOF values

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-07-25 16:34:17 Re: Invalid column display size. Cannot be less than zero
Previous Message alan 2006-07-25 12:04:08 Invalid column display size. Cannot be less than zero