I don't think the datatype is the issue here. An int can hold much larger
values than 1000 (-2^31 to 2^31-1 to be precise) so that should not be a
problem.

I've had a quick look in the JavaDocs
(http://java.sun.com/j2se/1.5.0/docs/api/index.html) and I cannot find any
method called getRowCount() related to database classes. Is this a method
from a custom class? Given the one line of code, it's not possible to
guess...

Last but not least, can you confirm there is no limit on the number of rows
that is being fetched at once? If there is one (and thousand seems like a
possible one), then that's the reason you're only seeing 1000 rows instead
of 12000.

Best regards,

JayCee
--
http://jcsnippets.atspace.com/
a collection of source code, tips and tricks