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 <phu...@tsctech.com> 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
> WebTest@lists.canoo.com
> http://lists.canoo.com/mailman/listinfo/webtest
>

Reply via email to