I have a weird case.
I have a Java program running in batch, which receives data via a socket and is updating a SQL Server 2000 Database via a JDBC/Socket Connection. As there is a very high volume of data, the program should run a very long time.
This is a newish application and this is the first time I am testing with such high volume data. After running for 8-10 hours (writing to the dbase at least every couple of seconds) the program crashes with Microsoft SQL Server 2000 Connection Reset.
.
Some notes that may be helpful:
* This is straight conenction - no pooling.
* There are logged messages of database access about 10 seconds before the abend (conenction reset).
*The SQL Log does not indicate any errors or restarts.
I tried googling and didn't find much. Any ideas? Any SQL Settings that I can check (browing around I didn't see any)?
Thanks tons for all your help in this matter!