I am trying to use SQL Jet within my java application, but I consistently get
the following error when I run this section of code. For some reason I
cannot open this particular database. I can open up a separate database
with in my program, but this one always causes the error.
org.tmatesoft.sqljet.core.SqlJetException: Transaction wasn't started: error
code is MISUSE
public int getUserData(String module, int lesson) throws SqlJetException
{
ISqlJetTable table = userdb.getTable("lessonsCompleted");
try
{
userdb.beginTransaction(SqlJetTransactionMode.WRITE);
ISqlJetCursor cursor = table.lookup("lessonIndex",
module);
if (cursor.eof())
{
lesson = 1;
table.insert(module, 1);
}
else
{
lesson = (int) (cursor.getInteger("Lesson"));
cursor.delete();
table.insert(module, lesson);
}
}
finally
{
db.commit();
}
return lesson;
}
--
View this message in context:
http://old.nabble.com/Help-with-Transaction-Error.-tp27095659p27095659.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
