• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java DB - which driver to use?

 
Faisal Ahmad
Ranch Hand
Posts: 355
Chrome Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!

I'm developing a web application for an intranet comprising 300 workstations. I have decided to use Java Derby database. Other stuff that I will be using: JSP, Servlets, JDBC, Tomcat and Linux. Could you please suggest me which driver I've to use - embedded OR network/client?

Thanks and awaiting a reply.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Will the DB ever need to be accessed from outside of the web app, simultaneously to the web app running? You can't do that in embedded mode.
 
Faisal Ahmad
Ranch Hand
Posts: 355
Chrome Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply!

Only my web-app will be using the database. However, the web-app will be accessed simultaneously from almost all workstations present in the intranet. Maybe, in future, there is a possibility that the same web-app could also be accessed from the internet. In this scenario, what should be used - embedded/network?

Thanks again.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The number of users of the web app doesn't matter - you'd still want to use a connection pool to manage that. It sounds as if the embedded driver would be a feasible option. It does have the advantage of not requiring a separate server process, and of all communication happening inside of the JVM, thus improving performance.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic