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.

Bug 182870

Summary: Show SQL select hang up netbeans with more result than one page with HSQLDB
Product: db Reporter: tprochazka <tprochazka>
Component: Show DataAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P4    
Version: -S1S-   
Hardware: PC   
OS: Other   
Issue Type: DEFECT Exception Reporter:

Description tprochazka 2010-03-26 10:33:33 UTC 
I found very interesting problem with internal query result viewer. When I run SQL command like this: SELECT * FROM queue LIMIT 21 and result count is larger than "Page Size" in result window, netbeans hung up and still write only "Executin SQL statement" and I must kill him.

This happen with HSQLDB 2.0 RC8 whch running in server mode on the default port. This problem is not related to HSQLDB itself because my application select much more records internally and I use also pagination result on the JDBC layer.

But with MySQL it's working. No hung up.

Another problem with HSQLDB is that Netbeans doesn't show tables and field when I try to open tree with connection. This also works with MySQL.

I tested it with SQuirreL SQL Client and I can show DB structure (tables, view, procedures)  and No problem with hang up.
Comment 1 Jiri Rechtacek 2011-01-21 13:38:54 UTC 
Lowering the priority, HSQLDB is not one of supported drivers. Anyway, I cannot reproduce with my HSQL Database (hsqldb-2.0.1-rc3).
Comment 2 matthias42 2013-01-20 17:13:33 UTC 
Tried with an older database I created with open office both mentioned points work correctly: db objects are listed and also restricted selected (select top 21 * from BEITRAG) work correctly.

This is hsqldb as bundled with libreoffice 3.6.2.

Please try again with current netbeans and current driver - if it can be reproduced it would be helpful if the db could  be made available.