0

As far as I know Hibernate doesn't work very well with sqlite, due to the lack of official provided "SqliteDialect". Is there any other JPA implementation works better with it?

zbdiablo
  • 919
  • 1
  • 9
  • 14
  • Similar to http://stackoverflow.com/questions/3045405/are-there-any-good-orms-preferably-jpa-implementations-that-support-sqlite-on Mentions Android but should still be applicable. – Robby Pond Feb 22 '11 at 14:24

2 Answers2

1

Take a look at OrmLite, a lightweight ORM tool for persisting java objects.

Bino Manjasseril
  • 112
  • 1
  • 6
  • 1
    It's not 100% JPA compliant though. Also see http://stackoverflow.com/questions/10187304/why-ormlite-has-its-own-annotations – sulai Mar 18 '13 at 10:18
0

Not sure what your goal is, but if you're looking for an embedded data storage library with JPA-style persistence, your best bet is using Berkeley DB Java Edition with the Data Persistence Layer API. There's an interesting article on how to convert SQL queries to the DPL here. Basically, using the DPL to access Berkeley DB Java Edition is about 10x faster than using Hibernate to access an RDBMS.

Disclaimer: I'm the product manager for Berkeley DB, so I'm a little biased. That said, we have lots of Java application developers who chose BDB JE because it's small, fast, scalable, reliable and the API is a natural fit for their application development environment.

Verbeia
  • 4,400
  • 2
  • 23
  • 44
dsegleau
  • 1,942
  • 9
  • 13
  • Thank you for you advice, and I will try Berkeley DB and DPL soon. – zbdiablo Feb 24 '11 at 07:42
  • And how about the overall size of Berkeley DB comparing to the other embedded database? – zbdiablo Feb 24 '11 at 07:49
  • @zbdiablo, Berkeley DB compiles in under a MB. That's much smaller than any of the RDBMS products. As someone said to me recently, "Transactions, Recovery, Replication and DPL in under a MB. Cool!" :-) – dsegleau Feb 24 '11 at 16:56
  • 2
    The second link doesn't seem to go to where you intend any more. – Verbeia Oct 16 '11 at 01:04