Hi,

I need help in writing a driver/dialect for VistaDB database. VistaDB has a ADO.net driver. Is their a sample that I can have a look at or any documentation related to this ?

Thanks

Jagdeep

Hi Jagdeep

Snap !

http://jira.nhibernate.org/browse/NH-326

How far have you got? I've managed to get the basic save/retrieve working but there are a few limitations of VistaDB that are tricky to work around.

The main one I came across is that retrieving the identity column of a newly inserted item requires the column name and table name in the SQL so I have had to make a 1 line change to NHibernate to cater for this (which doesn't affect any other drivers). I've since been looking at Hibernate 3.x and this has something similar so maybe they have come across the same thing with another driver and come up with a similar solution.

Apart from that, the limitations are mainly to do with the SQL that VistaDB will accept and the data-types supported. Joined-subclasses are a problem because it doesn't like case when is null for instance.

So, I'm not sure yet whether its acceptable to suggest some hibernate 3.0-like changes to NHibernate to support the limitations of a particular driver or to just accept that a certain Db driver will have limitations and not support some NHibernate features.

- Simon

Hi All,

Did you guys get NHibernate driver for VistaDB working? Just curious as I am using VistaDB and looking forward to use NHibernate.

Thanks in advance.

This took a little longer than expected ... I picked it up again and it's been possible to get things up and running with the new VistaDB 3.0 CTP and NHibernate 1.2 beta 2 (although I think it should be possible to make it work with 1.0.3 as well).

All posted here: http://www.vistadb.net/forums/viewtopic.php?t=720

Please create an issue in our JIRA and attach your files there.