Contact Us
About Us
News
Home
Main Menu
Home
Eviware Store
Downloads
Products
News
Forum
Eviware Blog
Search
FAQs
Customer Area
Support
Documentation
Tutorials
CookBook
Downloads
Forum
Login Form
Welcome,
Guest
. Please
login
or
register
.
December 04, 2008, 11:27:06 pm
Username:
Password:
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Forgot your password?
My first Groovy SQL script in SoapUI - connection string
Welcome,
Guest
. Please
login
or
register
.
December 04, 2008, 11:27:06 pm
News:
The Forums are up! Welcome to eviware.
Eviware Forum
soapUI
soapUI
My first Groovy SQL script in SoapUI - connection string
« previous
next »
Pages:
[
1
]
Author
Topic: My first Groovy SQL script in SoapUI - connection string (Read 341 times)
John Overbaugh
Newbie
Posts: 16
My first Groovy SQL script in SoapUI - connection string
«
on:
December 11, 2007, 10:41:10 pm »
I got my hands on "Groovy in Action" and have been trying to follow the example in the book for connecting to a database. So far, here's my script (I ahve modified server, username, and password info of course):
import groovy.sql.Sql
db = Sql.newInstance('jdbc:oracle:thin:@server:1604:a237', 'username', 'password', 'oracle.jdbc.OracleDriver')
When I run the script, though, I get an error
Tue Dec 11 14:27:18 MST 2007:ERROR:java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
I followed the user documentation and 1) made sure there was a load command in the groovy-starter.conf file and 2) dropped the Oracle SQL .jar file into the Groovy lib folder.
Any help getting this going would be much appreciated. Niclas has been great--I'm pushing ahead through data-driven tests with his help and this is one of the last steps to my initial test suites.
Thanks
John O.
Logged
omatzura
Administrator
Hero Member
Posts: 1,506
Re: My first Groovy SQL script in SoapUI - connection string
«
Reply #1 on:
December 11, 2007, 10:48:05 pm »
Hi John,
you need to put the oracle jar in the soapui\bin\ext folder, then make sure that it gets picked up by soapUI when restarting; the soapui log will contain a row looking somewhat like:
22:46:30,641 INFO [SoapUI] Added [file:/C:/workspace/soapui-pro/ext/XXX.jar] to classpath
Hope this helps!
regards,
/Ole
eviware.com
Logged
John Overbaugh
Newbie
Posts: 16
Re: My first Groovy SQL script in SoapUI - connection string
«
Reply #2 on:
December 14, 2007, 12:57:59 am »
Ole thanks. This got me running!
Logged
Pages:
[
1
]
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> eviware general
-----------------------------
soapUI
-----------------------------
=> soapUI
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Powered by SMF 1.1.2
|
SMF © 2006-2007, Simple Machines LLC
Loading...