| View previous topic :: View next topic |
| Author |
Message |
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
 Posted: Fri Apr 30, 2010 3:40 am Post subject: SQL result table doesn't show up |
 |
|
Hi there,
I registered a derby db under database services. When I want to run a query to see the content of a table, no results are shown. Even no result table is there. Instead the following error pops up:
| Quote: | 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:8
[catch] at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:373)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at org.netbeans.core.TimableEventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
|
It looks to me that it is a netbeans issue.
Help is much appreciated,
Ralf |
|
| Back to top |
|
 |
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
| Posted: Thu May 06, 2010 7:48 am Post subject: |
|
|
Is there no one else faced with that problem. I tried it on two different computers. One with an update to ubuntu 10.04 and one with a complete 10.04 installed from scratch.
| Quote: | $ java -version
java version "1.6.0_18"
OpenJDK Runtime Environment (IcedTea6 1.8) (6b18-1.8-0ubuntu1)
OpenJDK Server VM (build 14.0-b16, mixed mode) |
| Quote: | | Apache Derby Network Server - 10.3.2.1 |
I'm happy to share more information about it with you.
Thanks,
Ralf |
|
| Back to top |
|
|
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
| Posted: Mon May 10, 2010 3:51 am Post subject: |
|
|
| move up ... |
|
| Back to top |
|
|
daniel311
Joined: 06 Dec 2009
Posts: 4
|
| Posted: Mon May 10, 2010 9:34 am Post subject: Same Problem |
|
|
| ralf.butler wrote: | | move up ... |
Same problem here - also on ubuntu 10.04. |
|
| Back to top |
|
|
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
| Posted: Mon May 10, 2010 9:06 pm Post subject: |
|
|
| thanks daniel |
|
| Back to top |
|
|
netero
Joined: 25 May 2009
Posts: 207
Location: Switzerland
|
| Posted: Mon May 10, 2010 10:22 pm Post subject: |
|
|
Hello,
Maybe you could explain a little more? It's difficult to answer you without having more details.
TO_STRING is a SQL syntax, not java.
For instance if you are using a ResultSet, then there is the
getString(int columnIndex) method. TO_STRING would be allowed as syntax if you pass a command to the database with a PreparedStatement...
I will watch this topic to see if you need further explanation...
Regards.
netero |
|
| Back to top |
|
|
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
| Posted: Mon May 10, 2010 10:43 pm Post subject: |
|
|
Hi netero,
thanks for watching into that. I was about to post a bug to nb bugzilla. When repeating all steps to write a proper bug report the TO_STRING issue didn't pop up. And after further testing I can confirm that this error doesn't appear any more. I have no idea how it has been fixed (perhaps latest 10.04 update?).
However, there is still the problem that the data view is not shown. So, a simple SELECT * FROM myTable; does not display the data grid.
I even deleted all my personal nb settings, but even than the data grid does not appear.
Thanks,
Ralf |
|
| Back to top |
|
|
xaurion
Joined: 11 May 2010
Posts: 1
|
| Posted: Tue May 11, 2010 11:36 am Post subject: |
|
|
Hi,
Same problem here!
too ubuntu 10.04 lucid.
I don't find more info about this bug.
Regards, |
|
| Back to top |
|
|
netero
Joined: 25 May 2009
Posts: 207
Location: Switzerland
|
| Posted: Tue May 11, 2010 6:22 pm Post subject: |
|
|
Did you mean the error was shown in the imbedded cell viewer of the table?
I tried to view only varchar columns, I had no problem viewing the data. Except that by default the window is split in three parts:
- top = my sql command
- middle = the output grid => it was invisible, had to pass over with the mouse to see the handle to enlarge this part!
- bottom = the output messages tabs
Maybe your bug comes out only with some numeric values, like float or something not directly displayable ? Did you try a select with only string columns? |
|
| Back to top |
|
|
Fallbaer
Joined: 13 May 2010
Posts: 3
|
| Posted: Thu May 13, 2010 4:03 pm Post subject: |
|
|
Hi,
I am getting no error message-popup, but the result table does not show up either. If I right-click on the node with the table name and then on "View Data" I get the output
| Quote: | Executed successfully in 0 s.
Line 1, column 1
Execution finished after 0 s, 0 error(s) occurred. |
Thats fine but there is no table view. I know that there records in this table. I tried it with different tables, different schema, different databases.
I am using Netbeans 6.8 on Ubuntu 10.04 64bit and derby 10.3.2.1, Java is OpenJDK 1.6.0_18.
In previous releases, I had no problems.
In a sample table I had only text columns (varchar).
Any help is appreciated!
Regards,
Max |
|
| Back to top |
|
|
netero
Joined: 25 May 2009
Posts: 207
Location: Switzerland
|
| Posted: Thu May 13, 2010 8:14 pm Post subject: |
|
|
Hello again,
I have the same NetBeans version as you, the same Ubuntu version except 32 bits, only difference is derby 10.2.2.0, so very slight differences.
Did you really try to go with the mouse at the window split line? The table output is hidden between the sql command window and the output log. Then at the frontier the mouse pointer changes to handle and you can enlarge the panel vertically so the table columns and rows become visible!
I hope it is so simple for you too because I would not have any other idea...
Good luck
netero |
|
| Back to top |
|
|
Fallbaer
Joined: 13 May 2010
Posts: 3
|
| Posted: Thu May 13, 2010 10:25 pm Post subject: |
|
|
Hi,
thanks for your reply! I checked your hint. I resized the windows and checked their frontiers, I even undocked them. Nothing.
Regards,
Max |
|
| Back to top |
|
|
netero
Joined: 25 May 2009
Posts: 207
Location: Switzerland
|
| Posted: Mon May 17, 2010 4:46 pm Post subject: |
|
|
Hello again,
I don't see replies, so I try one...
I wonder about execution time 0 0s. You said:
| Quote: | Executed successfully in 0 s.
Line 1, column 1
Execution finished after 0 s, 0 error(s) occurred.
|
This seems too strange, 0 seconds means the select was not even tried but failed at syntax check. So my questions:
1) Did you try accessing this table with a program (Java for instance)? Is it possible or does it fail also?
2) I right-clicked on the database to see the properties, and I saw that some properties give a list of accepted functions: Numeric functions, String functions and so on. I never saw TO_STRING function in there (see your stack trace: "java.lang.NoSuchFieldError: TO_STRING").
2a) Are you sure you are not using TO_STRING in your command?
2b) If TO_STRING would be an imbedded command issued by the derby package itself, is there a way of making derby accept that command, for instance in checking some options like "Extended SQL grammar" or "ANSI 92 full level SQL"? These options are not checked in my install...
Hope someone is able to give better hints
netero |
|
| Back to top |
|
|
Fallbaer
Joined: 13 May 2010
Posts: 3
|
| Posted: Mon May 17, 2010 6:20 pm Post subject: |
|
|
Hi,
yes, accessing the table within a program works fine!
By right-clicking on the table, I execute only an "selct * from <table>" thats all. No to_string function. I tried a "select count(*) from <table>".
No success.
Regards,
Max |
|
| Back to top |
|
|
ralf.butler
Joined: 11 Sep 2009
Posts: 17
|
| Posted: Fri May 28, 2010 11:56 am Post subject: |
|
|
| Just want to inform you that this isn't an issue with the 6.9 release candidate. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
