Currently the CSVWriter is not able to support ResultSet having morethan 65536 number of rows.
I would be nicer to have such support for multi-files output if the records exceeds 65536.
I believe this may be an limitation of the implementation of the ResultSet you are using. try parsing out the ResultSet yourself outside of CSVWriter and see if you hit the 65536 limitation. Try something like:
public void countRowsInResultSet(java.sql.ResultSet rs)
{
int count = 0;
while (rs.next())
count++;
System.out.println(count);
}
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I believe this may be an limitation of the implementation of the ResultSet you are using. try parsing out the ResultSet yourself outside of CSVWriter and see if you hit the 65536 limitation. Try something like:
public void countRowsInResultSet(java.sql.ResultSet rs)
{
int count = 0;
while (rs.next())
count++;
System.out.println(count);
}
Cleaning up old issues. If this still needs attention, please open a new ticket.