Hi Luke,

pls make sure you have the jar file that contains com.microsoft.jdbc.sqlserver.SQLServerDriver.class in your <Ant-install-dir>/lib directory. I guess it is one of Msbase.jar or Msutil.jar

happy testing Dierk -----Original Message----- From: webt...@lists.canoo.com [mailto:webt...@lists.canoo.com]On Behalf Of Luke...@exeloncorp.com Sent: Donnerstag, 23. August 2007 20:05 To: webt...@lists.canoo.com Subject: [Webtest] Ant SqlTask and Webtest

I'm trying to run the sql test from a webtest, using the MSSql JDBC driver for SQL 2000. However I keep getting a "Class Not found".

I've defined a classpath env. variable pointing to where the drivers downloaded.

My test looks like:

<target name="main" >

<webtest name="database" >

<steps>

<sql

driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"

url="jdbc:microsoft:sqlserver://Server:1433;DatabaseName=dbname"

userid="userid"

password="validPword" >

Insert into table

The error msg:

INFO (com.canoo.webtest.steps.Step) - Running with: Canoo Webtest: R_1581.

INFO (com.canoo.webtest.steps.Step) - Exception thrown from this class: org.apache.tools.ant.BuildException

INFO (com.canoo.webtest.steps.Step) - Message was: Class Not Found: JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDriver could not be loaded

ERROR (com.canoo.webtest.steps.Step) - Cannot handle unexpected exception in ste

p TestStepSequence at C:\DOCUME~1\XXXX\MYDOCU~1\Tests\webtestRoutines\webtest

Routines\databaseTest.xml:19: with (taskName="steps")

C:\DOCUME~1\XXXXX\MYDOCU~1\Tests\webtestRoutines\webtestRoutines\databaseT est.

xml:24: Class Not Found: JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDrive

r could not be loaded

at org.apache.tools.ant.taskdefs.JDBCTask.getDriver(JDBCTask.java:366)

at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)

at org.apache.tools.ant.Task.perform(Task.java:364)

at com.canoo.webtest.ant.TestStepSequence.executeSteps(TestStepSequence.java:43 )

at com.canoo.webtest.ant.TestStepSequence.doExecute(TestStepSequence.jav

..

Any solutions?

Luke Templin

************************************************** This e-mail and any of its attachments may contain Exelon Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Exelon Corporation family of Companies. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. Thank You. **************************************************

>