Switching Database To Oracle

 Top  Previous  Next

To use Oracle as AggreGate Server's database engine, follow the generic instructions from Switching To Another Database Engine article. Here is a list of notes specific to Oracle:

1. Download the proper version of Oracle JDBC Driver for Java (JDK) 1.6 and store it on the machine running AggreGate Server. At the time of this writing, it is available at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/.
2. Put ojdbc.jar into the /lib subfolder of AggreGate Server installation folder.
3. Set Database Driver in AggreGate Server Global Configuration Setting to oracle.jdbc.OracleDriver. This is the java class name for the Oracle driver.
4. The Database URL setting for the Oracle database has the following format: jdbc:oracle:thin:@host[:port]:database, where host is the IP or hostname of the Oracle server (can be an empty string or localhost), port is port name on which Oracle server is running (omit this part of URL to use the default value), and database name is the name of database that contains AggreGate Server's data. You can use linkserver for the database name. For example, if your Oracle server runs at 192.168.0.1 with its default port, use the following URL: jdbc:oracle:thin://192.168.0.1:linkserver.
5. Set Database Dialect setting to Oracle9Dialect if you are using Oracle 9 or above and to OracleDialect otherwise.