I am currently working on a project in J2EE. We are using EJB 2.0, CMP 2.0, JBoss 3.0.6
Our requirement is to store objects on the central server and a few remote servers in clustered mode. These objects are in the order of 1-10 MB.
I am required to choose a database which is opensource as our project is supposed to use all the open source products.
Storing files of this size into file system looks nice but,
(1) I would be voilating the EJB spec (this is not mandatory but that was just a point) as i would access IO
(2) As the remote servers are in clustere mode it would be tough for the remote servers to access the file.
Can somebody suggest some good databases out there that can do the required ?
I have the following in mind
Ozone --> http://www.ozone-db.org/
MySql --> Open Source
Precise sells a J2EE performance product that uses MySQL as data store if the customers does not have 'commercial' database. It works very well for us. Sets up quickly and has decent performance for a small system.
> I am required to choose a database which is opensource as our project
> is supposed to use all the open source products.
Take a look at Firebird. Its a very active Open Source database based on the sources of Borlands InterBase. Been using it in one form or another for about 10 years, and not really had to look to anything else.
It works well in JBoss, especially as its JCA-JDBC driver development is headed by one for the JBoss team.
you can also take a look at 2 really fine open source databases:
- SAPDB - http://www.sapdb.org/
- POSTGRES - http://www.postgresql.org/
I think them both can meet your requirements.
Thanks to all you folks who posted.