The following topic describes how to configure TrackStudio for use with an ORACLE database management system.
Description- Create the Tablespace.
- Create a TrackStudio user.
- Grant DBA and Resource role to the created user.
- Configure the database connection properties. Oracle connection string includes Database URL, JDBC driver, Login and Password. First part (before "@") of this URL is common, you have no need to modify it. After this character you need to enter your database location like HostAddress:Port:ORACLE_SID. If you are using locally installed version of Oracle, HostAddress is localhost. Default Oracle port is 1521, default ORACLE_SID is ORCL. In the JDBC driver field there is a default JDBC Driver for Oracle, that you don't usually need to modify.
- TrackStudio SA: Go to the Database -> Database Connectivity tab, and enter the JDBC connection properties.
- TrackStudio WAR: Edit the trackstudio.hibernate.properties:
hibernate.dialect org.hibernate.dialect.OracleDialect hibernate.connection.url jdbc:oracle:thin:@localhost:1521:ORCL hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver hibernate.connection.username trackstudio hibernate.connection.password trackstudio
- Initialize the database:
- TrackStudio SA: Go to the Database -> Database Management tab and click the Create Database button.
- TrackStudio WAR:
>sqlplus SQL*Plus: Release 10.1.0.2.0 - Production Copyright (c) 1982, 2004, Oracle. All rights reserved. Enter user-name: trackstudio Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> set define off; SQL> @@ trackstudio-oracle.sql