• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

java application MS Access

Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic