|
Apache Derby is an open source, lightweight and flexible database system written in Java language. It is especially convenient for demos since it can be embedded within the Java applications. If you choose Apache Derby for this tutorial you don't have to do anything since the necessary binaries (database engine and drivers) are already available. The "SuperStore" tutorial database is also ready for immediate use under {PROJECTS}\samples\Derby directory.
If you're going to use MySQL and if it is not yet available on your computer, you can download MySQL Database Engine, Administrator and Query Browser from MySQL Web Site http://www.mysql.com
Steps:
| 2. | Install MySQL Community Server and GUI Tools. Copy the JDBC driver (Connector/J) (mysql-connector-java-5.x.x-bin.jar) to
"{INSTALL_DIR}\lib\cpn\mor\RelDB\drivers" directory |
| 3. | Open MySQL Administrator |
| 4. | Click on Restore icon on the left and click on [Open Backup File] button on the bottom-right |
| 5. | Choose "{INSTALL_DIR}\lib\cpn\Tutorial\sql\MySQL.sql" file on the file dialog |
| 6. | Click on [Start Restore] button |
Steps:
| 1. | Open MS SQL Server Enterprise Manager. |
| 2. | Create a new database with name "SuperStore". |
| 3. | Connect to "SuperStore" database |
| 4. | Open the SQL Analyzer Tool |
| 5. | Open the file "{INSTALL_DIR}\lib\cpn\Tutorial\sql\SQLServer.sql" file with a text editor and copy its content and paste into the SQL window and execute to create the required tables. |
Steps:
| 1. | Open Oracle Enterprise Manager Console |
| 2. | Start SQL Plus Tool and connect with "system" user. |
| 3. | Open the file "{INSTALL_DIR}\lib\cpn\Tutorial\sql\Oracle.sql" file with a text editor and copy its content and paste into SQL Plus window and execute. The SQL will create a table space and an user with name "SUPERSTORE" as also all the tables used by this application. |
|
