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.
We have problems using Netbeans-IDE 7.4 to 'select *' from Oracle DB tables. Everything works fine selecting from small and medium sized DB-tables ( tested up to 500 000 rows), but when we connect to bigger db-tables ( 1 500 000 rows ) the 'select *' never finishes and the memory usage increases steadily until an OutOfMemoryError occures. Things we noticed: - we have no problems connecting and selecting from the Oracle DB using Netbeans 7.3 - the problem seems to exist only with Oracle DB's. For example we have no problems selecting 1 600 000 rows from a Pervasive SQL DB)
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. ***