What is the simplest Java ORM supporting Sqlite?

Question

What is the ORM that can bound to a Java application in the least possible time, given its performance is not important?

Answer 1

This is self-marketing but my ORMLite package has native support for Sqlite – as well as MySQL, Postgres, Microsoft SQL Server, H2, Derby, and HSQLDB. It uses annotations to configure the persisted classes and is simple to get up to speed.

Here is the online docs on how to get started with the package:

I have experience with the org.xerial.sqlite-jdbc JDBC driver which seems to work very well.

Answer 2

SQLite is fully supported by jOOQ.

Answer 3

Sormula works with any relational database since it creates standard SQL. Sqlite test configuration and jdbc driver are included in the test suites.

Answer 4

Here is a demo project for Hibernate SQLite integration. EclipseLInk JPA should also work. EclipseLink is lighter than Hibernate, but Hibernate is better documented and more mature.