I knew what I was doing wrong:
tx.executeSql('INSERT INTO SESSION (id ***unique***, dayId, subject, Seq) VALUES (1, 4, "English", 1)');
I shouldn't have written the type in the insert statement too ... so when I deleted it, it worked fine.
source share