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.
I just tested the result of 230515 and it worked well apart from tables containing CLOB/BLOBs (wouldn't it be nice if the DBMS would support these things just completely ...). Informix does not support scrollable cursors in combination with LOBs. So the driver needs to be completly blacklisted for scrollable cursors. Please add the relevant part into updateScrollableSupport in line 945 (the end of the if statement : else if (driverName != null && driverName.startsWith("com.informix.jdbc.IfxDriver")) { // Informix failes scrollable result sets if blob columns are part of // the resultset -> disable ... resultSetScrollType = ResultSet.TYPE_FORWARD_ONLY; return; } I would like to see a better way to fix this, but apart from manually blacklisting the drivers I don't see a real option.
(In reply to comment #0) > I just tested the result of 230515 and it worked well apart from tables > containing CLOB/BLOBs. Thank you. > (wouldn't it be nice if the DBMS would support these > things just completely ...). Yes, the world would be much better :-) http://hg.netbeans.org/core-main/rev/54e7c326d93d Fixed. > I would like to see a better way to fix this, but apart from manually > blacklisting the drivers I don't see a real option. I don't see any other solution as well. I'm also considering introducing a system property in which users could somehow modify the blacklist (if they have some non-standard database, or some other situation where scrollable cursors do not work appear). Thank you for you help, Matthias.
Integrated into 'main-golden', will be available in build *201306050626* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/54e7c326d93d User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #230626: Blacklist informix for scrollable cursors Patch by Matthias42.