Getting [SQLITE_BUSY] database file is locked with select statements

by

After some googling I found that it is a bad practice to use multiple connections when connecting to SQLite. See

http://touchlabblog.tumblr.com/post/24474398246/android-sqlite-locking

Set your poolsize maxactive to 1 and try out.

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  3. What is the solution for the N+1 issue in JPA and Hibernate?
  4. Confusion: @NotNull vs. @Column(nullable = false) with JPA and Hibernate
  5. What is “the inverse side of the association” in a bidirectional JPA OneToMany/ManyToOne association?
  6. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  7. what is @JoinColumn and how it is used in Hibernate
  8. How can I get the session object if I have the entity-manager?
  9. No Dialect mapping for JDBC type: 1111
  10. Hibernate one-to-one: getId() without fetching entire object
  11. Difference between @OneToMany and @ElementCollection?
  12. What is the difference between CascadeType.REMOVE and orphanRemoval in JPA?
  13. @GeneratedValue polymorphic abstract superclass over MySQL
  14. Transaction marked as rollback only: How do I find the cause
  15. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  16. How to map the result set of a JPA NativeQuery to a POJO using SqlResultSetMapping
  17. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  18. Hibernate generates negative id values when using a sequence
  19. How to prevent SQL Injection with JPA and Hibernate?
  20. Specifying an Index (Non-Unique Key) Using JPA
  21. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  22. IN-clause in HQL or Java Persistence Query Language
  23. @Id @GeneratedValue but set own ID value
  24. How to set the timeout period on a JPA EntityManager query
  25. The onFlushDirty Hibernate Interceptor method is never called
  26. spring data jpa @query and pageable
  27. Hibernate throws strange error: Class is not mapped
  28. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment