[Mono-list] ORA-1453

srf Scott.Fluto at cmgl.ca
Tue Nov 10 17:05:05 EST 2009

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.



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.

More information about the Mono-list mailing list