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.
Product Version: NetBeans IDE Dev (Build 200708160000) Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b06 System: Windows XP version 5.1 running on x86; Cp1251; ru_RU (nb) 1. Connect to DB Oracle 10g (for example: jdbc:oracle:thin:@jbrave-pc1.sfbay.sun.com:1521:ora10g) 2. Create new DB table with NCLOB-column by using an attached sql-script (create_db_table_with_nclob.sql). Pay attention that values of table column "nclob_data" is not NULL. 3. Use popup menu item "View Data" for created DB table "Tempo". Result: - an appeared window "SQL Command" contains data table with NULL values for column "NCLOB_DATA". 4. Use popup menu item "Design Query" for created DB table "Tempo". Use popup menu item "Run Query" in the SQL-Statement pane. Result: - an appeared data table contains empty column "NCLOB_DATA" (column doesn't contain NULL values).
Created attachment 46795 [details] sql-script
> Pay attention that values of table column "nclob_data" is not NULL. Well, the statement select id from TEMPO where nclob_data is null retrieves all three records, so I'm not really sure about this. Moreover, select to_lob(long_data) from tempo where id = 1 fails with an error. If you change the script to really put data in the nclob_data field using e.g. update tempo set nclob_data = 'Data_for_' || to_clob(name) then the query editor displays "[clob of size 19]" as the value of the field. Best for db/visualsqleditor to use the execution logic in db/core.
I think the whole parsing/execution should be redone for Visual SQL Editor by using a similar execution mechanism as used in db/core
Move visualsqleditor subcomponents below visualweb