File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes java application  MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "java application  MS Access" Watch "java application  MS Access" New topic

java application MS Access


Joined: Sep 27, 2001
Posts: 4
I have developed a java application using Access database.
it needs to serve for 20-25 users.
Iam using tomcat web server.
If 3-4 user are connected tomcat sessions are getting expired.
And application is very slow.
I am using jdbc-odbc bridge driver to get the connection.
I have tried connection pooling too.
Can any one help me to improve the performance.
Thanks in advance.
Brent Boyer

Joined: Oct 06, 2001
Posts: 2
My advice: dump MS Access NOW!
It is a complete and total piece of crap database that is going to cause you far more trouble than it is worth, which is nothing. I speak from experience. I do not care that it ships free with many Windoze systems and that it has an OK GUI front end. It is so bad in performance, especially for the application you cite (20+ users) that you should just give up on it.
I have encountered the bug you cite (Access virutally freezes the system when you make more than 2 or 3 database connections), and never figured out a workaround.
As far as decent databases go, I highly recommend "Poor Man's Oracle", also known as MySQL. It is native code and has only a command line UI built in. Nevertheless, it offers very high performance, has decent JDBC support, is open source, and is very actively maintained (unlike most open source projects).
Other people have told me similar good things about Postgres.
I would love to find a good, free, open source all-Java database. There used to be HypersonicSQL, but it has gone defunct (and had other problems like a fair amount of bugs). If anybody has a good rec here, please post!
I agree. Here's the link:
subject: java application MS Access
It's not a secret anymore!