Adding persistence to our application

In order to persist data, JPA needs a relational database; we will use the MySQL database, which is pretty popular among developers and can be downloaded for free from It is recommended to download the latest stable release of MySQL 5.x and install it using the simple installation wizard.

Setting up the database

We will create a database named appstore; we will then add a user named jboss and assign him all privileges on the schemas.

Open a shell under the bin folder of your MySQL installation and launch the executable mysql. Once logged in, execute the following commands:

CREATE DATABASE ticketsystem; USE ticketsystem; CREATE USER 'jboss'@'localhost' IDENTIFIED BY 'jboss'; GRANT ...

Get JBoss AS 7 Development now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.