I have a java application that I have developed. I run in locally on my machine using Access 2000. I use jdbc to access the database. My production machine uses SQLServer 7.0. The program usually works on that machine also. I just a couple of instances, when I execute an insert statement, the program just hangs. It always happens with the same record. I am actually copying a set of rows, change one value and re-inserting them into the same table. If I delete the offending row, the program finishs normally. I thought that I might have some bad data, in the SQLServer database. So I deleted the offending row and re-added it and then did the copy. The program still hung on the same insert statement execution. Is there something within SQLServer that I can see that will allow me to see what is causing my program to hang.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access vs SQLServer in jdbc
- Thread starter BSchaff
- Start date
Similar threads
- Locked
- Question