Java DB (a.k.a. Derby)

I've written a few Java programs in my IT life, most recently I wrote a series of AJAX/JSP/servlet that connects to a backend MySQL DB for financial reporting, basically business health analysis. I am currently in the process of porting the data to JavaDB, Sun's implementation of Apache Derby.

JavaDB can run as an embedded database or as a standalone database connected over a network, much like MySQL. The advantage of running JavaDB as an embedded database is the ability to run both the web, app and db as a single service, doing away with the issues of network connectivity and separate installations.

My plan is to use JavaDB both as a primary store since my data is less than 4 GB in total, and also as a caching store for temporary results. Having the DB embedded in the same JVM means that there are no network bandwidth issues to deal with, and the app has direct control over starting and stopping the DB as necessary. All good things.

Posted at 02:36PM Apr 10, 2007 by samktan in Java  |  Comments[0]