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 57752 - out of memory on Oracle table explore
Summary: out of memory on Oracle table explore
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 4.x
Hardware: PC Linux
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-11 22:42 UTC by kschenk
Modified: 2006-06-30 18:53 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
log file lines (15.09 KB, text/plain)
2005-04-11 22:43 UTC, kschenk
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kschenk 2005-04-11 22:42:06 UTC
I was attempting to bring up a table listing in the DB explorer on an Oracle DB
 (ojdbc14_g.jar) when I got an "out of memory" error. I increased the max memory
Java option to 192M and still received this.

I currently also use SQuirreL (Java based DB tool) with this same driver and DB
and have not had this problem.
Comment 1 kschenk 2005-04-11 22:43:21 UTC
Created attachment 21557 [details]
log file lines
Comment 2 Petr Jiricka 2005-04-12 15:52:15 UTC
Radko, do you know what may be going on?

Comment 3 Radko Najman 2005-04-13 17:14:04 UTC
I have no idea. From where can I download the mentioned driver? With Oracle type
4 driver everything works fine. I also haven't seen this problem with any other
database or driver.
Comment 4 kschenk 2005-04-13 17:54:52 UTC
This IS a type 4 driver and can be obtained directly from Oracle...from their
JDBC downloads.
Comment 5 Andrei Badea 2005-10-10 14:08:44 UTC
To reporter: are you still able to reproduce the issue? If yes, how big is your
table? Do you fetch all the rows?
Comment 6 Andrei Badea 2005-10-11 09:50:27 UTC
Reporter reply by e-mail:

This was not on an individual table explore but on trying to retrieve all table
names from the SYSADM schema. I am just trying this again...so far I've waited
about 10 minutes, am not getting the 'Out of memory' error but nothing is being
returned. I am still seeing the hour glass icon. :( 
Comment 7 Andrei Badea 2005-10-11 10:06:25 UTC
Could you please post exact steps? For example something like:

1) Connect to a Oracle database using the "jdbc:..." database URL.

2) Expand the Tables node under the connection node.

and so on.

Also if NetBeans hangs or seems to wait for something while retrieving the table
names, please do a full thread dump and attach it to the issue.

I'd also like to ask to use a recent (that is, newer than from Oct 10) daily
build for testing. 
Comment 8 Petr Blaha 2006-03-13 13:32:12 UTC
TM 5.0 -> TBD
Comment 9 Petr Jiricka 2006-06-19 09:54:52 UTC
Removing INCOMPLETE keyword, this is an old issue, please evaluate again.
Comment 10 Andrei Badea 2006-06-30 18:53:57 UTC
No new information from reporter, so closing. Please reopen with more
information, such as a full thread dump in case of a hang or information about
your database (number of tables in the schema you get an OOME for, etc.).