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 206396 - Oracle XE db connection causes the IDE to become extremely slow after a while
Summary: Oracle XE db connection causes the IDE to become extremely slow after a while
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.1
Hardware: PC Linux
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords: PERFORMANCE
Depends on:
Blocks:
 
Reported: 2011-12-14 16:15 UTC by paolosca
Modified: 2015-03-22 18:44 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
jstack thread dump (30.62 KB, text/plain)
2011-12-14 16:15 UTC, paolosca 		Details
Snapshot (67.85 KB, application/octet-stream)
2011-12-14 16:16 UTC, paolosca 		Details
Snapshot (198.15 KB, application/octet-stream)
2011-12-14 16:17 UTC, paolosca 		Details
Netbeans messages log (115.35 KB, text/x-log)
2011-12-14 16:26 UTC, paolosca 		Details
netbeans metrics file (317.42 KB, application/octet-stream)
2011-12-14 16:28 UTC, paolosca 		Details
netbeans uigestures file (82.39 KB, application/octet-stream)
2011-12-14 16:31 UTC, paolosca 		Details
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 paolosca 2011-12-14 16:15:22 UTC 
Created attachment 114178 [details]
jstack thread dump

I'm trying to follow the tutorial Creating a Database Driven Application With PHP, Lesson 1b: Creating Oracle Database Tables.

When I connect to the DB after a few queries the IDE starts to become unresponsive for 20-30 seconds per time, this happens especially when I alter the DB structure (i.e. create or alter a trigger).

I attach a thread dump I took while the IDE was unresponsive and two snapshots I took while it was extremely slow.

Thanks,

Paolo
Comment 1 paolosca 2011-12-14 16:16:34 UTC 
Created attachment 114179 [details]
Snapshot
Comment 2 paolosca 2011-12-14 16:17:37 UTC 
Created attachment 114180 [details]
Snapshot
Comment 3 paolosca 2011-12-14 16:26:57 UTC 
Created attachment 114181 [details]
Netbeans messages log
Comment 4 paolosca 2011-12-14 16:28:38 UTC 
Created attachment 114183 [details]
netbeans metrics file
Comment 5 paolosca 2011-12-14 16:31:34 UTC 
Created attachment 114184 [details]
netbeans uigestures file
Comment 6 matthias42 2015-03-22 18:44:09 UTC 
Thank you for your report. There were multiple changes committed to the netbeans codebase, that should address your problem:

1. In current nightlies SQL Type 2009 is mapped
2. SQL Type -101 is tracked in bug 250788
3. Statement handling to retrieve metadata was broken - and resources were not closed, leading to "java.sql.SQLException: ORA-01000: maximum open cursors exceeded". This was fixed some time ago.

Please retest with a current nightly build. If you find your issue fixed, please change the status from FIXED to VERIFIED. Thank you.