Currently Being Moderated

Configure Oracle Database for Contour

VERSION 8

Created on: Oct 6, 2008 9:30 AM by Sean Tong - Last Modified:  Jan 21, 2010 12:59 PM by Sean Tong

1. Download Oracle JDBC driver for your Oracle version. The JDBC driver page is:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

 

Make sure you download version 10.1.0.5 driver. Other versions of driver all have some known problems. The name of the JDBC driver file is usually ojdbc14.jar

 

2. Copy the JDBC driver file into common library folder in your  tomcat: {tomcat}/common/lib for Tomcat 5.x or {tomecat}/lib for Tomcat 6.x

 

3. Create a database for Contour, e.g, contourDb.

 

4. Create a user/schema for contour, e.g. contour.

 

5. Grant the following roles to the the newly created user "contour"

  • CONNECT
  • RESOURCE

 

6. Configure Oracle database during setup:

Connection String: jdbc:oracle:thin:@localhost:1521:contourDb

User: contour

Passowrd: password

 

We have tested the above steps for Oracle 10g Express.

Average User Rating
(0 ratings)
My Rating:




Add a comment Leave some feedback about this document.
masterrwong masterrwong  says:

typo in "tablse"

More Like This

  • Retrieving data ...

More by Sean Tong