Creating the Database

JOnAS does not automatically create the database for you. You have to create it prior to running this example. The Account.sql file can be used with most SQL-92 compatible databases. There is also an Account.idb file that can be used with InstantDB. Here are some examples:

• Oracle:

  sqlplus user/passwd SQL> @Account.sql SQL> quit

• MySQL:

  mysql mysql> source Account.sql mysql> \q

• PostgreSQL:

  createdb accountsample psql -d accountsample sampleaccount=# \i Account.sql sampleaccount=# \q

Check your database manual for additional information. You will also have to grant access to the database for the user defined in your database properties file. In the previous example for MySQL, we have to grant anonymous user access to the sampleaccount database without a password from the local host. You can find out how to grant or revoke access to databases in your database administration manual.

Additional information about database configuration is available in the section Configuring Database service of the JOnAS documentation.