public void testRowCountDirectTransaction() throws Exception {
testRowCount("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
}
private void testInsertAt(String dsName, int mode) throws Exception {
AlphanumericDataSource d = (AlphanumericDataSource) 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.insertFilledRowAt(2, new Value[] {v1, v2, v3, v4, v5, v6});
assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
assertTrue(((BooleanValue) d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());
assertTrue(((BooleanValue) d.getFieldValue(2, 0).equals(ValueFactory.createValue(4))).getValue());
assertTrue(((BooleanValue) d.getFieldValue(3, 0).equals(ValueFactory.createValue(2))).getValue());
d.commitTrans();
}