Hi,
I am using Nhibernate in my project along with oracle database, my project works fine when i use the IsolationLevel ReadCommitted.
But when i use IsolationLevel ReadUnComitted I get the billow error when calling BeginTransaction. The same works in SQL database and not with oracle database.
IsolationLevel must be ReadCommitted or Serializable
Parameter name: isolationLevel
at Oracle.DataAccess.Client.OracleConnection.BeginTransaction(IsolationLevel isolationLevel)
at Oracle.DataAccess.Client.OracleConnection.System.Data.IDbConnection.BeginTransaction(IsolationLevel isolationLevel)
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
This is my Config File
Code:
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="dialect">NHibernate.Dialect.Oracle9Dialect</property>
<property name="connection.driver_class">NHibernate.Driver.OracleDataClientDriver</property>
<property name="connection.connection_string">Data source=s;User Id=id;Password=pas;</property>
<property name="connection.isolation">
ReadUncommitted
</property>
</session-factory>
</hibernate-configuration>
Have i missed something here
Thanks
Arvind
Login
FAQ
Search