list archives . users mailing list
 

Subject: OGSA-DAI & Oracle9i

Date view Thread view Subject view Author view Attachment view

From: Brian Hills (brianh@nesc.ac.uk)
Date: Mar 25, 2003 16:18

Hi,

I have OGSA-DAI 1.5 running and querying Xindice and MySQL at the moment
and everything is working fine.

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 am currently trying to experiment with 1) using variations of the
config below but I get a "Invalid Oracle URL specified
java.sql.SQLException: Invalid Oracle URL specified" error.

Any help is much appreciated!

Thanks

Brian

           <!-- ORACLE database config -->

        <GDSF:DatabaseManagementSystem name="RDBMS2" type="oracle"
location="localhost:1521" version="9.2">
         
        <GDSF:Driver name="driver" type="jdbc"
classname="oracle.jdbc.driver.OracleDriver" version="2"/>
        <GDSF:QueryLanguage name="sql" type="SQL" version="1992"
driver="driver"/>
        <GDSF:RoleMap name="rolemap"
classname="uk.org.ogsadai.common.rolemap.SimpleFileRoleMapper"/>
        <GDSF:LogicalSchema name="BasicSchema" version="13.4"/>
        <GDSF:PhysicalSchema name="BasicSchema"
logicalSchema="BasicSchema" roleMap="rolemap" version="1.2"/>
        <GDSF:Database name="bonham.edikt" physicalSchema="BasicSchema"
version="1.2"/>
        </GDSF:DatabaseManagementSystem>
         
        <!-- SQL DataResource Config -->
        <GDSF:DataResource name="SQLDataResource1" dbms="RDBMS2">
        <GDSF:QueryLanguageRef name="sql"/>
        <GDSF:DatabaseRef name="bonham.edikt"/>
        </GDSF:DataResource>

 

Date view Thread view Subject view Author view Attachment view
webperson@nesc.ac.uk