Hi Harm
I notice that every night I leave the bus running, (processing _zero_
messages) the wso2 esb looses the connection to the mysql server...
and in the morning _no_ successfull dabase access can be done anymore.
....
*error logs
*2008-09-28 20:14:33,480 [127.0.0.1-vloeki_v01] [HttpServerWorker-3]
ERROR DBLookupMediator Error executing statement : select
* from customer c where token = '00000000-00'; against DataSource :
jdbc:mysql://localhost:3306/esb
com.mysql.jdbc.CommunicationsException: Communications link failure
due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
It seems like the connection from the ESB to MySQL got broken.. BTW, are
these on the same machine by any chance? .. The problem seems to be the
Apache DBCP connection pool not handling the stale connection properly.
I believe you have defined your datasource using the
synapse.properties?.. Can you try setting the 'testOnBorrow' to true?
[1] .. also see the last paragraph of [1]
asankha
[1] http://wiki.apache.org/commons/DBCP
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
