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:10

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.getServerExcept
> ion(FaultToException.java:54)
> [java] at
> uk.org.ogsadai.client.toolkit.wsrf.WSRFDataService.perform(WSRFDataServi
> ce.java:550)
> [java] at
> uk.org.ogsadai.examples.clienttoolkit.SimpleExampleAB.main(SimpleExample
> 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(JDBCD
> 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