Create Oracle Data Source

[Ed Gray <ew...@gmail.com>]

OK, I give up!!

How do you create an Oracle data source with geronimo 1.1.?

Re: Create Oracle Data Source

[Aaron Mulder <am...@alumni.princeton.edu>]

1. Get an Oracle JDBC jar and rename it to something with a version in
the name, e.g. oracle-jdbc-9.0.3.jar.

2. Go to the "common libraries" screen in the console.  Select the JAR
above with the file chooser.  Make sure the other fields read
something like group=oracle, artifact=oracle-jdbc, version=9.0.3,
type=jar (it may detect the group wrong, for example).  Hit the
Install button.

3. Go to the Database Pools screen in the console.  Hit create a new
database pool "Using the Geronimo database pool wizard".

4. Pick a name for the pool, and select the Database Type "Oracle
Thin", and hit Next

5. Select oracle/oracle-jdbc/9.0.3/jar as the "Driver JAR" (may vary
depending on what you entered on the common libs screen).  Enter the
DB user, DB password, port, SID, and host and click Next.

6. Verify the resulting URL, enter pool settings if you like, and test
the connection.

7. Hit the Deploy button

Thanks,
    Aaron



On 7/31/06, Ed Gray <ew...@gmail.com> wrote:
> OK, I give up!!
>
> How do you create an Oracle data source with geronimo 1.1.?
>