list archives . users mailing list
 

Subject: RE: OGSA-DAI & Oracle9i

Date view Thread view Subject view Author view Attachment view

From: Brian Hills (brianh@nesc.ac.uk)
Date: Mar 26, 2003 10:09

Hi Neil,

Thanks for the information, especially as this is not supported
functionality at the moment! I would be grateful if you could ask the
Oracle contact the process required to query Oracle from OGSA-DAI 1.5.

Also it would be useful if one of the engineers on the OGSA-DAI team
could confirm/reject my thinking below. I've been looking at the
OGSA-DAI source code, specifically for JDBC info. I believe the JDBC
connection is setup in the class:

 
ogsadai-src\src\java\uk\org\ogsadai\porttype\gds\drivers\jdbcdriver\JDBC
DataResourceManager.java

From an initial look, the string constructed to gain a connection to the
db is of the format:

 
<driverType>:<dbmsType>://<uri>/<databaseName>?user=<username>&password=
<password>

Reading the Oracle documentation for the JDK 1.4 drivers I believe a
string of the following, different, format is required:

   jdbc:oracle:<drivertype>:<user>/<password>@<database>

This suggests I'd need to implement another class to connect to Oracle?
- though this might be a bit of a big assumption as I'm not that
familiar with the OGSA DAI design.

Thanks again

Brian

-----Original Message-----
From: neil p chue hong [mailto:N.ChueHong@epcc.ed.ac.uk]
Sent: 25 March 2003 16:48
To: Brian Hills
Cc: users@ogsadai.org.uk
Subject: Re: OGSA-DAI & Oracle9i

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
Date view Thread view Subject view Author view Attachment view
webperson@nesc.ac.uk