The following code gives me 1000 records:
...
rs = stmt.executeQuery("SELECT * FROM applications");
int i = 0;
while(rs2.next()) {
i++;
}
System.out.println("count(applicants) = " + i);
...
but this code gives me the correct size (3767)
...
rs = stmt.executeQuery("SELECT count(*) as c FROM applications");
if(rs.next()) {
System.out.println("count(applicants) = " + rs.getInt("c"));
}
...
Why? I need to get all 3767 records!
|
The trial version queries return the first 1000 rows in the result set.
|
In your documentation (http://www.hxtt.com/text/introduction.html), it states 5000 records! Can I get a temporary license? My demo depends on full data coverage and could result it us purchasing this driver.
|
Please download the latest v3.1 package which hasn't 100 limitation.
|