You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ws.apache.org by Apache Wiki <wi...@apache.org> on 2006/10/11 09:33:35 UTC

[Ws Wiki] Update of "Tuscany/TuscanyJava/DAS Java Overview/RDBDAS Java User Guide/Stored Procedures" by antelder

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Ws Wiki" for change notification.

The following page has been changed by antelder:
http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/RDBDAS_Java_User_Guide/Stored_Procedures

------------------------------------------------------------------------------
- The DAS can work with stored procedures in the same way it works with SQL statements.  The follwing example shoud look familiar except that a stored prcedure call statement replaces the typical SELECT statement:
+ The DAS can work with stored procedures in the same way it works with SQL statements.  The follwing example should look familiar except that a stored prcedure call statement replaces the typical SELECT statement:
  
  {{{
     DAS das = DAS.FACTORY.createDAS(getConnection());
@@ -8, +8 @@

     DataObject root = read.executeQuery();
  }}}
  
- The predefined stored procedure "GETALLCOMPANIES" returnes a result just like "select * from company" would.  There are, however, procedures that do not return results and these call also be executed with the same programming model.  In fact any arbitrary stored procedure can invoked in this way. The follwing example calls a proc that deletes an identified company:
+ The predefined stored procedure "GETALLCOMPANIES" returnes a result just like "select * from company" would.  There are, however, procedures that do not return results and these calls can also be executed with the same programming model.  In fact any arbitrary stored procedure can be invoked in this way. The follwing example calls a proc that deletes an identified company:
  
  {{{
     DAS das = DAS.FACTORY.createDAS(getConnection());
@@ -17, +17 @@

     delete.execute();
  }}}
  
- Stored procedure may also provide IN/OUT and OUT parameters.  The following illustrates the use of a stored procedure that returns a result set as well as an OUT parameter:
+ Stored procedures may also provide IN/OUT and OUT parameters.  The following illustrates the use of a stored procedure that returns a result set as well as an OUT parameter:
  
  {{{
     DAS das = DAS.FACTORY.createDAS(getConfig("storedProcTest.xml"), getConnection());

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org