Dynamic creation of tables in sqlite locks the database?

I am using sqlite database for my application. When i create tables in it dynamically the app works fine for the first time but when I re start the app i can only read the earlier values that i inserted but no new values get inserted. there is nothing wrong with the c开发者_JAVA百科ode all finalize and all related statements are in place.

Any suggestion why it is happening, the sqlite is giving the error that the database is locked.

As many time mentioned:

"Open the database once at the start of your app, then close it in applicationWillTerminate of the AppDelegate. After every exec you will want to do a reset to clear the connection state."

1. so did you close your database at app quit?
2. try sqlite3_reset(stmt) befor finalize