iam workin on an application that calculate the income for certain diving centers, i using the SQLite database, i developed a database with 3 table the first one for user input, the second is to hold daily income, and the third for weekly income.
i've a problem when i'm trying to write in the second table the income after each user input, here's the exception when i'm using the Statement object
stmnt.execute("UPDATE dailyIncome SET Credit_NIS = '"+nis+"'");
java.sql.SQLException: database locked
and the following one is when i'm using the prepared statement
PreparedStatement pre = con.prepareStatement("UPDATE dailyIncome SET Credit_NIS = ? WHERE Date_PK = ?");
java.sql.SQLException: cannot commit transaction - SQL statements in progress
i need to know why this problem occured and how to solve it???
Thanks in advance.