Monday, May 17, 2010

NHibernate 2.1 with SQLite

There is an error in the default configuration file that comes with NHibernate. It recommends the Driver Class :
"NHibernate.Driver.SQLiteDriver" in the hibernate.cfg.xml file. This referes to the SQLite Driver found at:
http://sourceforge.net/projects/adodotnetsqlite/
Wrongly (I believe) mentioned at : http://community.jboss.org/wiki/DatabasessupportedbyNHibernate
This version is no longer valid. The new (and awesome) version is http://sqlite.phxsoftware.com/
For this you will need to specify in the configuration "NHibernate.Driver.SQLite20Driver"

PS: cool link: http://devlicio.us/blogs/krzysztof_kozmic/archive/2009/08/14/testing-with-nhibernate-and-sqlite.aspx

Enjoy!