Web Service and SOA Testing - the leaders- eviware

Main Menu

Home

Customer Area

Welcome, Guest. Please login or register.
November 22, 2008, 12:22:23 pm

Forgot your password?

Connection String for Oracle datasource

	Welcome, Guest. Please login or register. November 22, 2008, 12:22:23 pm

News: The Forums are up! Welcome to eviware.

Eviware Forum

soapUI

Connection String for Oracle datasource

« previous next »

Pages: [1]

Author

Topic: Connection String for Oracle datasource (Read 432 times)

Tareque
Newbie

Posts: 17

Connection String for Oracle datasource

« on: March 11, 2008, 03:33:49 pm »

Hi,
I am trying to create an Oracle datasource specifying the following
DriverClass
oracle.jdbc.pool.OracleDataSource
ConnectionString
jdbc:oracle:thin:@localhost:1571:dtwd;user=FAST;password=FASTER;

It fails giving SQLEXception invalid arguments in call.
I think that the ConnectionString format which i have given is incorrect, can you please provide the correct format for the ConnectionString for Oracle.
Thanks
Tareque


	Logged

Tareque
Newbie

Posts: 17

Re: Connection String for Oracle datasource

« Reply #1 on: March 11, 2008, 07:44:29 pm »

Hi Ole,
From an earlier post i found that we have to specify the url in the following format
jdbc:oracle:thin:scott/tiger@10.185.13.128:1521:ora9i

I have done the same now in my DataSource
jdbc:oracle:thin:FAST/FASTER@10.185.13.128:1521:dtwd
but i am getting IO error
Tue Mar 11 14:36:49 EDT 2008:ERROR:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

This is not a network issue as I am able to access the DB using a groovy script.
def sql = groovy.sql.Sql.newInstance("jdbc:oracle:thin:@10.185.13.128:1571:dtwd", "FAST", "FASTER", "oracle.jdbc.pool.OracleDataSource")
Can you please tell me how i can use this sql connection that I have created in the groovy script in the DataSource Step.


	Logged

omatzura
Administrator
Hero Member

Posts: 1,425

Re: Connection String for Oracle datasource

« Reply #2 on: March 12, 2008, 01:27:36 pm »

Hi Tareque,

hmm.. I don't really know why this isn't working when you use it in the DataSource step. What driver class have you specified in the JDBC DataSource configuration page? Can you send a screenshot of the entire config?

regards!

/Ole
eviware.com


	Logged

Tareque
Newbie

Posts: 17

Re: Connection String for Oracle datasource

« Reply #3 on: March 12, 2008, 02:40:56 pm »

Hi Ole,
The screen shot is attached. The driver class that i am using is
oracle.jdbc.driver.OracleDriver i also tried
oracle.jdbc.pool.OracleDataSource but that is giving me no suitable driver class found error.
Regards


	Logged

Pages: [1]

« previous next »