You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@synapse.apache.org by hi...@apache.org on 2010/09/26 08:12:09 UTC
svn commit: r1001366 - in /synapse/branches/2.0:
repository/conf/sample/synapse_sample_362.xml
src/site/xdoc/Synapse_Samples.xml
Author: hiranya
Date: Sun Sep 26 06:12:09 2010
New Revision: 1001366
URL: http://svn.apache.org/viewvc?rev=1001366&view=rev
Log:
Fixing a sample
Modified:
synapse/branches/2.0/repository/conf/sample/synapse_sample_362.xml
synapse/branches/2.0/src/site/xdoc/Synapse_Samples.xml
Modified: synapse/branches/2.0/repository/conf/sample/synapse_sample_362.xml
URL: http://svn.apache.org/viewvc/synapse/branches/2.0/repository/conf/sample/synapse_sample_362.xml?rev=1001366&r1=1001365&r2=1001366&view=diff
==============================================================================
--- synapse/branches/2.0/repository/conf/sample/synapse_sample_362.xml (original)
+++ synapse/branches/2.0/repository/conf/sample/synapse_sample_362.xml Sun Sep 26 06:12:09 2010
@@ -68,8 +68,9 @@
</connection>
<statement>
<sql>select * from company where name =?</sql>
- <parameter xmlns:m0="http://services.samples/xsd"
- expression="//m0:return/m0:symbol/child::text()" type="VARCHAR"/>
+ <parameter xmlns:m1="http://services.samples/xsd"
+ xmlns:m0="http://services.samples"
+ expression="//m0:return/m1:symbol/child::text()" type="VARCHAR"/>
<result name="stock_price" column="price"/>
</statement>
</dblookup>
Modified: synapse/branches/2.0/src/site/xdoc/Synapse_Samples.xml
URL: http://svn.apache.org/viewvc/synapse/branches/2.0/src/site/xdoc/Synapse_Samples.xml?rev=1001366&r1=1001365&r2=1001366&view=diff
==============================================================================
--- synapse/branches/2.0/src/site/xdoc/Synapse_Samples.xml (original)
+++ synapse/branches/2.0/src/site/xdoc/Synapse_Samples.xml Sun Sep 26 06:12:09 2010
@@ -3240,7 +3240,7 @@ require 'rexml/document'
include REXML
def transformRequest(mc)
- newRequest= Document.new '<m:getQuote xmlns:m="http://services.samples/xsd">'<<
+ newRequest= Document.new '<m:getQuote xmlns:m="http://services.samples">'<<
'<m:request><m:symbol></m:symbol></m:request></m:getQuote>'
newRequest.root.elements[1].elements[1].text = mc.getPayloadXML().root.elements[1].get_text
mc.setPayloadXML(newRequest)
@@ -3274,7 +3274,7 @@ end
<![CDATA[
require 'rexml/document'
include REXML
- newRequest= Document.new '<m:getQuote xmlns:m="http://services.samples/xsd"><m:request><m:symbol>...test...</m:symbol></m:request></m:getQuote>'
+ newRequest= Document.new '<m:getQuote xmlns:m="http://services.samples"><m:request><m:symbol>...test...</m:symbol></m:request></m:getQuote>'
newRequest.root.elements[1].elements[1].text = $mc.getPayloadXML().root.elements[1].get_text
$mc.setPayloadXML(newRequest)
]]>
@@ -3485,10 +3485,11 @@ end
<div>
<p>
<strong>Objective:Introduction to the dbreport mediator</strong> </p>
+<p>
<strong>Prerequisites:</strong>
<br/>Setting up Derby database as above.
<br/>Start the Synapse configuration numbered 361: i.e. synapse -sample 361
-<br/>Start the Axis2 server and deploy the SimpleStockQuoteService if not already done</div>
+<br/>Start the Axis2 server and deploy the SimpleStockQuoteService if not already done</p></div>
<p>This sample demonstrates simple database write operations. The dbreport mediator writes (i.e. inserts one row) to a table using the message details. It works the same as the dblookup mediator. In this sample , dbreport mediator is used for updating the stock price of the company using the last quote value which is calculated by evaluating an XPath against the response message. After running this sample, user can check the company table using the Derby client tool. It will show the inserted value by the dbreport mediator. </p>
<p>Run the client using, </p>
<pre xml:space="preserve">ant stockquote -Daddurl=http://localhost:9000/services/SimpleStockQuoteService -Dtrpurl=http://localhost:8280/ -Dsymbol=IBM</pre>
@@ -3499,63 +3500,64 @@ end
<p/>
<h2>
<a name="Sample362" id="Sample362">Sample 362: Action of dbreport and dblookup mediators together</a></h2>
-<pre xml:space="preserve"><definitions xmlns="http://synapse.apache.org/ns/2010/04/configuraiton">
+<pre xml:space="preserve"><definitions xmlns="http://synapse.apache.org/ns/2010/04/configuration">
- <sequence name="main">
+ <sequence name="main" trace="enable">
<in>
<send>
<endpoint>
- <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
+ <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
</endpoint>
</send>
</in>
<out>
- <log level="custom">
- <property name="text"
- value="** Reporting to the Database **"/>
+ <log level="custom">
+ <property name="text" value="** Reporting to the Database **"/>
</log>
- <dbreport xmlns="http://synapse.apache.org/ns/2010/04/configuraiton">
+ <dbreport>
<connection>
<pool>
- <driver>org.apache.derby.jdbc.ClientDriver</driver>
- <url>jdbc:derby://localhost:1527/synapsedb;create=false</url>
- <user>synapse</user>
- <password>synapse</password>
+ <driver>com.mysql.jdbc.Driver</driver>
+ <url>jdbc:mysql://localhost:3306/synapsedb</url>
+ <user>root</user>
+ <password>root123</password>
</pool>
</connection>
<statement>
<sql>update company set price=? where name =?</sql>
- <parameter expression="//m0:return/m0:last/child::text()"
- xmlns:m0="http://services.samples/xsd" type="DOUBLE"/>
- <parameter expression="//m0:return/m0:symbol/child::text()"
- xmlns:m0="http://services.samples/xsd" type="VARCHAR"/>
+ <parameter xmlns:m1="http://services.samples/xsd"
+ xmlns:m0="http://services.samples"
+ expression="//m0:return/m1:last/child::text()" type="DOUBLE"/>
+ <parameter xmlns:m1="http://services.samples/xsd"
+ xmlns:m0="http://services.samples"
+ expression="//m0:return/m1:symbol/child::text()" type="VARCHAR"/>
</statement>
</dbreport>
- <log level="custom">
- <property name="text"
- value="** Looking up from the Database **"/>
+ <log level="custom">
+ <property name="text" value="** Looking up from the Database **"/>
</log>
- <dblookup xmlns="http://synapse.apache.org/ns/2010/04/configuraiton">
+ <dblookup>
<connection>
<pool>
- <driver>org.apache.derby.jdbc.ClientDriver</driver>
- <url>jdbc:derby://localhost:1527/synapsedb;create=false</url>
- <user>synapse</user>
- <password>synapse</password>
+ <driver>com.mysql.jdbc.Driver</driver>
+ <url>jdbc:mysql://localhost:3306/synapsedb</url>
+ <user>root</user>
+ <password>root123</password>
</pool>
</connection>
<statement>
<sql>select * from company where name =?</sql>
- <parameter expression="//m0:return/m0:symbol/child::text()"
- xmlns:m0="http://services.samples/xsd" type="VARCHAR"/>
- <result name="stock_price" column="price"/>
+ <parameter xmlns:m1="http://services.samples/xsd"
+ xmlns:m0="http://services.samples"
+ expression="//m0:return/m1:symbol/child::text()" type="VARCHAR"/>
+ <result name="stock_price" column="price"/>
</statement>
</dblookup>
- <log level="custom">
- <property name="text"
- expression="fn:concat('Stock price - ',get-property('stock_price'))"/>
+ <log level="custom">
+ <property name="text"
+ expression="fn:concat('Stock price - ',get-property('stock_price'))"/>
</log>
<send/>
</out>