As we saw in the previous chapters, the SeamGen application is used for generating skeleton Seam applications. One of its benefits is that it will configure all of the aspects required for using JPA within a Seam application.
Let's take a look at the database-related questions that SeamGen asks when we set up a new project.
When we create a new project with SeamGen, we are asked several questions about the database and how we would want the application to interact with it.
Initially, SeamGen asks us which type of database would we want to use for our application. SeamGen has knowledge of HSQL, MySQL, Oracle, Postgress, Microsoft SQL Server, DB2, Sybase, EnterpriseDB, and H2. The default option is to use the embedded Hypersonic database that is supplied with all of the JBoss Application Servers.
./seam setup
<non-database questions omitted for brevity>
[input] What kind of database are you using? [hsql] ([hsql], mysql, oracle, postgres, mssql, db2, sybase...