Testing inserts over Mule JDBC transport to embedded HSQLDB, subsequent query returns no results

My test attempts to show that a SQL statement sent over a Mule JDBC outbound endpoint executes successfully. The problem: after inserting over Mule, querying the same table returns no results.

I'm using Spring JDBC to test the results of that statement.

In my setup method I create the schema with a DDL statement sent over Spring JDBC:

final JdbcTemplate _jdbcTemplate = new JdbcTemplate(new
SimpleDriverDataSource(new JDBCDriver(), "jdbc:hsqldb:mem:mydb"));

Mule JDBC outbound connector is also configured to point to jdbc:hsqldb:mem:mydb

<spring:bean id="myDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
    <spring:property name="driverName" value="org.hsq开发者_运维技巧ldb.jdbc.JDBCDriver"/>
    <spring:property name="url" value="jdbc:hsqldb:mem:mydb"/>
</spring:bean>

<jdbc:connector name="insertionConnector" dataSource-ref="myDataSource">
    <jdbc:query key="insertion"
                value="INSERT INTO mytable (TEST_KEY) VALUES (#[map-payload:_testkey])"/>
</jdbc:connector>

<custom-transformer name="objectFieldsToMap" class="com.mydomain.ObjectFieldsToMap"/>

<flow name="sendInsertion">
    <vm:inbound-endpoint address="vm://insert"/>
    <jdbc:outbound-endpoint queryKey="insertion" transformer-refs="objectFieldsToMap" connector-ref="insertionConnector"/>
</flow>

I verified that inserting a test row and querying for it using Spring JDBC both ways works.

I verified that sending the same insert statement over the outbound endpoint returns 1 row updated.

 final MuleClient muleClient = MyFactory.muleClient();
 final Date date = new Date();
 final MyObject myObject = new MyObject.Builder().setTestKey("test").build();

 muleClient.dispatch("vm://insert", myObject, null);

However, when I then query the same table using Spring JDBC I get an empty result set.

(String) _jdbcTemplate.queryForObject("SELECT TEST_KEY FROM MYDB.mytable", Class.forName("java.lang.String"));

Internally, Mule (using Apache DbUtils) commits after executing the statement so the insertion should be visible to subsequent queries. I am using the same JdbcTemplate object used to create the schema to then query for the results.

Help appreciated. Thank you.

---

Just to confirm, are you running Mule and your spring bean querying the table in the same JVM?