Results 1 to 1 of 1
Thread: problem with fetching data
- 05-24-2008, 02:29 PM #1Member
- Join Date
- May 2008
- Rep Power
problem with fetching data
I'm using 'HXTT Excel' type 4 drivers to access and manipulate MS Excel data. The operations are done directly on MS Excel sheet. When I tries to read a sheet having 2000 records by select query, the resultset gives just 100 rows.
I edited code as stmt.setMaxRow(200) then also it returns 100 rows. I rewritten stmt.setMaxRow(0) to impose 'no limit ' over resultset but then also result was same.
I can't understand what the mess is? Is it excel problem or the driver implementation for method setMaxRow(int) is null?
Plz help me if u know more...
- By BHCluster in forum Advanced JavaReplies: 0Last Post: 04-18-2008, 05:38 PM
- By Java Tip in forum Java TipReplies: 0Last Post: 02-06-2008, 10:23 AM
- By suresh72 in forum Advanced JavaReplies: 0Last Post: 12-19-2007, 12:47 PM