We are building the config dynamically in the program Thanks for the reply- I will have to check tomorrow I did see where the dialect was being set - but not sure it is correctly set
Anthony Dyer Director of Technology, Transportation (847) 954 4526 or (847) 699-6620 [email protected] www.logility.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of mhanney Sent: Sunday, April 26, 2009 11:35 AM To: nhusers Subject: [nhusers] Re: Oracke Transaction In your nhibernate.config for Oracle, do you have <property name="connection.isolation"> set, and if so, what value is it set to? Did you try <property name="connection.isolation">ReadCommitted</ property> ? On Apr 24, 11:37 am, AAD <[email protected]> wrote: > I have a system that needs to interface with SQL Server or Oracle 11g. > In the code, there is the following: > > session = Data.DaoFactory.OpenSession(systemInstance); > transaction = session.BeginTransaction(); > > when I run and am connected to SQL Server, the BeginTransaction() > works fine, with I am connected to Oracle, I get an error: > > + IsolationLevel > + '((NHibernate.Transaction.AdoTransaction) > (transaction)).IsolationLevel' threw an exception of type > 'System.Data.OracleClient.OracleException' > System.Data.IsolationLevel {System.Data.OracleClient.OracleException} > > any suggestion on how to go about debugging? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
