Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: transaction works for hours in sybase.

    Hello. I have a stored procedure that brings information from the database. The problem is when i close the window the transaction continues to work.

    Does that mean that my transaction is wrong?

    When the result data is not big, the transaction brings proper and true values. I mean it works well in java. When the data to be selected is like tens of thousands, the program waits forever and when i close my window, the transaction is still working.

    How can i prevent this?

  2. #2
    Join Date
    Jun 2007
    select fewer records or make your query go faster?

Posting Permissions

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