Author: indika Date: Fri Jun 26 01:49:13 2009 New Revision: 40029 URL: http://wso2.org/svn/browse/wso2?view=rev&revision=40029
Log: update dblookup documentation Modified: branches/esb/java/2.1/product/docs/xdoc/mediators/dblookup.xml branches/esb/java/2.1/product/docs/xdoc/mediators/dbreport.xml Modified: branches/esb/java/2.1/product/docs/xdoc/mediators/dblookup.xml URL: http://wso2.org/svn/browse/wso2/branches/esb/java/2.1/product/docs/xdoc/mediators/dblookup.xml?rev=40029&r1=40028&r2=40029&view=diff ============================================================================== --- branches/esb/java/2.1/product/docs/xdoc/mediators/dblookup.xml (original) +++ branches/esb/java/2.1/product/docs/xdoc/mediators/dblookup.xml Fri Jun 26 01:49:13 2009 @@ -69,7 +69,8 @@ <ul> <li><strong>sql </strong>- One or more SQL Statements </li> <li><strong>parameter</strong> - Specify how the values of parameter in the - SQL would be calculated. </li> + SQL would be calculated. A value can be static literal text and can be + calculated at runtime based on the given expression.</li> <li><strong>result</strong> - Specify how to deal with rerun result from Database query execution. </li> </ul> @@ -111,9 +112,10 @@ </dblookup></pre> <h3>UI Configuration</h3> - <p> -<img src="../dblookup-mediator/docs/images/dblookup-options.png" alt="" /> - </p> + +<p><img src="../dblookup-mediator/docs/images/dblookup-options.png" alt="" /> +</p> + <div class="image"> <p>Figure 1: DBLookup mediator options </p> </div> Modified: branches/esb/java/2.1/product/docs/xdoc/mediators/dbreport.xml URL: http://wso2.org/svn/browse/wso2/branches/esb/java/2.1/product/docs/xdoc/mediators/dbreport.xml?rev=40029&r1=40028&r2=40029&view=diff ============================================================================== --- branches/esb/java/2.1/product/docs/xdoc/mediators/dbreport.xml (original) +++ branches/esb/java/2.1/product/docs/xdoc/mediators/dbreport.xml Fri Jun 26 01:49:13 2009 @@ -14,7 +14,9 @@ <h2>DBReport Mediator</h2> <p>The dbreport mediator is very similar to the dblookup mediator, but writes -information to a Database, using the specified insert SQL statement. </p> +information to a Database, using the specified insert SQL statement. For +configuration information about db mediators , refer <a +href="dblookup.html">dblookup mediator guide</a></p> <h3>Syntax</h3> <pre xml:space="preserve"><dbreport> @@ -40,95 +42,89 @@ <parameter [value="" | expression=""] type="CHAR|VARCHAR|LONGVARCHAR|NUMERIC|DECIMAL|BIT|TINYINT|SMALLINT|INTEGER|BIGINT|REAL|FLOAT|DOUBLE|DATE|TIME|TIMESTAMP"/>* </statement>+ </dblreport></pre> - <h3>UI Configuration</h3> - <div class="image"> - <img src="../dbreport-mediator/docs/images/dbreport-options.png" alt=""/> - <p> - Figure 1: DBReport options - </p> - </div> - <p> - DBReport mediator options field descriptions, - </p> - <ul> - <li> - Connection Information - Specify whether the connection is - taken from a connection pool or from a data source - </li> - <li>Driver - Database driver</li> - <li>Url - JDBC URL of the database that data will be looked up.</li> - <li>User - Username that's used to connect to the database.</li> - <li> - Password - Password used to connect to the - database. - </li> - </ul> - <h3>Data sources</h3> - <div class="image"> - <img src="../dbreport-mediator/docs/images/ds.png" alt="Data Source"/> - </div> - <h4>Existing</h4> - <p>If existing data source is choosen, clicking "Load Data Sources" will give the available datasource. Then a data source can be selected.</p> - <h4>Inline</h4> - <p>Like in Pool connection data source configuration properties should be specified.</p> - <h4>Adding properties</h4> - <p> - Figure 2 shows the screen after clicking Add Property, - </p> - <div class="image"> - <img src="../dbreport-mediator/docs/images/db-properties.png" alt=""/> - <p>Figure 2: Adding a property </p> - </div> - <p>Property field descriptions,</p> - <ul> - <li> autocommit = true | false </li> - <li> - isolation = Connection.TRANSACTION_NONE | - Connection.TRANSACTION_READ_COMMITTED | - Connection.TRANSACTION_READ_UNCOMMITTED | - Connection.TRANSACTION_REPEATABLE_READ | - Connection.TRANSACTION_SERIALIZABLE - </li> - <li>initialsize = int </li> - <li> maxactive = int </li> - <li> maxidle = int </li> - <li> maxopenstatements = int </li> - <li> maxwait = long </li> - <li> minidle = int </li> - <li> poolstatements = true | false </li> - <li> testonborrow = true | false </li> - <li> testwhileidle = true | false </li> - <li> validationquery = String </li> - </ul> - <h4>Adding SQL statements</h4> - <ol> - <li> - Click Add Statement link shown in figure 2 and it'll open - up - the screen where you could enter SQL statement option. This is shown in - figure 3. - </li> - <li>More than one statement may be specified.</li> - </ol> - <ul> - <li> - The SQL statement may - specify parameters which could be specified as values or XPath - expressions. - </li> - <li> - The types of parameters could be any valid SQL types. - Only - the first row of a result set will be considered and any others are - ignored. - </li> - </ul> - <div class="image"> - <img src="../dbreport-mediator/docs/images/add-sql.png" alt=""/> - <p> - Figure 3: Adding SQL statements - </p> - </div> - <p></p> + +<h3>UI Configuration</h3> + +<div class="image"> +<img src="../dbreport-mediator/docs/images/dbreport-options.png" alt="" /> + +<p>Figure 1: DBReport options </p> +</div> + +<p>DBReport mediator options field descriptions, </p> +<ul> + <li>Connection Information - Specify whether the connection is taken from a + connection pool or from a data source </li> + <li>Driver - Database driver</li> + <li>Url - JDBC URL of the database that data will be looked up.</li> + <li>User - Username that's used to connect to the database.</li> + <li>Password - Password used to connect to the database. </li> +</ul> + +<h3>Data sources</h3> + +<div class="image"> +<img src="../dbreport-mediator/docs/images/ds.png" alt="Data Source" /> </div> + +<h4>Existing</h4> + +<p>If existing data source is choosen, clicking "Load Data Sources" will give +the available datasource. Then a data source can be selected.</p> + +<h4>Inline</h4> + +<p>Like in Pool connection data source configuration properties should be +specified.</p> + +<h4>Adding properties</h4> + +<p>Figure 2 shows the screen after clicking Add Property, </p> + +<div class="image"> +<img src="../dbreport-mediator/docs/images/db-properties.png" alt="" /> + +<p>Figure 2: Adding a property </p> +</div> + +<p>Property field descriptions,</p> +<ul> + <li>autocommit = true | false </li> + <li>isolation = Connection.TRANSACTION_NONE | + Connection.TRANSACTION_READ_COMMITTED | + Connection.TRANSACTION_READ_UNCOMMITTED | + Connection.TRANSACTION_REPEATABLE_READ | + Connection.TRANSACTION_SERIALIZABLE </li> + <li>initialsize = int </li> + <li>maxactive = int </li> + <li>maxidle = int </li> + <li>maxopenstatements = int </li> + <li>maxwait = long </li> + <li>minidle = int </li> + <li>poolstatements = true | false </li> + <li>testonborrow = true | false </li> + <li>testwhileidle = true | false </li> + <li>validationquery = String </li> +</ul> + +<h4>Adding SQL statements</h4> +<ol> + <li>Click Add Statement link shown in figure 2 and it'll open up the screen + where you could enter SQL statement option. This is shown in figure 3. </li> + <li>More than one statement may be specified.</li> +</ol> +<ul> + <li>The SQL statement may specify parameters which could be specified as + values or XPath expressions. </li> + <li>The types of parameters could be any valid SQL types. Only the first row + of a result set will be considered and any others are ignored. </li> +</ul> + +<div class="image"> +<img src="../dbreport-mediator/docs/images/add-sql.png" alt="" /> + +<p>Figure 3: Adding SQL statements </p> +</div> + +<p></p> </body> </html> _______________________________________________ Esb-java-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/esb-java-dev
