This sample uses JDBC database connection to verify stored data in SQL query results sets.
The todo-list sample application stores data to a relational database. This sample shows
the usage of database JDBC validation actions in Citrus. We are able to execute SQL statements on a database target.
See the reference guide database chapter for details.
The database source is configured as Spring datasource in the application context citrus-context.xml.
As you can see we are using a H2 in memory database here.
Before the test suite is started we create the relational database tables required.
After the test we delete all test data again.
In the test case we can reference the datasource in order to access the stored data and
verify the result sets.
You can run the sample on your localhost in order to see Citrus in action. Read the instructions how to run the sample.