Configuring AquaLogic Commerce Services
22 BEA AquaLogic Commerce Services Deployment Guide
MySQL
Database Driver JAR file: mysql-connector-java-3.1.11-bin.jar
Database Driver: com.mysql.jdbc.Driver
Database Connection URL:
jdbc:mysql://HOSTNAME:PORT/DBNAME?autoReconnect=true&useUnicode=true&characterE
ncoding=UTF8
(Default Port is 3306)
Database Driver Download: http://dev.mysql.com/downloads/connector/j/3.1.html
Oracle
Database Driver JAR file: ojdbc14.jar
Database Driver: oracle.jdbc.driver.OracleDriver
Database Connection URL: jdbc:oracle:thin:@_HOSTNAME:PORT:SID
(Default port is 1521)
Database Driver Download:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
Microsoft SQL Server
Database Driver JAR file: msutil.jar, msbase.jar, mssqlserver.jar (all 3 are required)
Database Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Database Connection URL:
jdbc:microsoft:sqlserver://HOSTNAME:PORT;DatabaseName=DBNAME;selectMode=cursor
(Default port is 1433)
Database Driver Download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=07287b11-0502-461a-b138-
2aa54bfdc03a&DisplayLang=en
Configuring AquaLogic Commerce Services
This section explains how to configure the various AquaLogic Commerce Services applications.
Each sub-section explains the common configuration parameters. There are many other
configuration parameters not described here which are further documented in the comments of
the various configuration files listed. These other parameters can use their default values and
should only be modified if needed.
Storefront
Configure the following files for your AquaLogic Commerce Services Storefront application:
• acegi.xml
• commerce-config.xml
• ep-treecache.xml
