Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-jdbc by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group