Hello Nhibernate/Sqlite3 users !

As you may have heard "SQLite ADO.Net Provider" the initial project providing an ADO.NET driver for Sqlite is discontinued.

Instead, a new project sqlite-dotnet2 have started and keep providing nice ADO.NET driver.

As of today, Nhibernate only provides built-in support for the "SQLite ADO.Net Provider" driver which does not support Sqlite 3 ! Hopefully, "sqlite-dotnet2" does.

Ok long story short, you may find in the JIRA issue NH-846 the code (dll + source to use Sqlite 3 + Nhibernate 1.0.3 + sqlite-dotnet2.

The first patch seems to be Nhibernate 1.2 specific and doesn't work for 1.03. So I changed the original code (written by Ioan Bizau).

In the zip, you will find :
- the visual studio 2005/2003 project
- the code (yeah)
- debug and release dlls for .net 2.0 and .net 1.1

I've tested it with the following feature
- autoincrement
- BOOLEAN and DATE fields.

Bye,
Bertrand.

[url][/url]

I would like to move from using the discontinued Finsar driver to this new sqlite-dotnet2 one.

However, we're still on .NET 1.1.

I've downloaded the zip, and have replaced my references to NHibernate and the Finsar ADO provider with references to the new (1.0.3) NHibernate DLL and NHibernate.SQLite20.dll i.e. where I previously had:

NHibernate
SQLite.NET

as references, I've now got:

NHibernate (version 1.0.3)
NHibernate.SQLite20

I've also amended my config file to refer to the new driver class:


However, I'm having problems getting things to run (when previously they ran fine).

When trying to get a session using BuildSessionFactory, I get the error:



Note that I haven't changed the version of ADO.NET - so am I missing something, like this driver only runs with ADO.NET 2.0?



Thanks,

James

Hello,

to have it right, you must include the assembly name.
So I would recommend :

<add key="hibernate.connection.driver_class" value="NHibernate.Driver.SQLite20Driver, NHibernate.SQLite20" />
<add key="hibernate.dialect" value="NHibernate.Dialect.SQLite20Dialect, NHibernate.SQLite20" />


Bertrand.

PS : don't forget to use the new dialect :)

Hi Bertrand,
Thanks - I'm now using:


Which gets me further. However, with 'break on exceptions' on, I then got an error saying that assembly System.Data.SQLite could not be found.

When I copied System.Data.SQLite.dll into my runtime directory, I got an error saying:



I presume that this is because System.Data.SQLite.dll is a .NET 2.0 (or ADO.NET 2.0?) assembly, but I'm running .NET 1.1.

The original post on this dialect implied that this dialect will work with .NET 1.1 - so I've either misinterpreted the original post, or I'm missing a DLL or config.

Any thoughts?

Thanks,

James

I need NH 846 and jira is down. Can anyone help me with it. Thanks
Andres