Ah i forgot to mention - mysql and tomcat are on the same machine :) which kinda counts out network problems.
I cant see any reason why i'd get these errors (at least on a 1 machine system). The connection pool should prevent them happening due to timeouts/etc. If it doesnt, then i'd expect to find that mysql had died, and the system to remain down until it had been started up again. Daniel. > -----Original Message----- > From: Edson Carlos Ericksson Richter > [mailto:[EMAIL PROTECTED] > Sent: 11 October 2004 16:07 > To: OJB Users List > Subject: Re: SQLExcpetion > > > If you try to copy large files between machines, you get Connection > Reset (or connection reset by peer, in some OSes)??? If so, you get a > trahsed network card or network hub... I had this problem some time ago, > and I had to exchange a hub with some ports "burned", sending trash in > my network... > > Just my 2c, > > Richter > > Daniel Perry escreveu: > > >Hi all, > > > >One of our systems has been running fine (live) for the last few > weeks until > >yesterday when for about half an hour it started randomly crashing. Since > >then it has been fine! The (partial) exception trace is below. > From what i > >can figure the problem is coming from dud mysql connections. However, i > >thought that OJB checked the connection before using it by using the > >validation query? > > > >I'm using OJB 1.0.0, mysql-connector 3.0.10, and mysql 4.0.18. > > > >Any ideas about what would cause this? Anyway i can prevent it occuring > >again? > > > >Thanks, > >Daniel. > > > > > > > > > >[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: No > >operations allowed after connection closed. > > > >Connection was closed due to the following exception: > > > >** BEGIN NESTED EXCEPTION ** > > > >java.sql.SQLException > >MESSAGE: Communication link failure: java.io.IOException, > underlying cause: > >Unexpected end of input stream > > > >** BEGIN NESTED EXCEPTION ** > > > >java.io.IOException > >MESSAGE: Unexpected end of input stream > > > >STACKTRACE: > > > >java.io.IOException: Unexpected end of input stream > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1455) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1826) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2051) > > at > >com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.j > ava:1496) > > at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > >Source) > > at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown > >Source) > > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) > > at > >org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown > >Source) > > at > >org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFro > mQuery(Unkn > >own Source) > > at > >org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQ > uery(Unknow > >n Source) > > at > >org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQu > ery(Unknown > >Source) > > at > >org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQu > ery(Unknown > >Source) > > at > >org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQ > uery(Unknow > >n Source) > > at > >org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollect > ionByQuery( > >Unknown Source) > > at > >org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollect > ionByQuery( > >Unknown Source) > > at > >org.apache.ojb.broker.core.proxy.CollectionProxyDefaultImpl.loadD > ata(Unknown > >Source) > > at > org.apache.ojb.broker.core.proxy.ListProxyDefaultImpl.loadData(Unknown > >Source) > > at > >org.apache.ojb.broker.core.proxy.CollectionProxyDefaultImpl.getDa > ta(Unknown > >Source) > > at > >org.apache.ojb.broker.core.proxy.CollectionProxyDefaultImpl.itera > tor(Unknown > >Source) > > at > >org.apache.taglibs.standard.tag.common.core.ForEachSupport.toForE > achIterator > >(ForEachSupport.java:329) > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
