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 258176 - Cannot change page at query results tab when using HSQLDB
Summary: Cannot change page at query results tab when using HSQLDB
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 8.1
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-28 20:54 UTC by xsistema
Modified: 2016-03-16 19:53 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Using HSQLDB (186.53 KB, image/jpeg)
2016-02-28 20:54 UTC, xsistema 		Details
IDE Log (60.64 KB, application/octet-stream)
2016-02-29 22:27 UTC, xsistema 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description xsistema 2016-02-28 20:54:19 UTC 
Created attachment 158672 [details]
Using HSQLDB

If I connect to HSQLDB and run SQL query - at the results tab (for example query results are 50000 rows, page size set to 200) - only the 1 page is visible. When I try to go to page 2 (or others) - the tab shows no results - but page is 2. And page navigation arrows are disabled - grey - not possible to go back. So the only way is to refresh, then 1 page is visible again. 

If I connect to Derby DB - everything works fine.
Comment 1 matthias42 2016-02-29 19:53:01 UTC 
I just did a quick try with current version of hsqldb and could not reproduce. Could you please redo the test and provide the message.log of the session here?

http://wiki.netbeans.org/FaqLogMessagesFile

Please also check if an exception is logged (small exclamation mark on right bottom corner).
Comment 2 xsistema 2016-02-29 21:37:00 UTC 
I noticed "Error 200" at the left corner at the bottom after I press next page bottom. "View -> IDE Log" shows nothing about that. Where I can find more info?
Comment 3 matthias42 2016-02-29 21:51:56 UTC 
The view log feature does not immediately reflect the logging stream. Please run netbeans, reproduce the problem, shut down netbeans and attach the log here.
Comment 4 xsistema 2016-02-29 22:27:26 UTC 
Created attachment 158679 [details]
IDE Log
Comment 5 matthias42 2016-03-01 16:49:14 UTC 
I agree, that there is no info in the log. Can you provide the database, that reproduces this error? Or if the data is problematic - can you provide the schema? (Please check if a newly created db shows the same problem).

There was at least one problem fixed in the nightly builds that caused fetch problems to be fatal. You could try if the problem is reproducable with a nightly build.
Comment 6 matthias42 2016-03-16 19:53:02 UTC 
Closing as WORKSFORME. If you can provide more info or give more info to reproduce, please feel free to reopen.