All my unit tests have been running fine for ages until today when I suddenly started to get the following error message when using the NHibernate.Driver.OracleClientDriver:



Things get even worse when I change to the NHibernate.Driver.OracleDataClientDriver

I then get the even more obtuse error message:



I can't think what I've changed on the machine for this to happen, but no major changes or installations.

I have rebooted several times. I get the same errors when running from NUnit itself.

Has anyone had this and managed to solve it? Google searches reveal a long list of unanswered posts!

FYI config is as follows:

I am having the very same issue: "Could not create the driver from NHibernate.Driver.OracleDataClientDriver." Anyone have help or ideas for this issue?

Also, why is there little documentation/examples for Oracle and NHibernate? I found a page on the Hibernate site pertaining to connection strings dialect settings for Nhibernate for and every supported database except for Oracle. There was some text there about Oracle, but no help like the others. >:(~

Is there any clear documentation about .NET based deployment configurations with NHibernate? All they mention in the quick start is using IIS and Squeel--er I mean--SQL Server 2K!

Thanks in advance!

-dw

Hi,

here is what I use:

<nhibernate>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
<add key="hibernate.connection.driver_class" value="NHibernate.Driver.OracleClientDriver"/>
<add key="hibernate.connection.connection_string" value="Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ***)(PORT = 1539)))(CONNECT_DATA = (SID = ****)));User Id=****;Password=****;" />
<add key="hibernate.dialect" value="NHibernate.Dialect.Oracle9Dialect"/>
<add key="hibernate.show_sql" value="true"/>
<add key="hibernate.query.substitutions" value="true=1, false=0"/>
<add key="hibernate.cache.use_query_cache" value="true"/>
</nhibernate>

the oracle driver is installed on the machine

Thanks for the reply, I sincerely appreciate it!

Does this work for 10g? I noticed that you have Oracle9 as the dialect.

Thanks!
dw

yes, but you wont profit from the new features of 10g.