To monitor a set of database tables for insertions or deletions during testing, specify a set of dbtable elements
List all the tables which need to be monitored during the tests.
The dbconnection and dbdriver strings are standard jdbc strings.
<database dbdriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver" dbconnection = "jdbc:micro+soft:sqlserver://dev0.adplates.co.uk:1433;DatabaseName=traffic;User=sa;Password=ren1920"> <dbTable name="Customers" identity="CustomerId"/> <dbTable name="Orders..Orders" identity="OrderId"/> <database>
The monitoring uses nested selects, so that many tables can be efficiently monitored at the same time. This requires a database which supports nested selects. Most databases support this, the most notable exception being MS Access.
dbtable -- Specifies details of a table to be monitored
Attribute Value(s) Default Value dbconnection The exact syntax is driver specific; it needs to specify the database and any non default parameters. CDATA #IMPLIED dbdriver
The name of the java class for the database. This class must lie within your classpath. CDATA
#IMPLIED password CDATA #IMPLIED user CDATA #IMPLIED
( dbtable ) *
testspec -- The root element of a xml test script.
Top Elements || All Elements || Tree