I will check issue with 'autocommit'. Thanks
BTW , In the Mysql forum, I see a same issue and some solutions [1].
Could you go through that?.
You have another option to set connection pools using synape.properties
file. Please read section under 'Setting up Synapse DataSources' in the
[2]. Corresponding sample is at [3].
Here, all configuration options are same to DBCP configuration options
so that you can configure using [4].
Thanks
Indika
[1] http://forums.mysql.com/read.php?39,42763,42763
[2] http://wso2.org/project/esb/java/1.7.1/docs/ESB_Samples_Setup.html
[3] http://wso2.org/project/esb/java/1.7.1/docs/ESB_Samples.html#Sample363
[4] http://commons.apache.org/dbcp/configuration.html
Harm Verhagen wrote:
Yeah. I suspected the same thing, I'm already running this.
I'll report later.
*side note: *I noticed that dbreport mediator does not allow to set
autocommit to true.. (well it does... but when you actually do this
you get errors... because it seems the dbreport mediator calls
commit itself. (my query has no explicit commit).)
ERROR DBReportMediator Error execuring insert statement : update
transaction set customer_id = ? where id = ? against DataSource :
jdbc:mysql://localhost:3306/esb java.sql.SQLException: Can't call
commit when autocommit=true
Probably the UI shouldn't expose autocommit true/false for dbreport ?
Regards,
Harm
2008/9/29 Indika Kumara <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
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] <mailto:[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] <mailto:[email protected]>
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
------------------------------------------------------------------------
_______________________________________________
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
