Edit Question - KnowledgeHub

Title Body

I'm developing an application that uses SQLite database and spring. I have problems when multiple threads try to modify the database - I get an error: 'The database file is locked' I have a single datasource configured: <bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" lazy-init="true"> <property name="driverClassName" value="org.sqlite.JDBC" /> <property name="url" value="jdbc:sqlite:sample.db" /> <property name="initialSize" value="2" /> <property name="maxActive" value="20" /> <property name="maxIdle" value="5" /> <property name="poolPreparedStatements" value="true" /> </bean> and in each thread I have a separate instance of the JdbcDaoSupport that performs an insert to the database: getJdbcTemplate().update( "insert into counts values(15)" ); The function that performs the database update is transactional (I've tried all isolation levels, in each case I get the same error). The same code works fine, when using other database (MySql). How can I solve this (without adding a 'manual' synchronization in my code)?

Tags (comma-separated) Cancel