Java – SQLite and hibernate – good idea?
I am using java hibernate to develop a small desktop application I am using MySQL for development, but I want to replace it with SQL version
>Avoid @ r_ 403_ 1638 @ installation and configuration This will allow my client to install and configure the application itself. > Simplify DB backup and restore. > etc.
I am here http://code.google.com/p/hibernate-sqlite/ Found sqllite dialect, its configuration, and a working example eclipse project (using hibernate 3)
But when I read the comment on a question: "because SQLite database is widely used and it is not supported by hibernate in Java, it is not easy to use SQLite and hibernate." I am very afraid
Can you advise me - is that a good idea? What alternative SQLite is a good support for Hibernate?
Solution
I think every DB there has advantages and disadvantages For embedded databases, you can also view HSQLDB or h2db