*
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
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: 346

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: 41117
    
  45
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: 346

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: 41117
    
  45
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.
 
 
subject: Java DB - which driver to use?
 
Similar Threads
DB2 access from browser using JDBC
not able to get values into database
Clarifications on Java
Connecting to remote database
no ocijdbc9 in java.library.path in JDK 1.4.2