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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?



Selecting a constant string or concatenated columns from postgres
using jisql (xigole), I get heap overflow.

select 'X' AS XXX from . . . .
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
        at java.lang.AbstractStringBuilder.<init>
(AbstractStringBuilder.java:45)
        at java.lang.StringBuffer.<init>(StringBuffer.java:91)
        at com.xigole.util.sql.Jisql.formatLabel(Jisql.java:720)
        at com.xigole.util.sql.Jisql.doIsql(Jisql.java:352)
        at com.xigole.util.sql.Jisql.run(Jisql.java:225)
        at com.xigole.util.sql.Jisql.main(Jisql.java:207)
        0

This discussion seems to say this is a postgres JDBC bug:

 http://forums.hotjoe.com/posts/list/315.page

I tried going back to the last rev 7 JAR, and these queries work,
albeit with 65K column widths.  Something is seriously wrong in this
method, if it cannot size a three byte label or a one byte constant
string.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group