wood burning stoves 2.0*
The moose likes JDBC and the fly likes Java DB - which driver to use? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java DB - which driver to use?" Watch "Java DB - which driver to use?" New topic
Author

Java DB - which driver to use?

Faisal Ahmad
Ranch Hand

Joined: Aug 31, 2006
Posts: 344

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
Marshal

Joined: Mar 22, 2005
Posts: 41049
    
  43
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.


Ping & DNS - my free Android networking tools app
Faisal Ahmad
Ranch Hand

Joined: Aug 31, 2006
Posts: 344

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
Marshal

Joined: Mar 22, 2005
Posts: 41049
    
  43
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Java DB - which driver to use?
 
Similar Threads
not able to get values into database
Connecting to remote database
no ocijdbc9 in java.library.path in JDK 1.4.2
DB2 access from browser using JDBC
Clarifications on Java