Invalid column display size. Cannot be less than zero

Started by alanover 19 years ago7 messagesgeneral

Jump to latest

alan

a.alerta@mainfield.com

over 19 years ago

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.

surabhi.ahuja

surabhi.ahuja@iiitb.ac.in

over 19 years ago

In reply to: alan (#1)

error code when database does not exist

i want to know what error code will be returned if the database does not exist.

i have the following list, howvere do not know which one shall be returned when database itself does not exits

http://www.postgresql.org/docs/8.0/static/errcodes-appendix.html

thanks,
regards
Surabhi

________________________________

From: pgsql-jdbc-owner@postgresql.org on behalf of alan
Sent: Tue 7/25/2006 4:12 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Invalid column display size. Cannot be less than zero

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********

Hi all!

I'm using postgresql-8.1-407.jdbc3.jar.

The following code:
CachedRowSet cachedRowSet = new CachedRowSetImpl();
cachedRowSet.populate(resultSet);

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

alan

a.alerta@mainfield.com

over 19 years ago

In reply to: surabhi.ahuja (#2)

"surabhi.ahuja" ha scritto:

i want to know what error code will be returned if the database does not exist.

i have the following list, howvere do not know which one shall be returned when database itself does not exits

http://www.postgresql.org/docs/8.0/static/errcodes-appendix.html

thanks,
regards
Surabhi

________________________________

From: pgsql-jdbc-owner@postgresql.org on behalf of alan
Sent: Tue 7/25/2006 4:12 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Invalid column display size. Cannot be less than zero

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********

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

------_=_NextPart_001_01C6AFDD.CE284DAA
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Google-AttachSize: 2992

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.69">
<TITLE>[JDBC] Invalid column display size. Cannot be less than zero</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText49442 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV dir=ltr>i want to know what error code will be returned if the database
does not exist.</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>i have the following list, howvere do not know which one shall be
returned when database itself does not exits</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><A
href="http://www.postgresql.org/docs/8.0/static/errcodes-appendix.html">http://www.postgresql.org/docs/8.0/static/errcodes-appendix.html</A></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>thanks,</DIV>
<DIV dir=ltr>regards</DIV>
<DIV dir=ltr>Surabhi<BR></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B>
pgsql-jdbc-owner@postgresql.org on behalf of alan<BR><B>Sent:</B> Tue 7/25/2006
4:12 PM<BR><B>To:</B> pgsql-jdbc@postgresql.org<BR><B>Subject:</B> [JDBC]
Invalid column display size. Cannot be less than zero<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>***********************<BR>Your mail has been scanned by
InterScan VirusWall.<BR>***********-***********<BR><BR><BR>Hi all!<BR><BR>I'm
using postgresql-8.1-407.jdbc3.jar.<BR><BR>The following code:<BR>CachedRowSet
cachedRowSet = new
CachedRowSetImpl();<BR>cachedRowSet.populate(resultSet);<BR><BR>raise the
following exception:<BR>java.sql.SQLException: Invalid column display size.
Cannot be less than<BR>zero<BR>       
at<BR>javax.sql.rowset.RowSetMetaDataImpl.setColumnDisplaySize(RowSetMetaDataImpl.java:267)<BR>       
at<BR>com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:702)<BR>       
at
com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:620)<BR>       
at
com.mainfield.test.TestJoinRowSet.run(TestJoinRowSet.java:47)<BR>       
at com.mainfield.test.TestJoinRowSet.main(TestJoinRowSet.java:71)<BR><BR>Last
informations available about this issue it's on this mailing list<BR>one year
ago.<BR>Someone has news about this issue?<BR><BR>Many
thanks!<BR>Regards.<BR><BR><BR>---------------------------(end of
broadcast)---------------------------<BR>TIP 2: Don't 'kill -9' the
postmaster<BR><BR></FONT></P></DIV>

</BODY>
</HTML>
------_=_NextPart_001_01C6AFDD.CE284DAA--

For "surabhi.ahuja":
Please start a new thread with your question. Thanks.

Back to my problem....
Same problem also with postgresql-8.2dev-503.jdbc3.jar

Thanks.
Regards.

Roman Chervotkin

roman.chervotkin@gmail.com

over 19 years ago

In reply to: alan (#1)

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

Hi alan.

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

Roman.

Show quoted text

On 25 Jul 2006 03:42:36 -0700, alan <a.alerta@mainfield.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

Kris Jurka

books@ejurka.com

over 19 years ago

In reply to: alan (#1)

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

On Tue, 25 Jul 2006, alan wrote:

I'm using postgresql-8.1-407.jdbc3.jar.

java.sql.SQLException: Invalid column display size. Cannot be less than
zero

Someone has news about this issue?

A fix has been put into the 8.2-dev series. Try that jar file.

Kris Jurka

alan

a.alerta@mainfield.com

over 19 years ago

In reply to: Kris Jurka (#5)

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

Kris Jurka ha scritto:

On Tue, 25 Jul 2006, alan wrote:

I'm using postgresql-8.1-407.jdbc3.jar.

java.sql.SQLException: Invalid column display size. Cannot be less than
zero

Someone has news about this issue?

A fix has been put into the 8.2-dev series. Try that jar file.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Kris,
I tried the jar postgresql-8.2dev-503.jdbc3.jar. The exception now is

java.sql.SQLException: Invalid precision value. Cannot be less than
zero
at
javax.sql.rowset.RowSetMetaDataImpl.setPrecision(RowSetMetaDataImpl.java:354)
at
com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:706)
at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:620)
at com.mainfield.norge.test.TestJoinRowSet.run(TestJoinRowSet.java:43)
at
com.mainfield.norge.test.TestJoinRowSet.main(TestJoinRowSet.java:69)

Thanks,
Regards.

Kris Jurka

books@ejurka.com

over 19 years ago

In reply to: alan (#6)

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

On Wed, 25 Jul 2006, alan wrote:

I tried the jar postgresql-8.2dev-503.jdbc3.jar. The exception now is

java.sql.SQLException: Invalid precision value. Cannot be less than
zero
at
javax.sql.rowset.RowSetMetaDataImpl.setPrecision(RowSetMetaDataImpl.java:354)

This thread here kind of trailed off without any resolution. I'm willing
to use precision zero for text types, but I still don't have a good idea
of what to do with unadorned numeric values. Anyone else?

http://archives.postgresql.org/pgsql-jdbc/2006-06/threads.php#00090

Kris Jurka