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]>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
