Hello,
as a beginning SQlite user, I'm trying to build a simple request counter for
a web site on top of SQlite (version 3.6.6.2). I started off with the
following simple and unfinished test code, which works fine on my home
computer (Ubuntu 9.04), but on our hosted server I always get an error code
of SQLITE_BUSY on sqlite3_prepare_v2(). I've seen others with similar
problems by googling, and the problem seems to be connected with mounted
filesystems. As I have no control over the host's environment there is
little I can do about the filesystem SQlite will run on. So the question is,
if the problem is with the filesystem, is there any way around it?
10 main() {
11
12 char input[500];
13 char *errormsg;
14 int exec_code;
15 sqlite3 *db;
16 sqlite3_stmt *query;
17 readstmnt(input); //reads a line of
input from user
18 exec_code=sqlite3_open_v2("test_db",
19 &db,
20 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE,
21 NULL);
22 printf("Eksekuutio koodi sqlite3_open_v2:sta oli %d\n", exec_code);
23
25 exec_code = sqlite3_prepare_v2(db, input, QUERY_LENGTH, &query,
NULL);
26 if(exec_code)
27 printf("Sqlite3_prepare_v2 meni pieleen koodilla %d\n",
exec_code);
28
31 exec_code = sqlite3_step(query);
32 printf("query suoritettu, koodilla %d\n", exec_code);
}
Thanks in advance,
-op
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
