5 Replies Latest reply on Dec 11, 2003 3:59 PM by dswearingen

    What's a suitable open source database for JBoss?

    dswearingen

      I'm part of a team that has some J2EE experience (WebSphere) but is new to JBoss. We need to start learning the platform soon, but it may be a few weeks until we get a license for SQL Server or Oracle, the ultimate rdbms platform for our project.

      In the mean time, we'd like to install an open source database so we can get started on learning the system. We don't expect to have any vendor-specific database requirements; that is, we hope in a few weeks to be able to drop in SQL Server or Oracle after having done some initial development under MySQL or Postrgresql or whatever.

      So, my question is: will MySQL or Postgres play nice with CMP and other best practices in implementing the EIS tier?

      Thanks.
      David

        • 1. Re: What's a suitable open source database for JBoss?
          raja05

          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

            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

              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

                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

                  Thanks very much for the assistance.

                  David