@Test public void testAutoincrement() throws Exception { ISqlJetTableDef createTable = db.createTable( "CREATE TABLE `JOBLIST` (" + "`id` INTEGER PRIMARY KEY AUTOINCREMENT," + "`jobname` VARCHAR(75) NOT NULL," + "`startdate` LONG not null" + ");"); final ISqlJetTable table = db.getTable(createTable.getName()); db.beginTransaction(SqlJetTransactionMode.EXCLUSIVE); try { table.insert(null, "jobname", 123456); table.insert(null, "jobname", 123456); } finally { db.commit(); } db.runReadTransaction( new ISqlJetTransaction() { public Object run(SqlJetDb db) throws SqlJetException { ISqlJetCursor open = table.open(); try { while (!open.eof()) { long id = open.getInteger("id"); Assert.assertNotNull(id); open.next(); } } finally { open.close(); } return null; } }); }