var Types = java.sql.Types;
var tabledef = [
{name: "id", type: Types.INTEGER},
{name: "name", type: Types.VARCHAR},
{name: "description", type: Types.VARCHAR},
{name: "createtime", type: Types.TIMESTAMP}
];
function setup() {
var dbmgr = new jala.Test.DatabaseMgr();
var db = dbmgr.initDatabase("testdb");
// var db = new jala.db.RamDatabase("testdb");
db.createTable("person", tabledef, "id");
db.createTable("animal", tabledef, "id");
db.createTable("item", tabledef, "id");
}
createTable(table, columns, key) demo data that triggers error for me
table T_ACCESS
table.columns [{name:"ACC_ID", type:3, length:10, nullable:false, 'default':null, precision:0, scale:10}, {name:"ACC_F_GRP", type:3, length:10, nullable:true, 'default':null, precision:0, scale:1
0}, {name:"ACC_F_SIT", type:3, length:10, nullable:true, 'default':null, precision:0, scale:10}, {name:"ACC_PERMISSION", type:3, length:10, nullable:true, 'default':null, precision:0, scale:10}, {name:"ACC_CREATETIME", type:91, length:7,
nullable:true, 'default':null, precision:0, scale:10}, {name:"ACC_F_USR_CREATOR", type:3, length:10, nullable:true, 'default':null, precision:0, scale:10}, {name:"ACC_MODIFYTIME", type:91, length:7, nullable:true, 'default':null, precis
ion:0, scale:10}, {name:"ACC_F_USR_MODIFIER", type:3, length:10, nullable:true, 'default':null, precision:0, scale:10}, {name:"ACC_F_ZNE", type:3, length:10, nullable:true, 'default':null, precision:0, scale:10}]
table.keys ["ACC_ID"]