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 153849 - ORDER BY over JTDS
Summary: ORDER BY over JTDS
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: jawed
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-25 12:19 UTC by mini_root
Modified: 2009-02-19 20:37 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 mini_root 2008-11-25 12:19:45 UTC 
Hi,

When i try execute request:

SELECT * FROM INVENTTABLE
ORDER BY ITEMID

'Next Page', 'Previous Page' switch to disabled and 'Total Rows' set to 'N/A', also text field 'Page Size' has max 
value 9999. In result - paging not work.

But, if:

SELECT * FROM INVENTTABLE

All working correctly.

I want use ORDER BY and paging, whether there is a workaround for this problem?
Comment 1 _ ahimanikya 2008-12-06 00:34:46 UTC 
This may have been fixed by http://hg.netbeans.org/main/rev/a4aea630d79b

I don't have JTDS, please try the latest dev build and reopen if you think it still does not work.
Comment 2 Roman Mostyka 2008-12-07 02:11:06 UTC 
mini_root, can You take a look to be sure that this issue was really fixed?
Comment 3 mini_root 2008-12-10 12:30:00 UTC 
ok, i check the night builds in the near future