header
header
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:
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
Home Help Search Login Register
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] Print
Author Topic: My first Groovy SQL script in SoapUI - connection string  (Read 341 times)
John Overbaugh
Newbie
*
Posts: 16


« 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


« 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


« Reply #2 on: December 14, 2007, 12:57:59 am »

Ole thanks. This got me running!
Logged
Pages: [1] Print 
« previous next »
Jump to:  


Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
header header
header
header