Return to Jive Software

Skip navigation
1,913 Views 1 Replies Last post: Apr 7, 2008 9:25 AM by dmanchester RSS
dmanchester Novice 3 posts since
Jan 30, 2008
Currently Being Moderated

Apr 7, 2008 8:37 AM

Comments on database setup instructions for Oracle

Hello,

I wanted to share some comments on the database setup instructions for Oracle:

  1. There's a extraneous semicolon in the CREATE USER statement. It should be:

    CREATE USER clearspace IDENTIFIED BY clearspace;

  2. The Oracle role is "RESOURCE" (no trailing "S"). So, the GRANT statement should be:

    GRANT CONNECT, RESOURCE TO clearspace;

  3. The "classes12.zip" Zip file is mentioned as the location of Oracle's JDBC Thin driver. Per this documentation, though, when using JDK 1.4 and later, "ojdbc14.jar" is the file to use.

  4. The "oracle.jdbc.driver" package is mentioned in conjunction with the OracleDriver class. However, that package is deprecated. (In this documentation, see the discussion of the getJavaSqlConnection method.) Per this documentation, the "oracle.jdbc" package is the preferred one to use.

Dan

More Like This

  • Retrieving data ...

Bookmarked By (0)