Eviware Forum

soapUI => soapUI => Topic started by: Martin Schlede on January 10, 2008, 11:27:42 pm



Title: Data Sink
Post by: Martin Schlede on January 10, 2008, 11:27:42 pm
I thougt I could use Data sink for a small change in my Database before executing a test step, so I tryed 'JDBC' connect.
Maybe I should better use a groovy skript, but anyway...

Driver: oracle.jdbc.driver.OracleDriver
Connection String: jdbc:oracle:thin:@127.0.0.1:1521:TEST
doesn't work.
(Error: java.sql.SQLException: Invalid arguments in call)
How can I set username and password for this connection?


Title: Re: Data Sink
Post by: omatzura on January 11, 2008, 12:14:21 pm
Hi!

the general format for the oracle connection string is

jdbc:oracle:<drivertype>:<username/password>@<database>

so you should be able to specify the username/password as follows

jdbc:oracle:thin:username/password@127.0.0.1:1521:TEST

Hope this helps!

regards,

/Ole
eviware.com


Title: Re: Data Sink
Post by: Martin Schlede on January 11, 2008, 03:45:46 pm
Works perfect.
Many thanks!  :)