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 http://dev.mysql.com/downloads. 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 O’Reilly online learning.

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