Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

SQL Timeouts and Blocking Locks

SQL Timeouts and Blocking Locks

Just wanted to check in and see if anyone here has feedback on application settings, ColdFusion settings, JBOSS settings or other settings that could help to limit or remove SQL Timeouts and blocking locks on SID's.

We're using MS SQL 2000 with JBOSS and IIS5.

We've been seeing the following error in our logs that starts blocking locks in SQL:

java.sql.SQLException: [newScale] [SQLServer JDBC Drive] [SQLServer] Lock request time out period exceeded.

Once this happens, we're hosed until we remove the blocking SID in SQL.  These are the connections to the application.

Any feedback would be great.  Thanks!

Everyone's tags (1)
224
Views
0
Helpful
0
Replies
CreatePlease to create content