Hi Paul, Thanks for the hints. Yeah, I know about the results file fiddling... Unfortunately this is exactly where I end up with a "different error" now, since webtest tells me
BUILD FAILED /opt/canoo/webtest.xml:371: input file /home/tklein/myWebTests/trials/sqlunit/results/WebTestOverview.xml does not exist Ouch. Seems like either webtest isn't able to xslt into the target file or "something" gets in between and is erasing it. Can that be sqlunit? I don't get that error when doing something else than sqlunit (e.g., testing a webpage title etc. works...). Thanks, Thomas Thomas Klein Senior Associate, QA | Sapient Sapient GmbH Hammer Str. 19 40219 Düsseldorf Deutschland Tel.: +49 211.54034-202 Mobil: +49 162.2773-202 Fax: +49 211.54034-600 e-Mail: [email protected] www.sapient.com Geschäftsführung: Dr. Christian Oversohl, Wolf Ingomar Faecks Handelsregister: Amtsgericht München HRB 161057, Sitz der Gesellschaft: München USt.-IdNr. DE-210831918 Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort die Sapient GmbH unter +49 89 552 987-0 und löschen Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail und der darin enthaltenen Informationen ist nicht gestattet. Vielen Dank. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email in error) please immediately notify Sapient GmbH on +49 89 552 987-0 and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your cooperation. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul King Sent: Wednesday, December 09, 2009 2:28 PM To: [email protected] Subject: Re: [Webtest] Full-qualified and complete sample for sqlunit I'll try to drag out the complete example from this page: http://webtest.canoo.com/webtest/manual/sqlunit.html It is the one with the "${some.dir}/${some.file}" references but if I can find the original project I can give you all the values. The main thing to realize is that you are using sqlunit as per its normal usage pattern (described by its doco) but you need to change the log format to be canoo and point the logfile to the one which webtest is currently sending results to. These days we tend to write most of our WebTest tests using Groovy and use Groovy's database facilities for db access - though I can see the attraction of the declarative XML in some cases too. Cheers, Paul. P.S. It isn't on my current laptop, so I will need to hunt around on the work server when I get a chance, i.e. might take a day or two. Alternatively, ask some more questions about the example in the doco and I might be able to point you in the right direction without the complete project. Thomas Klein wrote: > Hi all, > > I'm struggeling to get sqlunit "integrated" with WebTest. > > Although being a "seasoned" QA person with quite some portfolio on automation > and testing frameworks and stuff, I am new to WebTest and completely new to > Ant and sqlunit. I just need to understand how to make up the LINK between > all the parts. > > I went through the samples on both sqlunit and webtest websites (not to > mention the mailman list and google results) but still fail to understand...: > - which files are required with sqlunit (not the software install but rather > for my tests) > - where must I place which file and what do they contain? > (dtd, xml, properties, configs, sql statements,...) > > Or, to tell a long story short: > Is there some sample project available that does a simple > - connection to a db > - execute sql statements > > ...and which has "fully-qualified" references instead of > "${some.dir}/${some.file}" ? ;) > > TIA for any pointers, cheers, > Thomas _______________________________________________ WebTest mailing list [email protected] http://lists.canoo.com/mailman/listinfo/webtest
