[Mono-list] ORA-1453

[srf]

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  -  Mono-list at lists.ximian.com
> 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.