Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimmy
Starting Member
9 Posts |
 Posted - 2002-11-27 : 22:03:40
|
Hi, My application team is running the JRUN to connect to thesql server 2000. I can see alot of process and locking hanging in thesystem. I look at each of the process propeties and some are onlyselect statement. I wonder why all these process was not flashed and stillhanging in the system ? Anyone had encountered this before ? Thanks for any help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-27 : 22:26:25
|
| It seems Java is bad at closing database connections:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21905Take a quick forum search through SQL Team for "Java", maybe someone here has replied with a solution in the past, but I think you might need to go to a Java forum to get a definitive answer.Also try Microsoft, particularly MSDN. They've supplied a JDBC driver and might have code that describes how to use it best with SQL Server. It might also work or be adaptable to the driver(s) you're using. |
 |
|
|
|
|
|
Process and locking