I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load....(and even more by My JMeter Tests)....... But on my production environment (Linux CentOS)... with 3 concurrent access (CTRL+F5 on diferent Chrome Tabs/3 times)....... my web app hang with message "Sqlite Blocked.." I'm using exactly same versions on both environments....(for Java, Sqlite JDBC, Resin, App. Pooling, etc......) I know that jdbc pooling is trivial on sqlite (just one user at time can update the DB).... but in Win XP. it's running fine.... Why ? On My Test Page...... i'm doing some just SELECT statement... (no insert, no delete, no update, no ddl).... Sorry for my Bad English....
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users