Maven Dbunit Plug-in Settings

http://maven-plugins.sourceforge.net/maven-dbunit-plugin/properties.html

 

Maven Dbunit Plug-in Settings

This is a summary of the plugin's supported dbUnit properties. Refer to the dbUnit ant task properties page for more details.

 

Property Optional? Description Default Value

maven.dbunit.deleteType	Yes	DbUnit operation type for delete.	DELETE
maven.dbunit.driverClassName	Yes	The class name of the JDBC driver to be used.	(none)
maven.dbunit.format	Yes	Format for the import/delete functionality. Alternatively you could specify flat or csv .	xml
maven.dbunit.doctype	Yes	If set and format is "flat", add DOCTYPE declaration referencing specified DTD to exported dataset. The DTD path can be absolute or relative.	(none)
maven.dbunit.importType	Yes	DbUnit operation type for import. Other valid values are: UPDATE, INSERT, DELETE, DELETE_ALL, REFRESH, CLEAN_INSERT, MSSQL_INSERT, MSSQL_REFRESH, MSSQL_CLEAN_INSERT	INSERT
maven.dbunit.password	Yes	The password of the user connecting to the database.	(none)
maven.dbunit.schema	Yes	The schema name that tables can be found under.	(none)
maven.dbunit.url	Yes	The JDBC URL for the database to access, e.g. jdbc:db2:SAMPLE .	(none)
maven.dbunit.user	Yes	The user name used to connect to the database.	(none)
maven.dbunit.datatypeFactory	Yes	Set the DataType factory to add support for non-standard database vendor data types.	dbUnit's default value
maven.dbunit.useQualifiedTableNames	Yes	Enable or disable multiple schemas support by prefixing table names with the schema name.	false
maven.dbunit.transaction	Yes	Wrap the operation in a single transaction or not.	false
maven.dbunit.dest.dir	Yes	Directory to write the exported data file to.	${maven.build.dir}/dbunit
maven.dbunit.dest.file	Yes	File name of the exported data file.	${maven.dbunit.dest.dir}/all.xml
maven.dbunit.table.list	Yes	Delimeter separated list of table names (see maven.dbunit.table.list.delim). Currently only used in generate-dataset to list the tables to export all data from (if tables or queries are not specified, exports all data from all tables). For example: table1,table2,table3	(none)
maven.dbunit.table.list.delim	Yes	Table name delimeter for list of tables specified in maven.dbunit.table.list.	, (comma)
maven.dbunit.query.list	Yes	Delimeter separated list of query names (see maven.dbunit.query.list.delim). Currently only used in generate-dataset to list the queries to use to export specific data from (if tables or queries are not specified, exports all data from all tables). For example: qry1,qry2,qry3 For every query listed, it expects 2 additional properties: (queryname).name Name to use to refer to the sql statement. (queryname).sql SQL to execute to select the data for export. For example, to pull the rows from COMPANY and PERSON tables for a user_id field of "dbunit": maven.dbunit.query.list=company,person company.name=COMPANY company.sql=select * from person where user_id = 'dbunit' person.name=PERSON person.sql=select * from person where user_id = 'dbunit'	(none)
maven.dbunit.query.list.delim	Yes	Query name delimeter for list of queries specified in maven.dbunit.query.list.	, (comma)
maven.dbunit.verbose.level	Yes	The level of runtime messages to display. Valid values: 0 Specify minimum messages. 1 Specify medium level messages (e.g. summary info). 2 Specify detailed level messages (e.g. debug)