Show Table of Contents
Appendix C. Use Alternative Databases with JBoss AS
C.1. How to Use Alternative Databases
Note
The Hypersonic database provides default "out of the box" database functionality for evaluation and development use only. It should not be used as a production-use database. Technical support is not available for this component, and while we accept bugs filed against this component, we do not make any commitment to fix them within a specific timeframe.
JBoss utilizes the Hypersonic database as its default database. While this is good for development and prototyping, you or your company will probably require another database to be used for production. This chapter covers configuring JBoss AS to use alternative databases. We cover the procedures for all officially supported databases on JBoss Enterprise Application Platform. They include: MySQL 5.0, PostgreSQL 8.1, Oracle 9i and 10g R2, DB2 7.2 and 8, Sybase ASE 12.5, as well as MS SQL 2005.
Please note that in this chapter, we explain how to use alternative databases to support all services in JBoss AS. This includes all the system level services such as EJB and JMS. For individual applications (e.g., WAR or EAR) deployed in JBoss AS, you can still use any backend database by setting up the appropriate data source connection as described in Section 7.3, “Configuring JDBC DataSources”.
We assume that you have already installed the external database server, and have it running. You should create an empty database named
jboss, accessible via the username / password pair jbossuser / jbosspass. The jboss database is used to store JBoss AS internal data -- JBoss AS will automatically create tables and data in it.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.