Accessibility

Table of Contents

Adobe Flex, BlazeDS, and Hibernate JPA on Tomcat and MySQL — Part 1: Putting it all together in a simple demo application

Installing the software

Before building the application, install the software listed in the Requirements section.

Eclipse and Adobe Flex Builder

First, download and install Eclipse, then install Adobe Flex Builder 3 as a plug-in into Eclipse. Because Flex Builder does not include the Java Development Tools, it is installed on Eclipse as a plug-in instead of the standalone version. For more information on installing Flex Builder 3, see Install Flex Builder Plug-in on Windows.

Tomcat

Extract the Tomcat Server file apache-tomcat-6.0.18.zip to the folder C:\ADC.

MySQL

Create a C:\ADC\mysql folder.

Extract mysql-noinstall-5.0.51b-win32.zip and mysql-connector-java-5.1.6.zip in C:\ADC\mysql.

Hibernate

Also extract the four Hibernate ZIP files to the c:\ADC\hibernate directory as shown below in Figure 1.

The extracted Hibernate files on the file
system

Figure 1: The extracted Hibernate files on the file system

Setting up the database

Before you develop the application, you need to start MySQL and create a database. You can do this in Eclipse, but it is simple to do at the command prompt.

Start MySQL

To start MySQL, open a command prompt window and go to the MySQL directory where you extracted the database files.

cd C:\ADC\mysql\mysql-5.0.67-win32\bin

Execute this command to start the database server:

mysqld --console

Later, if you need to shut down MySQL, execute this command:

mysqladmin -u root shutdown

Create the database

To create the database, execute the following command at a command prompt while still in the C:\ADC\mysql\mysql-5.0.67-win32\bin directory:

mysqladmin -u root create consultant_db

The name of the newly created database is consultant_db. To verify the database has been successfully created, execute this command:

mysqlshow.exe -u root

After executing the command all databases are listed in the command prompt window. The database table will be generated by Hibernate from the Java bean when the application is run for the first time.