Hi 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. Ravi
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!