aspose file tools*
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: 355

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: 41874
    
  63
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: 355

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: 41874
    
  63
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java DB - which driver to use?