Use jdbc-temaple instead of jdbc-inbound endpoint in integration tests to insert testdata into export tables

Today integration tests use jdbc-inbound endpoints to insert testdata into 
export tables like:

        String inboundEndpoint = "jdbc://INSERT INTO FROM_JEEVES_EXPORT_TB(ID, VALUE) VALUES ('" + inId + "', '" + inValue + "')?connector=soitoolkit-jdbc-connector";
        MuleMessage reply = dispatchAndWaitForServiceComponent(inboundEndpoint, input, props, receivingService, timeout);

This however only works for very simple testdata, eg not for xml. 

A very simple improvement would be to replace it with a jdbc-template solution 
for example:

        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        jdbcTemplate.update("INSERT INTO FROM_JEEVES_EXPORT_TB(ID, VALUE) VALUES(?, ?)", new Object [] {inId, inValue});
        MuleMessage reply = waitForServiceComponent(receivingService, timeout);

Original issue reported on code.google.com by magnus.l...@gmail.com on 17 Dec 2012 at 7:22

cmoutes / soi-toolkit

Use jdbc-temaple instead of jdbc-inbound endpoint in integration tests to insert testdata into export tables #320