Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: JVM out of memory when query more than 10,000 records.


Permlink Replies: 1 - Pages: 1 - Last Post: Nov 24, 2011 8:04 AM Last Post By: Roger Bjarevall
chart_gr

Posts: 11
Registered: 11/04/11
JVM out of memory when query more than 10,000 records.
Posted: Nov 24, 2011 3:27 AM
   thread.click_reply Reply
Hi team support,

I have query a much data about 100,000 records or more than. I get error that is JVM out of memory, please help me.
The data concern XML(data type is CLOB) that is a big. (Database is DB2)

Question:
1) Can I change maximum JVM size?
2) If I can, please tell me that where it is.
3) I would like to tell you, please add sequence in Object Types where is in Export Schema Script.

Error information:


**An error occurred while executing the database request for:**
**DB2/AIX64**
**SQL09055**
**IBM DB2 JDBC Universal Driver Architecture**
**3.57.82**

**Short message:**
**An error occurred while performing the operation:**
**Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).**

**The command that caused the problem:**
**select * from "ESBUSR"."TRANSACTION_LOG"**

**Long Message:**
**Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).**

**Details:**
**Type: java.lang.OutOfMemoryError**

***Stack Trace:***
***java.lang.OutOfMemoryError: Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).*** **at com.onseven.dbvis.H.B.K.Ă(Z:356)**
**at se.pureit.swing.A.O$1.run(Z:3429)**
**at java.awt.event.InvocationEvent.dispatch(Unknown Source)**
**at java.awt.EventQueue.dispatchEvent(Unknown Source)**
**at com.onseven.dbvis.L.A.V.dispatchEvent(Z:2143)**
**at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEvents(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEvents(Unknown Source)**
**at java.awt.EventDispatchThread.run(Unknown Source)**

Roger Bjarevall


Posts: 5,088
Registered: 12/17/04
Re: JVM out of memory when query more than 10,000 records.
Posted: Nov 24, 2011 8:04 AM    global.in_response_to.tooltip in response to: chart_gr
   thread.click_reply Reply
Hi,

Please check the FAQ and the following entry how to increase the memory:

http://www.dbvis.com/products/dbvis/doc/faq/#6.3

Regards

Roger

Point your RSS reader here for a feed of the latest messages in all forums