This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 210268 - OoME at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.executeSQLStatement
Summary: OoME at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.executeSQL...
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 7.2
Hardware: PC Linux
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-28 12:25 UTC by Petr Cyhelsky
Modified: 2012-03-28 18:51 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Petr Cyhelsky 2012-03-28 12:25:41 UTC 
java.lang.OutOfMemoryError.<init>(OutOfMemoryError.java:48)
	at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1657)
	at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1434)
	at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2936)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:477)
	at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2631)
	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1800)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2221)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:835)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
	at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.executeSQLStatement(SQLExecutionHelper.java:600)
	at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.access$300(SQLExecutionHelper.java:76)
	at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$5.execute(SQLExecutionHelper.java:427)
	at org.netbeans.modules.db.dataview.output.SQLStatementExecutor.run(SQLStatementExecutor.java:111)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1452)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2032)
Comment 1 Petr Cyhelsky 2012-03-28 12:27:57 UTC 
invoked view data on a table -> clicked on the "Last Page" button in sql command tab
Comment 3 matthias42 2012-03-28 18:51:57 UTC 
There is not that much an application can do - I assume you are biten by the performance improvement from mysql - mysql reads the whole resultset into memory. See http://benjchristensen.com/2008/05/27/mysql-jdbc-memory-usage-on-large-resultset/ for more details.

Try to set a sensible default fetch size:

defaultFetchSize=25

See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html for more infos about how to add properties to the jdbc url.

If this fails, please provide the dbschema (show create table) and the row count.