Edit Question - KnowledgeHub

Title Body

If I run multiple threads against my web app I get: java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked) at org.sqlite.DB.newSQLException(DB.java:383) at org.sqlite.DB.newSQLException(DB.java:387) at org.sqlite.DB.execute(DB.java:339) at org.sqlite.PrepStmt.executeQuery(PrepStmt.java:75) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) I do know that only one thread can write to a sqlite database but I'm only reading from the database. So why do I get this error message ? BTW: My connection pool looks like this: <bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource"> <property name="driverClassName" value="${database.driverClassName}" /> <property name="url" value="${database.url}" /> <property name="username" value="${database.username}" /> <property name="password" value="${database.password}" /> <property name="initialSize" value="1" /> <property name="maxActive" value="2" /> <property name="maxIdle" value="1" /> <property name="poolPreparedStatements" value="true" /> </bean> The setup is: Java 1.6, Tomcat 7.0.34, Spring 3.2, Hibernate 3.6.9 and sqlite3 3.7.2 Regards Roger

Tags (comma-separated) Cancel