NHibernate and Oracle.DataAccess.Client
All the examples in the NHibernate documentation for Oracle have the following setting for the driver_class:
<property name="connection.driver_class"> NHibernate.Driver.OracleClientDriver </property>
This will use the Microsoft Oracle client. The documentation states that you can also use the client from Oracle (ODP.NET), but it does not state how you can achieve this.
Apparently you have to use the NHibernate.Driver.OracleDataClientDriver as driver_class in your NHibernate config file:
<property name="connection.driver_class"> NHibernate.Driver.OracleDataClientDriver </property>
Tuesday 04 Jul 2006 | Guy Mahieu | .net(t) , nhibernate(t) , oracle(t)
Hello
You tested this? I am planning to switch to “Oracle.DataAccess.Client” instead of “System.Data.OracleClient” because it seems to be the later not friendly with .NET TransactionScope…
I have used it a while back and it worked. But you should obviously test it with your own setup to make sure it works for you.