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.
Using netbeans 6.8 and 6.9 on ubuntu 10.04 and 10.10. The mySQL server is up and running. The connection to the databases seems OK: the 'Services' windows shows a tree with: - Databases -- MySQL Server at localhost:3306 [root] ---- (list of the databases here) -- jdbc:mysql://localhost:3306/test [root on Default schema] // test is the database i'm connecting to ---- (list of the databases here, with triangular buttons to open the tables/fields/...) If I clic on View Data.. in the context menu, I got a 'SQL Command n' tab in the editor pane with the generated select * statement, and in the output pane a 'SQL Command n execution' tab with something like: Executed successfully in 0,001 s. Line 1, column 1 Execution finished after 0,001 s, 0 error(s) occured. But no window for the supposed returned data... I can try other SQL command like 'Create table': all commands are working fine, the databases are correctly affected, but I never see the data view window. I saw the same problem reported in the forum. TIA
I guess the Data View can be covered by other components, probably by Output window. Could you attach screenshot of whole IDE window after executing View Data action? Thanks
Created attachment 103944 [details] screenshot after clicking 'View Data…' The screenshot you wanted. The output view is not showing after clicking 'View Data…', I opened it by clicking the 'Sortie' (output in french) button. No hidden window, as far as I can figure it out.
It's a known problem, reported occasionally. Caused a sliding window (usually Output window in this case) which overlaps editor window where are results of SQL command. It's need to focus editor (it slides down the output window) then View Data (SQL results) will be shown. It's a UI architecture decision and it's not planed to change this time, it will be consider during planning phase for next release.
when I right-clic a table and run the "View data..." command, I can see either the output window and the editor window. In the editor window I got: select * from theTable I investigate a bit more and I found the View -> IDE Log menuitem that shaow this message: SEVERE [global] java.lang.NoSuchFieldError: TO_STRING at org.netbeans.modules.db.dataview.table.ResultSetCellRenderer.<init>(ResultSetCellRenderer.java:93) at org.netbeans.modules.db.dataview.table.ResultSetJXTable.setDefaultCellRenderers(ResultSetJXTable.java:138) at org.netbeans.modules.db.dataview.table.ResultSetJXTable.<init>(ResultSetJXTable.java:107) at org.netbeans.modules.db.dataview.output.DataViewTableUI.<init>(DataViewTableUI.java:92) at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:73) at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:165) at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:129) at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88) at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:373) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:226) at java.awt.EventQueue.dispatchEvent(EventQueue.java:602) at org.netbeans.core.TimableEventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177) [catch] at java.awt.EventDispatchThread.run(EventDispatchThread.java:138) So I'm thinking that there is simply no Dataview to display! Now this is another problem!
It makes this more clear, it was reported before too. I'll investigate what's wrong. Thanks
*** Bug 192916 has been marked as a duplicate of this bug. ***
*** Bug 185861 has been marked as a duplicate of this bug. ***
fixed by changeset core-main/rev/e7763f864004 Antoine, please verify the fix in upcoming build which will be announced later here. Thank you
I'll do that. Thank you too!
Integrated into 'main-golden', will be available in build *201102050000* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/e7763f864004 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #191325: java.lang.NoSuchFieldError: TO_STRING at org.netbeans.modules.db.dataview.table.ResultSetCellRenderer.<init>(ResultSetCellRenderer.java:93)
I have successfully tested on ubuntu 10.04. Thank you very much!
Thanks all - I was very puzzled by this and searched very hard until I found the error and hence this bug. Thought I was going mad! Two questions: a) Is there any workaround? b) When can we get it into the released Ubuntu package which is presently at version 6.9-0ubuntu2? I am adding these keywords so that anyone searching might find it easier: SQL EDITOR RESULTS DATA TAB PANE MISSING EMPTY Charles Whittington
(In reply to comment #12) > b) When can we get it into the released Ubuntu package which is presently at > version 6.9-0ubuntu2? Hi Charles, we do not plan to release any additional patch for NB 6.9/.1 . Next version of NetBeans (7.0) is going to be released in April this year. In case you would like to work with version that contains the fix, please download NB 7.0 Beta 2 http://netbeans.org/community/releases/70/ . Thanks for understanding.
OK - Thanks. I will probably wait for the released version unless I come across another problem (I like to stick to the released Ubuntu packages - everything seems more stable that way). I can find a work-round with another product. Thanks all. Charles
I finally got the cause of such problems. The netbeans from ubuntu(eg. 10.10 in my case) distrubution uses SwingX library different than SwingX library which comes from original NetBeans distrubution in netbeans.org. The ubuntu-repo snapshot of SwingX doesn't contain some classes however they are linked from db.dataview module. In the end, db.dataview cannot be build using ubuntu-repo SwingX library. The only workaround what I see now it's reinstall NetBeans from netbeans.org. I'll contact NetBeans installer team to fix it in ubuntu-repo side if possible. I let you know here if something new in this matter.
Thanks so much Jiri, brilliant forensics, much appreciated. Charles Whittington