What: 'conf.dbunit' is the category of a resource which role is to configure DbUnit transactions
What: 'conf.dbunit.ppk' is the category of a resource that represents a pseudo-primary key filter for DbUnit transactions. The file format is as follows: for each table, define a property with the name of the table. The value of the property is the comma-separated list of the names of the columns that make up the primary key.
Why: Usually DbUnit reads directly from the database information about the tables it needs to know, including their primary keys. However some tables simply have no primary key, which can lead DbUnit to failures for a few operations. The 'conf.dbunit.ppk' is a way to provide DbUnit with these extra information.
Note: If a primary key exists whereas a pseudo primary key is defined, the pseudo primary key overrides the primary key.
What: 'dataset.dbunit' is the category of a resource that represents a DbUnit DataSet.
What: 'filter.dbunit' is the category of a resource that represents a Dbunit Filter. These filters are used in assertions for comparison between DbUnit datasets ('dataset.dbunit'). Their purpose is to exclude / include from the comparison some tables or some column if you need to narrow the scope of your assertion.
How to use it?
What: 'parameter.named.sql' is the category of a resource that represents a map of parameters for parameterized sql queries using named parameters (see 'query.sql')
What: parameter.indexed.sql is the category of a resource that represents a list of parameters for parameterized sql queries using positional parameters (see 'query.sql').
What: 'query.sql' is the category of a resource that represents a query written in SQL. It can be parameterized either using named parameters or positional (indexed) parameters.
Since the parameters are identified by name, they can be passed in any order (they are matched by name).
Since the parameters are identified by their position relative to each others, the order in which they are passed in does actually matter (they are matched by their position).
What: 'result.sql' is the category of a resource that represents the result of a sql query (or 'query.sql' in TA).
Category-name: script.sqlWhat: 'script.sql' is the category of a resource that represents a script written in SQL. They aren't meant to read data, rather to perform massive operations in bulk like insertion or manipulation of the structure of the database