Experiencing lock timeout error when accessing a SQL server 2005 running on 2008 server. J2ee application running on Websphere 7 also on Windows Server 2008.
Any cautions for 2008? Or connection pool settings? Java process on Websphere spikes and needs to be restarted. application has been running for years without similar issues.