ExpandCollapse Setup jdbcSlim import six42.fitnesse.jdbcslim define table type SQLCommand as Table ExpandCollapse Driver specific setup classpath: ./plugins/jdbcslim/derby.jarvariable defined: BeginTransaction=commit /* Begin Transaction */ Define Properties TestDatabase key value jdbcDriver org.apache.derby.jdbc.EmbeddedDriver DBURL jdbc:derby:memory:myDB;create=true DBUSER na DBPASSWORD na dbAutoCommit true CMD ExpandCollapse Create database and add data Define Properties TransactionDatabase key value .include TestDatabase dbconnection WithTransaction dbAutoCommit false Define Properties StartupDatabase key value .include TestDatabase dbconnection init Script SQLCommand StartupDatabase openConnection #execute drop table if exists TestData #show success #show rawResult #show resultSheet execute create table TestData (Id varchar(3), Name varchar(255), Phone varchar(255), City varchar(255), Profession varchar(255)) show success show rawResult show resultSheet SQLCommand StartupDatabase insert into TestData values ('%Id%', '%Name%', '%Phone%', '%City%', '%Profession%') Id City Name Phone Profession 1 Berlin Bill 12345 Doctor 2 Denver Ben 6789 Artist 3 Seoul Tom 4567890 Milkman 4 Berlin Till 332211 Senator 5 Paris Sarah 999999 Hero 6 London James 5432 Butler 7 Washington Bert 432 President 8 New York Kim 1 Banker SQLCommand StartupDatabase select * from TestData Query ID Name Phone City Profession 1 Bill 12345 Berlin Doctor 2 Ben 6789 Denver Artist 3 Tom 4567890 Seoul Milkman 4 Till 332211 Berlin Senator 5 Sarah 999999 Paris Hero 6 James 5432 London Butler 7 Bert 432 Washington President 8 Kim 1 New York Banker Script SQLCommand StartupDatabase closeConnection