home list archives users mailing list
 

Subject: RE: "Invalid Oracle URL Specified?"

Date view Thread view Subject view Author view Attachment view

From: Mike Jackson (michaelj@epcc.ed.ac.uk)
Date: Aug 31, 2006 14:15

Yes but in

GLOBUS/etc/ogsadai_wsrf/CCLRCDataServiceResource

Cheers,

mike

On Thu, 31 Aug 2006, Braimah, AL (Adam) wrote:

> Oh sorry, forgot to mention - I'm running this on the Globus WS Core
> container - should the same files be present?
> Ta,
> Adam
>
> -----Original Message-----
> From: Mike Jackson [mailto:michaelj@epcc.ed.ac.uk]
> Sent: 31 August 2006 14:11
> To: Braimah, AL (Adam)
> Cc: users@ogsadai.org.uk
> Subject: Re: "Invalid Oracle URL Specified?"
>
>
> Hi there,
>
> Check the
>
> TOMCAT/webapps/wsrf/WEB-INF/etc/ogsadai_wsrf/CCLRCDataServiceResource
>
> files dataResourceConfig.xml and DatabaseRoles.xml. These are the two
> files in which your Oracle URL will be listed. You should check that it
> looks OK. If your URL had an & in it you should replace this with &
>
> Cheers,
>
> mike
>
> On Thu, 31 Aug 2006, Braimah, AL (Adam) wrote:
>
>> I'm having no luck getting a simple SQL client to work. As far as I
>> can tell I've deployed a data service and data service resource
>> correctly, and linked them to an existing Oracle 10 database. To
>> confirm this I've run the listResourcesClient and had our DBA look
>> over my .properties file.
>> When I attempt to run a simple modification of the SimpleExample
>> included code with details as follows;
>> String handle =
>> "http://___.___.___.___:8080/wsrf/services/adamDS"; //IP removed for
>> this post
>> String id = "CCLRCDataServiceResource"; runClient fails
>
>> with the following errors
>> [java] Exception in thread "main"
>> uk.org.ogsadai.client.toolkit.exception.ServerException: Internal
> fault.
>> Consult the OGSA-DAI Service Provider with ID 1157026586527:13.
>> [java] at
>> uk.org.ogsadai.client.toolkit.exception.FaultToException.getServerExce
>> pt
>> ion(FaultToException.java:54)
>> [java] at
>> uk.org.ogsadai.client.toolkit.wsrf.WSRFDataService.perform(WSRFDataSer
>> vi
>> ce.java:550)
>> [java] at
>> uk.org.ogsadai.examples.clienttoolkit.SimpleExampleAB.main(SimpleExamp
>> le
>> AB.java:37)
>> while the server shows more faults than it's even willing to print in
>> full, but it finishes with
>> Caused by: java.sql.SQLException: Invalid Oracle URL specified
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
>> 11
>> 2)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
>> 14
>> 6)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
>> 20
>> 8)
>> at
>> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:538)
>> at
>> java.sql.DriverManager.getConnection(DriverManager.java:512)
>> at
>> java.sql.DriverManager.getConnection(DriverManager.java:171)
>> at
>> uk.org.ogsadai.dataresource.JDBCDataResourceAccessor.getConnection(JDB
>> CD
>> ataResourceAccessor.java:592)
>> ... 16 more
>>
>> I'm really at a loss on this so any help would be appreciated!
>> Thanks,
>> Adam
>
>

-------------------------------------------------------------------
Dr. Michael (Mike) Jackson E-mail: m.jackson@epcc.ed.ac.uk
EPCC Tel: +(44)-0131-650-5141
WWW: http://www.epcc.ed.ac.uk Fax: +(44)-0131-650-6555

Date view Thread view Subject view Author view Attachment view