SQL Server Performance

deadlock detection

Discussion in 'T-SQL Performance Tuning for Developers' started by bfortune, Mar 27, 2003.

  1. bfortune New Member

    We are using JDBC with SQL Server 2000.
    Does anyone know how to detect a deadlock - i.e. the victim gets rolled back and a SQLException is thrown. (similar to ODBC)

    I get the SQLState (5 character code) from the exception and try to classify
    the exception based on that, but I can't find any state corresponding to a deadlock.

    Thanks,
    Barry
  2. trifunk New Member

    According to BOL the native error raised by sql server is 1205 for a process that has become the selected victim of a deadlock situation. I'm not too familar with JDBC but in ADO the error can be exctracted by accessing the native error of the errors collection. Since it's sql server raising the error I would assume you should get a similar error number, have you tried viewing all properties of the SqlException to find if one of the error properties are raising this error?

    Cheers
    Shaun

    World Domination Through Superior Software
  3. bfortune New Member

    Thanks.

    It is possible to get the Vendor error code from a SQLException - I was hoping to avoid
    doing this, since the number of error codes is large, while the states are more managable. I will try to force a deadlock in a simple program and see what gets thrown.

    Barry



    quote:Originally posted by trifunk

    According to BOL the native error raised by sql server is 1205 for a process that has become the selected victim of a deadlock situation. I'm not too familar with JDBC but in ADO the error can be exctracted by accessing the native error of the errors collection. Since it's sql server raising the error I would assume you should get a similar error number, have you tried viewing all properties of the SqlException to find if one of the error properties are raising this error?

    Cheers
    Shaun

    World Domination Through Superior Software

Share This Page