General Database Question

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

General Database Question

pgrimard-2

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?
(Embedded image moved to file: pic07711.jpg)

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: General Database Question

Simon Kitching
[hidden email] 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:
   http://squirrel-sql.sourceforge.net/


Regards,
Simon


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: General Database Question

pgrimard-2
I actually don't have a Windows sql development tool.

I just use the JDBC-ODBC driver to access the MDB file, which I've defined as a
system datasource.
(Embedded image moved to file: pic06868.jpg)



                                                                               
             Simon Kitching                                                    
             <[hidden email]                                                
             rg>                                                             To
                                         Commons Users List                    
             09/12/2008 08:31 AM         <[hidden email]>              
                                                                             cc
                                                                               
              Please respond to                                         Subject
               "Commons Users            Re: General Database Question          
                    List"                                                      
             <[hidden email]                                                
                   e.org>                                                      
                                                                               
                                                                               
                                                                               




[hidden email] 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:
   http://squirrel-sql.sourceforge.net/


Regards,
Simon


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: General Database Question

Reinhardt Christiansen
In reply to this post by pgrimard-2


[hidden email] wrote:

> 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?
>  
It's a reasonable question, given the circumstances, but it doesn't seem
like a question that has much to do with the mailing list. I'd be asking
it on an Access user group, such as microsoft.public.access on
msnews.microsoft.com.

Just a friendly suggestion.....


--
Rhino


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: General Database Question

pgrimard-2
I agree, there's probably other user groups that this question is probably
suited for.  I figured somebody here might have an answer though.
(Embedded image moved to file: pic25547.jpg)



                                                                               
             Reinhardt                                                          
             Christiansen                                                      
             <[hidden email]                                             To
             a>                          Commons Users List                    
                                         <[hidden email]>              
             09/12/2008 08:49 AM                                             cc
                                                                               
                                                                        Subject
              Please respond to          Re: General Database Question          
               "Commons Users                                                  
                    List"                                                      
             <[hidden email]                                                
                   e.org>                                                      
                                                                               
                                                                               






[hidden email] wrote:
> 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?
>
It's a reasonable question, given the circumstances, but it doesn't seem
like a question that has much to do with the mailing list. I'd be asking
it on an Access user group, such as microsoft.public.access on
msnews.microsoft.com.

Just a friendly suggestion.....


--
Rhino


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]