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.
Summary: | OutOfMemory-Error when connection to big Oracle DB tables | ||
---|---|---|---|
Product: | db | Reporter: | Teccc |
Component: | Show Data | Assignee: | matthias42 |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | exceptions_reporter, javacavaj, leandroperini, mesbahum |
Priority: | P3 | Keywords: | PATCH_AVAILABLE |
Version: | 7.4 | ||
Hardware: | PC | ||
OS: | Linux | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
Teccc
2013-12-18 12:41:06 UTC
Please open the connections properties and uncheck the option "Use scrollable cursors". Make sure you disconnect and connect again. This should restore the behaviour of netbeans 7.3. Till I read this bug report I was under the assumption, that oracle would offer more features, but according to this: http://docs.oracle.com/cd/E11882_01/java.112/e16548/resltset.htm#JJDBC28612 Oracle does not support scrollable cursors - and the emulation in the jdbc driver nukes your memory.... Thanks! That solved my problem. *** Bug 240155 has been marked as a duplicate of this bug. *** *** Bug 242980 has been marked as a duplicate of this bug. *** Disable scrollable cursors per default on oracle: # This patch file was generated by NetBeans IDE # It uses platform neutral UTF-8 encoding and \n newlines. --- Base (BASE) +++ Locally Modified (Based On LOCAL) @@ -1377,7 +1377,6 @@ return drv != null && (drv.startsWith("org.apache.derby") //NOI18N || drv.startsWith("com.mysql") //NOI18N - || drv.startsWith("oracle") //NOI18N || drv.startsWith("org.postgresql")); //NOI18N } Ah - to fast: The relevant file is "DatabaseConnection.java" in db module. *** Bug 249579 has been marked as a duplicate of this bug. *** I committed the patch, that removes oracle from the list of drivers that enable scrollable cursors by default. This has only impact on newly created connections though. http://hg.netbeans.org/core-main/rev/0b75c5854b99 In the next few days a nightly build will be available (a message will attached to this bug when that happens), that contains this fix. Please take a look at that and verify, that newly created connections for oracle databases are created without "scrollable cursors". Thank you! Integrated into 'main-silver', will be available in build *201502010002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-silver/rev/0b75c5854b99 User: Matthias Blaesing <matthias42@netbeans.org> Log: #239611: Don't enable scrollable cursors on oracle by default (scroll support is emulated client side and tends to blow the heap) *** Bug 246604 has been marked as a duplicate of this bug. *** |