-
1. Re: What's a suitable open source database for JBoss?
raja05 Dec 11, 2003 1:33 PM (in response to dswearingen)MySQL should work okay. If you download MySQL 4.x , i think those are the ones that have transactional support although there is a way for MySQL 3.x to behave in a transactional manner.
-
2. Re: What's a suitable open source database for JBoss?
jonlee Dec 11, 2003 1:44 PM (in response to dswearingen)Both databases are fine. However, you might find PostgreSQL closer in architecture to Oracle in terms of the listener architecture, the psql interactive shell, user/access management and sequence support. The main difference to Oracle is that PostgreSQL follows the SQL92 spec. DB2 UDB is a closer implementation to PostgreSQL because of this. If you look at the standardjbosscmp-jdbc.xml you will see the mapping supports for the various databases with respect to CMP.
-
3. Re: What's a suitable open source database for JBoss?
dswearingen Dec 11, 2003 2:22 PM (in response to dswearingen)After my initial post re a suitable database, I discovered that JBoss (haven't installed it yet) comes with Hypersonic database. I suppose then that it's simpler just to use that database, or would I get more functionality (ealize this question is relative to what my requirements will be) with MySQL and/or Postgres?
That is, is Hypersonic just there to "get you started" or is it pretty rich in it's functionality.
Thanks again.
David -
4. Re: What's a suitable open source database for JBoss?
jonlee Dec 11, 2003 3:12 PM (in response to dswearingen)Hypersonic is there to get you started. It is not for heavy duty development of CMP, heavy load for CMP and so on. You can use it, but you would need to switch it to JDBC mode in order to manage the DB, and you'll probably need to get the management tools from the Hypersonic SourceForge site. It also has a known problem when running in JDBC mode. YMMV. With JBoss 3.2.2 and 3.2.3, it is configured for in-process mode rather than JDBC mode, by default.
-
5. Re: What's a suitable open source database for JBoss?
dswearingen Dec 11, 2003 3:59 PM (in response to dswearingen)Thanks very much for the assistance.
David