Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    16

    Unhappy Unanswered: Inserts not taking place in th e proper order

    Hi,

    The application I am working upon is built on java with sybase as backend.
    Weblogic is the application server.

    From the application a stored procedure is fired in a while loop based upon the tables populated by the procedure. This stored procedure calls other sp,

    Now, when i am running application in no server mode .... every thing is going fine. All inserts, updates,deletes to table are in desired manner

    But when I run application in server mode the SP behaves differently. It appears to work in avery asynchronous manner. The order of statement executions in sp suddenly changes.

    I made some inserts in a table to record the activity going within the sp.
    and this was strangest part. Sometimes rows were inserted and sometimes not. same is appearing with delete statements..

    following is the piece of log i generated.

    pLease help me to find out what explains this behaviour
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    What do you mean by "server" mode?

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •