Hi folks,
I'm trying to setting EBean in my application that requires a small database to record contacts. I have the following condiguration for sqlite:
# specify the default/primary DataSource
datasource.default=sqlite
datasource.sqlite.databaseUrl=jdbc:sqlite:database/contacts.db
datasource.sqlite.databaseDriver=org.sqlite.JDBC
datasource.sqlite.username=sa
datasource.sqlite.password=
But when I try to run the application I get the following:
Caused by: javax.persistence.PersistenceException: java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and TRANSACTION_READ_UNCOMMITTED.
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.checkDataSource(DefaultServerFactory.java:482)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:170)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:123)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:63)
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:64)
at com.avaje.ebean.Ebean$ServerManager.getWithCreate(Ebean.java:225)
at com.avaje.ebean.Ebean$ServerManager.(Ebean.java:181)
at com.avaje.ebean.Ebean$ServerManager.(Ebean.java:147)
at com.avaje.ebean.Ebean.(Ebean.java:141)
I could not find any specific instruction to SQLite. Any tips here?
Thanks,
Eduardo Lopes.