public void testInsertFilledDirectTransaction() throws Exception {
testInsertFilledRow("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
}
private void testEditingNullValues(String dsName, int mode) throws Exception {
DataSource d = ds.getDataSource(dsName);
Value v1 = ValueFactory.createValue(4);
Value v2 = ValueFactory.createNullValue();
Value v3 = ValueFactory.createValue("apellido");
Value v4 = ValueFactory.createValue(Date.valueOf("1998-09-05"));
Value v5 = ValueFactory.createValue(Time.valueOf("4:30:01"));
Value v6 = ValueFactory.createValue(Timestamp.valueOf("2005-09-05 4:30:01.666666666"));
d.beginTrans();
d.insertFilledRow(new Value[] {v1, v2, v3, v4, v5, v6});
d.setFieldValue(0, 1, ValueFactory.createNullValue());
d.commitTrans();
d.start();
assertTrue(((BooleanValue) d.getFieldValue(3, 0).equals(v1)).getValue());
assertTrue(((BooleanValue) ValueFactory.createValue(d.getFieldValue(3, 1) instanceof NullValue)).getValue());
assertTrue(((BooleanValue) d.getFieldValue(3, 2).equals(v3)).getValue());
assertTrue(((BooleanValue) d.getFieldValue(3, 3).equals(v4)).getValue());
assertTrue(((BooleanValue) d.getFieldValue(3, 4).equals(v5)).getValue());
assertTrue(((BooleanValue) d.getFieldValue(3, 5).equals(v6)).getValue());
d.stop();
}