On 9/22/05, Davide Emanuele Denicolo <[EMAIL PROTECTED]> wrote: > Hi at all! > I have this problem: > I'm using MS SQL Server 2000 as information repository and ojb with java > My problem is that when the connection between tomcat and sql server has > broken or SQL gets down,I receive this message to browser > > > org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException: > [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket > write error
This looks like a timeout problem (though it might also be something different). You could try to configure the connection timeout (refer to the SQLServer doc). Or you could try a different jdbc driver, eg. jTDS http://jtds.sourceforge.net/. One other thing to try is to configure OJB to use a poolable data source (jndi) instead of the jdbc driver directly. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
