Hi, Just wanted to say we have the same issue, using sqlite v3.6.15 (not java) running on *some* windows vista machines accessing databases on *some* networked drives. I don't think this is an sqlite problem, because vista is obviously randomly locking files and this can be seen when using microsoft word or excel. Occasionally these programs report that the files are in use and open them as read-only, when in fact they are not. Reopening the file always makes the errors go away.
With our sqlite program, we also see these errors occur - typically we get SQLITE_BUSY (the file is locked) errors compiling or executing statements, but as you said, the errors are random. Some statements accessing a database will work, and then another statement accessing the same database will fail a second later. Exiting our application and restarting it makes the problem go away for a while. If you find any vista OS patches that solve this problem, please let me know, we are looking ourselves in the hopes that microsoft has resolved this issue.. thanks, Serena. ----------------------------------------- Ferdinand wrote: Hi, we have a java application ( with sqlitejdbc-v056/windows vista) which runs only once on every PC to fill a new database. On most machines everything works perfectly, but on some machines the application fails with either "Unable to open database file" or " disk I/O error". The database is of course there . This errors occur on different locations in the code(with execute() or executeBatch()), even when previous calls to this functions were successfull.. In most cases the problems vanish when we run the apllication again (but this is not really an option we have). I searched the internet and found that this errors might be caused by locks on temporary files(we run Kaspersky Anti Virus on every machine) Are there any other explanations for this behaviour? Thanx Ferdinand Krämer _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users