home list archives users mailing list
 

Subject: RE: "Invalid Oracle URL Specified?"

Date view Thread view Subject view Author view Attachment view

From: Braimah, AL \(Adam\) (a.l.braimah@dl.ac.uk)
Date: Aug 31, 2006 14:28

Hi,
They both look alright - there are colons and an '@' in the urls, but no
other punctuation.
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

Date view Thread view Subject view Author view Attachment view