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\databas
eTest.
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.jav
a: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.
**************************************************
