Recommended Open Source Database
cleveridea Sep 25, 2001 2:28 PMHi. I am an experienced Java developer although am new to J2EE. I have heard some good things about JBoss and wanted to give it a try.
Within the HTML online JBoss documentation (which is pretty impressive for an open source project BTW) there is a section regarding the issues of using various Database systems with JBoss connection pooling and JAWS.
The databases that I have most experience with are Oracle and Interbase. I am particularly interested in an all open source solution, so would prefer Interbase as my JBoss database. However, I would learn PostGres if that database is better supported.
Having searched through groups.google.com for messages, and also looking at the comments about JDBC drivers below, I am concerned about reliable database operation with JBoss and JAWS. Interbase, Postgres and Oracle all have some worrying comments about stability. I have included some comments at the end of this posting.
So my question is - can anyone suggest the open source database that is best supported with JBoss? That people are using right now, contributing feedback and bug fixes, able to provide guidance and assistance. Once I start learning JBoss I would like to give back any assistance I can and answer questions for others but would like to know which is the best route to start. Postgres? Interbase? MySQL?
Any feedback greatly appreciated.
Mark
---
PostgreSQL 7.x
Extreme Java "long" values will cause SQLExceptions and may corrupt the driver so that further actions fail.
Interbase 6.x
For CMP entity beans, serialized Java Objects are limited to 2000 bytes by default in automatically generated tables. You may increase this limit by changing the mapping or creating the table manually.
The interclient JDBC driver seems to have trouble checking whether a table exists, so until that is resolved you can't have JAWS create the table anyway.
Oracle 8i with native JDBC 2 Optional Package XADataSource
Extreme Float or Double values will cause SQLExceptions The Oracle XADataSource requires the Oracle Xid implementation. Other vendor's XADataSource implementation may or may not be able to interoperate.