We have an application which uses Microsoft SQL Server 2005 Extended
stored procedures in conjunction with Sqlite databases. We have a C++ DLL which
uses the following code to insert rows into a SQLite database:
sprintf(Command,"INSERT INTO [Keys] ([Key], [Cluster], "
"[DupeGroup]) VALUES (\"%s\", \"%*.*s\", %d)",
MCKey,BlockSize,BlockSize,MCKey,DupeGroup);
while (Keys->Execute(Command)==SQLITE_BUSY) {
#if defined(__unix)
sleep(dRETRYDELAY);
#else
Sleep(dRETRYDELAY*1000);
#endif
}
We use SQL Server 2005 Extended Stored Procedures and User Defined functions
in the following manner in order to insert into the SQLite table using the
above C++ code:
UPDATE MyTestDatabase SET
MatchKey = master.dbo.mdMUIncrementalBuildKeyEx(@Incremental, @Matchcode,
Column12, Column53, Column52, Address, NULL, NULL, NULL, NULL, NULL, NULL),
@RetVal = master.dbo.mdMUIncrementalAddRecord(@Incremental),
Status = master.dbo.mdMUIncrementalGetStatusCode(@Incremental),
DupeGroup = master.dbo.mdMUIncrementalGetDupeGroup(@Incremental)
When we run this UPDATE statement from two SQL Server 2005 Management
Studio clients concurrently, one of the client processes returns with the error
code Database is locked and the other client process is suspended. Has anyone
seen this problem? Is it a SQL Server 2005 problem or does it have anything to
do with Sqlite? In particular, we are wondering why we get the SQLite error
message "database is locked" when we are running concurrent SQL Server client
processes? When we run just one SQL Server client process, everything works
fine and we get no SQLite error messages. Thank you.
_________________________________________________________________
Bing brings you maps, menus, and reviews organized in one place.
http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
