Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
on Linux Fedora 2.
I use a Statement object and do the following query:
String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name
+"\') and term_type=\'"+ ontology +"\' LIMIT 20";
table term has 6 columns.
MySql connect/J use 700mB to retrieve hundreds of rows when it should retrieve
only 20. Actually it crashes with:
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap
space
Exception on Toolkit thread: java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
Is LIMIT supported with the JDBC driver?
thank you everygody
Laurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
