You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by alexander <al...@scrashmeow.org> on 2003/05/01 16:18:27 UTC

Communication link failure

I continue to get a communication link failure after my application sits idle
for some time.   I'm wondering what I may be doing wrong, or what I can do better to ensure this doesn't happen.  After I restart my servlet engine (Tomcat) everything is running again.   This only happens after an idle period.

I would be grateful for any advice.

-alexander


java.sql.SQLException: Communication link failure: java.net.SocketException
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:882)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:1809)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1458)
	at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
	at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source)
	at org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
	at org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
	at org.scrashmeow.model.OjbContentService.lookupBrowseableContent(OjbContentService.java:244)

Re: Communication link failure

Posted by Alexander Bibighaus <al...@scrashmeow.org>.
i think the thread on "PersistenceBroker best practices" addresses my
question :)

-alexander


----- Original Message -----
From: "alexander" <al...@scrashmeow.org>
To: <oj...@db.apache.org>
Sent: Thursday, May 01, 2003 9:18 AM
Subject: Communication link failure


I continue to get a communication link failure after my application sits
idle
for some time.   I'm wondering what I may be doing wrong, or what I can do
better to ensure this doesn't happen.  After I restart my servlet engine
(Tomcat) everything is running again.   This only happens after an idle
period.

I would be grateful for any advice.

-alexander


java.sql.SQLException: Communication link failure: java.net.SocketException
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:882)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1809)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1458)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source)
at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknow
n Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getCollectionByQu
ery(Unknown Source)
at
org.scrashmeow.model.OjbContentService.lookupBrowseableContent(OjbContentSer
vice.java:244)




----------------------------------------------------------------------------
----


> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org