locked
using ado(msdaora) connect oracle 9i db server , long transaction block other transaction. RRS feed

  • Question

  • Hi all,

    I have an asp application use com+ (msdtc ) to handle a transaction.

    I find something wrong with msdtc services.

     

    The test code like this

     

    Long transaction ..

     

    <%@ transaction=Required%>

    <%
     
    Server.ScriptTimeout=5
    dim strExportDataSQL
     
    strExportDataSQL= "Begin "
     
    strExportDataSQL=strExportDataSQL+ "  DBMS_LOCK.SLEEP (120); "
    strExportDataSQL=strExportDataSQL+ " END; "
     
    Dim adocon
    set adocon=Server.Createobject("adodb.connection")
    adocon.open "provider=msdaora;Data Source=miso9;User Id=ooo;Password=ooo"
    adocon.execute  strExportDataSQL
    adocon.close()
     

    %>



     

    short transaction.

     

      <%@ transaction=Required%>
    <%
    strCase="BB000000000"
    response.write strCase
     

    dim strExportDataSQL
     
    strExportDataSQL= "select 1 from dual"
     
    Dim adocon
    set adocon=Server.Createobject("adodb.connection")
    adocon.open "provider=msdaora;Data Source=miso9;User Id=aaa;Password=aaa"
    adocon.execute  strExportDataSQL
    adocon.close()
     
    %>

     


     

     

    when I run the long transaction code, after 60 second, the short transaction program can't run  .

    before 60second , short transaction program works fine..

     

    And I find msdtc transaction list have one record : now abort .......

     

    the ap server don't handle any request.

     

    Is any way to solve this problem?

     

    I have ask gstc in Taiwan about this problem

    the question number is SRT070608805308

    But they just say...

    This api don't full test on version after 8.17 OCI.

    and the kb don't show this problem

    http://support.microsoft.com/Default.aspx?id=244661

     

    Because this problem, This AP crash when the long transaction fail .

     

    Thursday, June 14, 2007 5:24 AM

All replies

  • Hi Randy,

    I have a support engineer who is ready to assist you with this. Please email me at budsup@microsoft.com with your contact info and the best time to reach you.

     

    -brenda

    Tuesday, July 10, 2007 5:37 PM