sqliteÖ®Database is lockedÎÊÌâ
»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨ÍêÕû°²×°µÄQNX6.3.2ÉÏ£¬Ã»ÓÐÎÊÌ⣬µ«ÊÇÔËÐл·¾³ÊDzüô¹ýµÄ£¬¾ßÌå²Ã¼ôÄÚÈݲ»Ïê¡£
¶àл£¡£¡ ¿à˼ÊýÈÕ£¬ÎÞ¿ÉÄκΡ£
¸Õ½ÓÊÖSQLiteÒ²²»¶®£¬ÓÑÇé°ï¶¥£¡
£¬ÓÑÇé°ï¶¥£¡
{{
Ïà¹ØÎÊ´ð£º
C# code:
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......
ÇódelphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
ÓÃASqlite3Query,ÉèÖÃËûµÄconnectionΪASqlite3DB
ASqlite3Query.Sql.text := 'insert into ....';
ASqlite3Query.Execsql;
sqlstr:='insert into stude ......
ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '200 ......
ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£
ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......
ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite;
¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn;
¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË.
The type 'System.Data.Common.DbConnection' is defined in an ass ......