ws-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Ws Wiki] Update of "Tuscany/TuscanyJava/DAS Java Overview/RDBDAS Java User Guide/Stored Procedures" by antelder
Date Wed, 11 Oct 2006 07:33:35 GMT
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


Mime
View raw message