commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Simon Kitching <>
Subject Re: General Database Question
Date Fri, 12 Sep 2008 12:29:19 GMT schrieb:
> I have a process that I've archived into a jar file.  That jar file gets called
> on a schedule, on a Windows machine.  Part of my process queries 3 tables in an
> MS Access database to extract the data and dump it to a DB2 database.  I've
> noticed that the last few times it has ran, it always returns 20000 records from
> one of the tables.  I've seen that particular table have fewer records, like in
> the 2000 to 3000 range, as much as 15000+, but now it keeps returning exactly
> 20000.  I didn't like the fact that the number was so round, so I created a test
> class that does a simple "SELECT COUNT(*) FROM" and I pass the table name as a
> parameter to the class.  I was shocked to see that the result was in fact 20000
> for the particular table in question.
> So I guess my question is, could the Access database be locked down to only hold
> a maximum of 20000 records in a given table?  Or is there something else going
> on?
What result do you get when running the same query from within a windows 
sql development tool?

And what do you see if you use a java-based sql development tool? One 
reasonable one is:


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message