You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@synapse.apache.org by su...@apache.org on 2010/05/21 09:50:17 UTC
svn commit: r946923 - in /synapse/trunk/java/src/site/xdoc:
Synapse_Samples.xml Synapse_Samples_Setup.xml
Author: supun
Date: Fri May 21 07:50:17 2010
New Revision: 946923
URL: http://svn.apache.org/viewvc?rev=946923&view=rev
Log:
applying patch for SYNAPSE-653
Modified:
synapse/trunk/java/src/site/xdoc/Synapse_Samples.xml
synapse/trunk/java/src/site/xdoc/Synapse_Samples_Setup.xml
Modified: synapse/trunk/java/src/site/xdoc/Synapse_Samples.xml
URL: http://svn.apache.org/viewvc/synapse/trunk/java/src/site/xdoc/Synapse_Samples.xml?rev=946923&r1=946922&r2=946923&view=diff
==============================================================================
--- synapse/trunk/java/src/site/xdoc/Synapse_Samples.xml (original)
+++ synapse/trunk/java/src/site/xdoc/Synapse_Samples.xml Fri May 21 07:50:17 2010
@@ -3677,98 +3677,64 @@ instructions given in the 'Setting up My
<pre xml:space="preserve"><definitions xmlns="http://synapse.apache.org/ns/2010/04/configuration">
- <sequence name="myFaultHandler">
- <makefault response="true">
- <code value="tns:Receiver" xmlns:tns="http://www.w3.org/2003/05/soap-envelope"/>
- <reason expression="get-property('ERROR_MESSAGE')"/>
- </makefault>
- <send/>
- <drop/>
- </sequence>
-
- <sequence name="main" onError="myFaultHandler">
+ <sequence name="main">
<in>
+ <send>
+ <endpoint>
+ <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
+ </endpoint>
+ </send>
+ </in>
+
+ <out>
+ <log level="custom">
+ <property name="text" value="** Reporting to the Database **"/>
+ </log>
+
+ <dbreport>
+ <connection>
+ <pool>
+ <driver>com.mysql.jdbc.Driver</driver>
+ <url>jdbc:mysql://localhost/synapsedb</url>
+ <user>root</user>
+ <password>admin</password>
+ </pool>
+ </connection>
+ <statement>
+ <sql>call updateCompany(?,?)</sql>
+ <parameter expression="//m0:return/m1:last/child::text()" xmlns:m0="http://services.samples" xmlns:m1="http://services.samples/xsd" type="DOUBLE"/>
+ <parameter expression="//m0:return/m1:symbol/child::text()" xmlns:m0="http://services.samples" xmlns:m1="http://services.samples/xsd" type="VARCHAR"/>
+ </statement>
+ </dbreport>
<log level="custom">
- <property name="text"
- value="** Looking up from the Database **"/>
+ <property name="text" value="** Looking up from the Database **"/>
</log>
<dblookup>
<connection>
<pool>
<driver>com.mysql.jdbc.Driver</driver>
- <url>jdbc:mysql://localhost/synapsedb</url>
- <user>root</user>
- <password>admin</password>
+ <url>jdbc:mysql://localhost/synapsedb</url>
+ <user>root</user>
+ <password>admin</password>
</pool>
</connection>
<statement>
- <sql>call getCompanyDetail(?)</sql>
- <parameter expression="//m0:getQuote/m0:request/m0:symbol"
- xmlns:m0="http://services.samples" type="VARCHAR"/>
- <result name="company_id" column="id"/>
+ <sql>call getCompany(?)</sql>
+ <parameter expression="//m0:return/m1:symbol/child::text()" xmlns:m0="http://services.samples" xmlns:m1="http://services.samples/xsd" type="VARCHAR"/>
+ <result name="stock_prize" column="price"/>
</statement>
</dblookup>
-
- <switch source="get-property('company_id')">
- <case regex="c1">
- <log level="custom">
- <property name="text"
- expression="fn:concat('Company ID - ',get-property('company_id'))"/>
- </log>
- <send>
- <endpoint>
- <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
- </endpoint>
- </send>
- </case>
- <case regex="c2">
- <log level="custom">
- <property name="text"
- expression="fn:concat('Company ID - ',get-property('company_id'))"/>
- </log>
- <send>
- <endpoint>
- <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
- </endpoint>
- </send>
- </case>
- <case regex="c3">
- <log level="custom">
- <property name="text"
- expression="fn:concat('Company ID - ',get-property('company_id'))"/>
- </log>
- <send>
- <endpoint>
- <address uri="http://localhost:9000/services/SimpleStockQuoteService"/>
- </endpoint>
- </send>
- </case>
- <default>
- <log level="custom">
- <property name="text" value="** Unrecognized Company ID **"/>
- </log>
- <makefault response="true">
- <code value="tns:Receiver"
- xmlns:tns="http://www.w3.org/2003/05/soap-envelope"/>
- <reason value="** Unrecognized Company ID **"/>
- </makefault>
- <send/>
- <drop/>
- </default>
- </switch>
- <drop/>
- </in>
-
- <out>
+ <log level="custom">
+ <property name="text" expression="fn:concat('Stock Prize - ',get-property('stock_prize'))"/>
+ </log>
<send/>
</out>
-
</sequence>
</definitions></pre></div>
<div>
<p>
-<strong>Objective: Demonstrate the use of dblookup mediator to execute a database Stored Procedure (SP)</strong></p>
+<strong>Objective: Demonstrate the use of dblookup and dbreport mediators to execute a database Stored Procedures</strong></p>
<p>
<strong>Prerequisites:</strong>Set up MySQL database server according to the
<a href="Synapse_Samples_Setup.html#mysql">sample setup guide</a>. Edit the synapse_sample_364.xml
Modified: synapse/trunk/java/src/site/xdoc/Synapse_Samples_Setup.xml
URL: http://svn.apache.org/viewvc/synapse/trunk/java/src/site/xdoc/Synapse_Samples_Setup.xml?rev=946923&r1=946922&r2=946923&view=diff
==============================================================================
--- synapse/trunk/java/src/site/xdoc/Synapse_Samples_Setup.xml (original)
+++ synapse/trunk/java/src/site/xdoc/Synapse_Samples_Setup.xml Fri May 21 07:50:17 2010
@@ -834,11 +834,13 @@ synapse.sh -sample <n></pre>
</li>
<li>
Create a sample databasae<br/>
- <pre>CREATE DATABASE synapsedb;</pre>
+ <pre> DROP DATABASE IF EXISTS synapsedb;
+ CREATE DATABASE synapsedb;</pre>
</li>
<li>
Create a table in the sample database
<pre> USE synapsedb;
+ DROP TABLE IF EXISTS company;
CREATE table company(name varchar(10), id varchar(10), price double);</pre>
</li>
<li>
@@ -847,8 +849,13 @@ synapse.sh -sample <n></pre>
INSERT into company values ('SUN','c2',3.8349);
INSERT into company values ('MSFT','c3',3.2938);</pre>
</li>
- <li>Create a Stored Procedure<br/>
- <pre>CREATE PROCEDURE getCompanyDetail(compName VARCHAR(10)) SELECT name, id, price FROM company WHERE name = compName;</pre>
+ <li>Create a Stored Procedures<br/>
+ <pre> DROP PROCEDURE If EXISTS getCompany;
+ CREATE PROCEDURE getCompany(compName VARCHAR(10)) SELECT name, id, price FROM company WHERE name = compName;
+
+ DROP PROCEDURE If EXISTS updateCompany;
+ CREATE PROCEDURE updateCompany(compPrice DOUBLE,compName VARCHAR(10)) UPDATE company SET price = compPrice WHERE name = compName;
+</pre>
</li>
</ol>
<p>