Hi Harm
According to the
http://www.mikeschubert.com/archives/2006/08/javanetsocketex.html ,
I feel enabling auto commit even for query may solve issue. For set
default auto commit,
you have to add property with name 'autocommit' and value equal to 'true'.
Could you try this out ? .BTW, if issue will not be resolved, please
create JIRA and attached anything needs to reproduce issue.
Thanks
Indika
Harm Verhagen wrote:
testonborrow is not helping.
8 hours later in the morning, same problem...
Can this be related to queries & commit (or better said the lack of
commits) ? (Is dblookup doing commits ?)
2008-09-29 10:02:17,838 [127.0.0.1-vloeki_v01] [HttpServerWorker-9]
DEBUG DBLookupMediator Successfully prepared statement : select id
from transaction_uuid where uuid = ? against DataSource :
jdbc:mysql://localhost:3306/esb
2008-09-29 10:02:17,839 [127.0.0.1-vloeki_v01] [HttpServerWorker-9]
ERROR DBLookupMediator Error executing statement : select id from t
ransaction_uuid where uuid = ? 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
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
....
*datasource*
snippet from my synapse.xml that defines the datasource
<syn:dblookup>
<syn:connection>
<syn:pool>
<syn:password>esb</syn:password>
<syn:user>esb</syn:user>
<syn:property name="testonborrow" value="true"/>
<syn:url>jdbc:mysql://localhost:3306/esb</syn:url>
<syn:driver>com.mysql.jdbc.Driver</syn:driver>
</syn:pool>
</syn:connection>
<syn:statement>
<syn:sql><![CDATA[select * from customer c where token
= ?;]]></syn:sql>
<syn:parameter
xmlns:ns1="http://org.apache.synapse/xsd";
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";
expression="get-property('token')" type="VARCHAR"/>
<syn:result name="customer_id" column="id"/>
</syn:statement>
</syn:dblookup>
Regards,
Harm
On Sun, Sep 28, 2008 at 9:56 PM, Harm Verhagen
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
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
Yes, the esb & mysql run on the same machine.
I defined the datasource in my synapse.xml file
I'm running the esb now with:
<syn:property name="testonborrow" value="true"/>
for every dblookup and every dbreport mediator
I'll report later if this is more stable.
Regards,
Harm
------------------------------------------------------------------------
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.7.5/1696 - Release Date: 9/28/2008 1:30 PM
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
