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.