Unfortunatly its going to be hard to do that since Im using nhibernate and its internally generating all the inserts and doing all the transactional stuff so it could be a combination of that but condiserting it works under windows I dont think nhibernate is doing anything wrong. I can debug it but if there is some thought on what I should look for would be helpfull. I know this message is saying somehow the command to send to do a begin transaction has some other things queued up before it but im not sure how or what I should check to see what could be set before the Set transaction command. When it says that the first statment must be SET TRANSACTION where can I look to see what could possibly be before that command so maybe that might shed some light as to what the problem might be.
thanks scott Veerapuram Varadhan wrote: > > Can you send a standalone test program that can reproduce this > behaviour? > > Thanks, > > V. Varadhan > > On Tue, 2009-11-10 at 10:02 -0800, srf wrote: >> I getting the error ORA-1453: SET TRANSACTION must be first statement of >> trasaction when running an oracle test under mono but under windows I >> dont >> get this error so Im not sure what would be different in mono. Has anyone >> run into this error and know what the problem would be? At the time I was >> using nhibernate and was doing a session.BeginTransaction() then this >> error >> would happen. >> >> thanks >> scott >> >> Full stacktrace: >> Inner Exception: System.Data.OracleClient.OracleException: ORA-01453: SET >> TRANSACTION must be first statement of transaction >> Source: System.Data.OracleClient >> Target Site: Void Begin() >> Stack Trace: at System.Data.OracleClient.Oci.OciTransactionHandle.Begin >> () >> [0x0004d] in >> /disk2/mono/2.4.2new/mono-2.4.2/mcs/class/System.Data.OracleClient/System.Data.OracleClient.Oci/OciTransactionHandle.cs:103 >> at System.Data.OracleClient.OracleConnection.BeginTransaction >> (IsolationLevel il) [0x00049] in >> /disk2/mono/2.4.2new/mono-2.4.2/mcs/class/System.Data.OracleClient/System.Data.OracleClient/OracleConnection.cs:261 >> at System.Data.OracleClient.OracleConnection.BeginDbTransaction >> (IsolationLevel isolationLevel) [0x00000] in >> /disk2/mono/2.4.2new/mono-2.4.2/mcs/class/System.Data.OracleClient/System.Data.OracleClient/OracleConnection.cs:464 >> at System.Data.Common.DbConnection.BeginTransaction () [0x00000] in >> /disk2/mono/2.4.2new/mono-2.4.2/mcs/class/System.Data/System.Data.Common/DbConnection.cs:81 >> at >> System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction >> () [0x00000] in >> /disk2/mono/2.4.2new/mono-2.4.2/mcs/class/System.Data/System.Data.Common/DbConnection.cs:724 >> at NHibernate.Transaction.AdoTransaction.Begin (IsolationLevel >> isolationLevel) [0x00000] >> > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list > > -- View this message in context: http://old.nabble.com/ORA-1453-tp26287357p26292102.html Sent from the Mono - General mailing list archive at Nabble.com. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
