sqlite-jdbc icon indicating copy to clipboard operation
sqlite-jdbc copied to clipboard
verified publisher icon xerial

Table locked after query sqlite_master

Open jianlins opened this issue 8 years ago • 1 comments

Hello, I got an table locked error after query sqlite_master. For instance, I tried "SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='INPUT_TABLE'", then the table "INPUT_TABLE" is locked. And I cannot execute "DROP TABLE INPUT_TABLE".

I tried this on sqlite shell, there is no error in shell. So I guess this is due to the jdbc.

Thanks

jianlins avatar Jul 23 '17 18:07 jianlins

Is this still happening on the latest version?

gotson avatar Jul 29 '22 05:07 gotson