The latter is also shipped with Oracle Java as JavaDB. If you're building a desktop application in Swing and you want to use an embedded database, my suggestion would be to use a Java embedded database, like H2, HSQL or Derby. That is something you usually don't want. In order to use SQLite from Java, you would need to include the correct binary for the specific OS / architecture, effectively making a Java application platform-dependent. This one can be used on almost any Windows version (except Windows RT, maybe), but you cannot use it on Linux or OS X. If you look at the SQLite download page you'll notice there's a 32-bit pre-built Windows binary. Usually, Windows binaries are compatible over different Windows versions - as long as the architecture stays the same.

On Android, SQLite is used, but there the platform supplies a JDBC driver for it. Java is cross-platform and it would be a bit weird to have a platform-dependent dependency. Since SQLite is an embedded database for C-like environments, written in C and thus compiled to native code, changes that Hibernate (or any ORM) will support aren't really high. Hibernate configuration: hibernate.dialect = .SQLiteDialect Hibernate 5:Īuthor worked with Hibernate team to integrate it to the Hibernate directly.

Hibernate configuration: hibernate.dialect = There are several SQLite dialects out there.

Java sqlite