Messages posted by: gnaryak

I've been continuing to work with this database and seem to have isolated the OutOfMemoryError problem a little more. Contrary to my prior suspicions, I don't think it has anything to do with functions. Rather, I think it is TEXT columns. Consider: CREATE TABLE foo ( id INTEGER, description TEXT );

Running
SELECT * FROM foo;
from jisql causes the OutOfMemoryError, even if there are no rows in the table.

Thanks for your quick reply. I appreciate your help. I did not get a stack trace from the error. There are 0 rows in the result set.

Thanks,
Andrew

I am running jisql on Linux and connecting to MS SQL Server. I run it with the following command:
$JAVA_HOME/bin/java -classpath ../javalib/database/jisql.jar:../javalib/database/jtds-1.2.jar com.xigole.util.sql.Jisql -driver net.sourceforge.jtds.jdbc.Driver

For the most part, jisql is working great. (Thanks!) I have encountered a problem, however. I wrote a function that separately queries several database tables, then aggregates the results and returns them. I can invoke the function without any problems from SQL Explorer running in Eclipse. I run it as:
select * from healthCheck()

When I run the same function from jisql, I get the following error:
Exception in thread "main" java.lang.OutOfMemoryError: Requested array size exceeds VM limit

I tried adding -Xms64M -Xmx512M parameters to the command that opens jisql but that didn't change anything. When I was trying to run this, there were 0 rows returned by healthCheck() so it does not seem to be caused by the size of the result set.

Thanks in advance for any help you may be able to provide!
-Andrew Guldman