Subject: Re: OGSA-DAI & Oracle9i
- Next message: Shishir S. Bharathi: "Multiple statements in the script."
- Previous message: Brian Hills: "OGSA-DAI & Oracle9i"
- In reply to: Brian Hills: "OGSA-DAI & Oracle9i"
- Next in thread: Brian Hills: "RE: OGSA-DAI & Oracle9i"
From: neil p chue hong (N.ChueHong@epcc.ed.ac.uk)
Date: Mar 25, 2003 16:47
On Tue, 25 Mar 2003, Brian Hills wrote:
| I would now like to use OGSA-DAI to query our Oracle 9i database. I
| know OGSA-DAI 1.5 has not been tested with Oracle and appreciate that
| this scenario is not yet supported but would be grateful for any
| hints/recommendations as to how I might investigate this possibility.
| Could anyone in the OGSA-DAI team confirm if they would anticipate that
| this would:
|
| 1) Simply be a matter of changing the GDSF Config and the DatabaseRoles
| files, or
|
| 2) Require changes to the source code.
I believe - although someone else can hopefully back me up -
that it's just a matter of changing the configuration files, and
ensuring you have the correct JDBC driver.
However, one thing to note is that one of Oracle's standard
information services uses port 8080, so you will need to change
some settings to avoid a port clash.
Someone from Oracle is currently configuring R1.5 to use Oracle
9i and postgres - if you have a specific query, he may be able
to help. I can relay a query to him.
cheers,
neil
-- Neil P Chue Hong - Principal Consultant - |epcc| Rm 2259, JCMB, Mayfield Road, Edinburgh, EH9 3JZ, UK tel: 0131 650 5957 / email: N.ChueHong@epcc.ed.ac.uk fax: 0131 650 6555 / www: http://www.epcc.ed.ac.uk
- Next message: Shishir S. Bharathi: "Multiple statements in the script."
- Previous message: Brian Hills: "OGSA-DAI & Oracle9i"
- In reply to: Brian Hills: "OGSA-DAI & Oracle9i"
- Next in thread: Brian Hills: "RE: OGSA-DAI & Oracle9i"