list archives . users mailing list
 

Subject: Re: GDSF Configuration

Date view Thread view Subject view Author view Attachment view

From: Shishir S. Bharathi (shishir@ISI.EDU)
Date: Apr 04, 2003 00:53

I too have the same question. I noticed in the source file:
uk/org/ogsadai/common/ServiceConfiguration.java that there can only be one
DatabaseManagementSystem:

        //Currently can be only one data resource
        DataResourceType dr = mConfiguration.getDataResource();
        answer.setProperty(DATA_RESOURCE, dr.getName());
        mLog.debug(DATA_RESOURCE + " = " + dr.getName());

        //There can also be only one DatabaseManagementSystem
        DatabaseManagementSystemType dbms =
                mConfiguration.getDatabaseManagementSystem();

Is this something the ogsadai team is working on ? Currently I do have a
requirement to provide a service that handles both mysql and xindice. I
was thinking along these lines:

Create another set of instances of GridDataServiceRegsitry and
GridDataServiceFactoryP2R1 and use them to handle xindice. So the client
can use the two different urls to handle the two differnt cases ? I
haven't looked into the code in detail, but duplicating both the Registry
and the Factory might not be necessary.

Are there any problems with this approach ? If not, what are the set of
modifications I'll have to make to my setup to achieve this ?

If this is not possible, could someone confirm this for me and whether it
is at all possible to support 2 or more dbms ?

Thanks,
Shishir

On Wed, 2 Apr 2003, Brian Hills wrote:

> I have a couple of questions about the GDSF config file.
>
> 1. The GDSF documentation states that "more than one DBMS can be
> specified in a [GDSF] configuration file".
>
> Does this imply that one client can request a GDSF create a GDS to query
> one database (say Oracle) and another client can use the same GDSF to
> create another GDS to query another database (say MySQL)?
>
> 2. I have three databases specified in my GDSF configuration file. It
> appears when I run the client, OGSA-DAI attempts to use only the first
> specified DBMS in the GDSF file and ignores the others.
>
> For instance, in the included GDSF config file, I have configured
> Oracle, MySQL and Xindice dbs. If my client performs an Oracle query
> the results are returned ok. If I then use my client to issue a Mysql
> query, OGSA-DAI tries to use the Oracle database. When I swap the
> configuration around such that the Mysql database is configured first,
> results are returned for the Mysql query, but the Oracle query fails as
> it tries to use the MySQL db.
> Is this expected behaviour?
>
> Thanks
>
> Brian
>
> 

--
Date view Thread view Subject view Author view Attachment view