Oracle 11g Express Database? (I need TransactionScope support)

[THY02K]

Hello

10g Express + ODP.NET (version 2.111.6.20) > support TransactionScope?

I read ODP.NET doc it does support .NET TransactionScope

But what about 10g Express database? My application died silently (i.e. just exit, no exception) on first db call - and if I just comment out TransactionScope, object instance get saved successfully.

Just found out there isn't an "Express" version for 11g? What should I be using...?

http://www.oracle.com/technology/sof...ase/index.html
http://forums.oracle.com/forums/thre...93246&#3393246

Thanks

[cjard]

To use TransactionScope I think you have to have the Oracle MTS components installed and the MTS Recovery Service running (OraMTS)

Check that your instlled client has the MTS components too. It works fine; I used to use TS on 9i, until i realised it was ****. I now use a reflection helper class to enroll all my TableAdapters in connection based transactions and the app is much quicker

[THY02K]

hey thanks!

"I now use a reflection helper class to enroll all my TableAdapters in connection based transactions and the app is much quicker "

Not sure what you mean... code snippet perhaps?


To use TransactionScope I think you have to have the Oracle MTS components installed and the MTS Recovery Service running (OraMTS)

I checked my Oracle ODP.NET installation - I do have MTS components installed but can't find OracleMTSService (name correct?) under Windows Services. Having that said I do have "OracleMTSRecoveryService" running under Windows Services

Also guys seems to be suggesting I need latest ODAC/ODP.NET Beta -

http://forums.oracle.com/forums/thre...394916#3394916
http://www.oracle.com/technology/sof...10710beta.html

Specifically, this discussion lead me to thinking - ODP.NET from http://www.oracle.com/technology/sof.../utilsoft.html includes:
Oracle Services for Microsoft Transaction Server 11.1.0.6.0

But for distributed transaction you may actually need this:
Oracle Services for MTS 11.1.0.7.10

But this latest version is still in BETA as of today 11APRIL2009.

[THY02K]

I installed "ODAC 11g Beta 11.1.0.7.10" BETA downloaded from here:
http://www.oracle.com/technology/sof...10710beta.html

From Oracle Universal Installer I verified that I've installed,

ODP.NET 2.0.11.1.0.7.10 Beta
Oracle Services for MTS 11.1.0.7.10

From Visual Studio, I added reference to "Oracle.DataAccess" and redirect binding to via to:

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<qualifyAssembly partialName="Oracle.DataAccess" fullName="Oracle.DataAccess, Version=2.111.7.10, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</assemblyBinding>

Still got an exception same place (although application this time, running on debugger, did not simply exit but hang) - ODP.NET trace reviewed same exception:

TIME:2009/04/12-06:22:20:796 TID:1354 (EXIT) OpsTraceGetLastErrorCode(): RetCode=0 Line=1454
TIME:2009/04/12-06:22:20:796 TID: c48 (ENTRY) OpsTraceCreateMiniDump()
TIME:2009/04/12-06:22:20:796 TID: c48 (EXIT) OpsTraceCreateMiniDump(): None created: TraceLevel=0 Line=1371
TIME:2009/04/12-06:22:20:796 TID:1354 (EXCPT) Lvl0: (Type=System.AccessViolationException) (Msg=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.) (Win32Err=203) (Code=c0000005) (Stack= at Oracle.DataAccess.Client.OpsCon.Enlist(IntPtr opsConCtx, OpoConValCtx* pOpoConValCtx, OpoConRefCtx pOpoConRefCtx)
at Oracle.DataAccess.Client.ConnectionDispenser.Enlist(OpoConCtx opoConCtx))
TIME:2009/04/12-06:22:20:796 TID:1354 (ENTRY) OpsConClose(): (bbea408)=197043208
TIME:2009/04/12-06:22:20:796 TID:1354 (ENTRY) OpsConRelRef(): (bbea408)=197043208
TIME:2009/04/12-06:22:20:796 TID:1354 (ENTRY) OpsErrFreeCtx()
TIME:2009/04/12-06:22:20:796 TID:1354 (EXIT) OpsErrFreeCtx(): RetCode=0 Line=224
TIME:2009/04/12-06:22:20:796 TID:1354 (EXIT) OpsConRelRef(): RefCount=0 RetCode=0 Line=3289 (0)=0
TIME:2009/04/12-06:22:20:796 TID:1354 (EXIT) OpsConClose(): RetCode=0 Line=1242 (bbea408)=197043208
TIME:2009/04/12-06:22:20:796 TID:1354 (ENTRY) OpsConDispose(): (0)=0
TIME:2009/04/12-06:22:20:796 TID:1354 (EXIT) OpsConDispose(): RetCode=0 Line=1320
TIME:2009/04/12-06:22:20:812 TID:1354 (ENTRY) OpsConRelRef(): (0)=0
TIME:2009/04/12-06:22:20:812 TID:1354 (WARN) OpsConRelRef(): Null ptr: (0)=0
TIME:2009/04/12-06:22:20:812 TID:1354 (EXIT) OpsConRelRef(): RetCode=1 Line=3158 (0)=0

[Bainster]

THY02K,

Did you find a way around this problem? I am currently in the same boat (have not installed the beta version of ODP.Net), but getting the access violations in trace. Any information you can provide would be greatly appreciated.

Thanks,

Christian

[THY02K]

hey Christian

No, I had to use good old "oTrans.BeginTransaction()" just for Oracle, this really sucks. Apparent, the fix in BETA edition which didn't work for me is still in BETA.

So as of today I don't think Oracle is friendly with TransactionScope.

Thanks

Norman