Untitled

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"]