Hi,
Yes Canoo webtest provides access to database. You can connect to your
database through Canoo in the following way.
1. Make sure that your Canoo framework contains dbunit-2.2.jar and
sqlclient jar.
2. you can make use of following tags to retreive a user from database in a
xml file:-
<dbunit
driver="com.sybase.jdbc3.jdbc.SybDriver"
url="jdbc:sybase:Tds:${idb_host}:${idb_port}/${idb}"
userid="${idb_user}"
password="${idb_password}">
<export dest="../expected/test.xml">
<query name="FOO" sql="select * from abc where
abc_code='${xyz}'"/>
</export>
</dbunit>
This tag will execute the SQL statement and create a xml file in the
expected directory which contains the result of the sql statement.
Hope this helps ...!!
Cheers!!
Hitesh
On Thu, Feb 19, 2009 at 7:46 PM, Phumza Zuba <[email protected]> wrote:
> Hi All
> Please help
> Using Canoo webtest, are there any tags that i can use to connect to the
> database, or can i connect to the database to retrieve a user
> information with an xml script?
> using which tags?
> thanks
> Phumza
>
> _______________________________________________
> WebTest mailing list
> [email protected]
> http://lists.canoo.com/mailman/listinfo/webtest
>