DataBase Connection Problem

[Former Member]

hi,

i have xMII 12 in my system and SQL 2000 in another system.

i worked with this database and after some time database's system is restarted and again service is running in that machine but in xMII 12 application it shows this error in java console as

ERROR - com.inet.tds.SQLException: Connection reset by peer: socket write error

and also it doesnt show any data.

But when i tried from other system which have xMII 11.5, it is working fine. how to solve it?

regards

senthil

[Former Member · Accepted solution]

A few questions:

1) (To you:) Do you have a "validation query" set up in your data server configuration?

2) (To SAP:) Did the connection pooling change in V12 so that it no longer uses the validation query?

The error message is normal and expected in this situation, but MII should automatically attempt to try to get a new connection. There are, of course, cases where it won't be able to do so (e.g. the database server is down or is still restarting).