Are there any good ORMs (preferably JPA implementations) that support SQLite (on Android)?

Question

I recently found a post that addresses a similar issue, but I think it is a bit outdated. I understand that the implementation of JPA is usually more related to the heavy / tight side, so if you know any light (non-JPA) ORM, I will certainly appreciate your input. I saw the answer to ActiveAndroid in another post, and I'm curious to know who tried it.

Update

In the end, I decided to go with an easier solution and chose DB4O . So far, I have been very pleased with my choice. It is extremely easy to use and requires minimal configuration. The website contains a wealth of information, including sample projects and an in-depth tutorial that covers almost everything a developer might need to know about DB4O. Oh, and I mentioned that it's free (unlike some other alternatives ... coughActiveDroidcough)?

Answer 1

As for the JPA implementation, for Hibernate there is at least a third-party Dialect for SQLite . I'm not 100% sure, but EclipseLink seems to be an option too (although SQLite is not officially supported ).

But for Android development, I would definitely check ActiveAndroid .

Just in case, here are a few other alternatives: jPersist , Ebean , Dreamsource ORM (see the TSS announcement ).

Answer 2

ORMLite is not fully compliant with JPA, but supports Sqlite on Android. It calls calls to the Android OS native database APIs to support ORM functionality. We have a large number of Android users who use it very successfully.

http://ormlite.com/sqlite_java_android_orm.shtml

Answer 3

BatooJPA is the only full-featured version of the JPA 2.0 specification. For mobile platforms, it is necessary to take into account the CPU consumption due to the lack of battery life of the processor, etc. BatooJPA is ideal when the full specification and processor resource is required. For the SQLite case, as far as you can provide a JDBC driver, Batoo JPA will do the rest.