Setting up the Database
18 BEA AquaLogic Commerce Services Deployment Guide
8. Click Connect
9. On the Query menu click on Execute. This may take a few seconds
10. Repeat steps 1 - 9 for the rest of the *.sql files in the following order:
• base-insert.sql
• snapitup-insert.sql (optional, deploys the AquaLogic Commerce Services Demo Store
"Snap It Up" on your database)
11. When you are finished the above steps you may exit the SQL Server Management Studio
12. If you chose to run the snapitup-insert.sql script you will also need to import the SnapItUp
product catalog data
MySQL 4
This section contains the instructions for creating a MySQL AquaLogic Commerce Services
database. These instructions assume that you have MySQL 4 installed in c:\mysql.
If you have not configured your MySQL server to start automatically, follow steps 1 to start your
server.
1. Start your database server as follows:
a. Open a DOS command window by clicking: Start > Run
b. Type: “cmd” and then press ENTER
c. Change folder to: c:\mysql\bin
d. Type: “mysqld-nt” and press ENTER to start the database.
2. Repeat steps (a) to (c) above to open another DOS command window, and type the following
to enter mysql console:
mysql -u root
If you configured the root user to use a password, type
mysql -u root -p
Type the password for the root user when prompted.
3. Create a database called ALCS.
mysql> create database ALCS character set utf8;
If you choose to use a database name other than ALCS, please make sure this value is
configured correctly when setting up your data source. (See 2 - JNDI and JDBC
Configuration)
4. Create a user account.
