tags:

views:

310

answers:

2

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

A: 

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.

Timo Westkämper
+2  A: 

This is a bit of self-marketing but I've been developing the ORMLite package that 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 very simple to get up to speed.

http://ormlite.sourceforge.net/

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

http://ormlite.sourceforge.net/javadoc/doc-files/ormlite_1.html#SEC1

I have experience with the org.xerial.sqlite-jdbc JDBC driver which seems to work very well. If you have any problems with the package, please let me know ASAP.

Gray
The project page says: `It is currently in Early Beta stage and needs testing/input, therefore it is not recommended for production use.` Is it correct?
htf
Oh I see. There is another ORMLite at Google code. Mine is hosted at Sourceforge at the URL http://ormlite.sourceforge.net/ and is production/stable.
Gray
Thanks for the reply, I got it now. Going to stick with ORMLite and in case any problems appear, I'm going let you know :)
htf
I'm getting this error in Eclipse `The type org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport cannot be resolved. It is indirectly referenced from required .class files` when trying to extend `BaseJdbcDao`. How can I fix it?
htf
I've fixed the last exception by adding Spring dependency (not very lightweight IMHO though). Seems to be working fine so far, thanks for making it)
htf
Removed the Spring dependency in the 2.0 version of ORMLite. Much better.
Gray