If you have installed the ATG platform on Microsoft Windows, your installation includes a preconfigured MySQL database. The MySQL database is intended for evaluation and development purposes only. Before deploying your application in a production environment, you should configure both your application server and ATG products to use a production-quality database management system such as Oracle or Microsoft SQL Server. Your applications can then access application server resources and ATG components simultaneously. For a list of supported databases, see the Oracle ATG Web Commerce Supported Environments Matrix document in the My Oracle Support knowledge base.

The ATG platform includes a number of tools for creating a database, adding and removing tables, configuring data sources and connection pools, and importing and exporting data. This chapter covers the following topics:

Note: Changing ATG’s out-of-the-box database schemas is not recommended, although you can extend the schemas as necessary. If you do make any schema changes, you must migrate the changes manually when you upgrade to a new version of ATG.

Note:JBoss comes with its own demo database, Hypersonic (note the datasource hsqldb-ds.xml in the /deploy directory). Some JBoss components require that database, so do not remove it unless you also plan to remove those components.

loading table of contents...