CallStoredProcedure


1   package transactions;
2   
3   import java.sql.CallableStatement  ;
4   import dinamica.*;
5   
6   /**
7    * Sampe code that shows how to invoke a stored procedure
8    * using JDBC API and capture output parameters.
9    * <br><br>
10   * (c) 2004 Martin Cordova<br>
11   * This code is released under the LGPL license<br>
12   * Dinamica Framework - http://www.martincordova.com
13   * @author Martin Cordova (dinamica@martincordova.com)
14   * */
15  public class GetTicketOwner extends GenericTransaction
16  {
17  
18      /* (non-Javadoc)
19       * @see dinamica.GenericTransaction#service(dinamica.Recordset)
20       */
21      public int service(Recordset inputParams) throws Throwable  
22      {
23          int rc = 0;
24          
25          //reuse superclass code
26          super.service(inputParams);
27  
28          CallableStatement   ps = null;
29          
30          try 
31          {
32              String   sql = "{call getTicketOwner(?, ?)}";
33              ps = getConnection().prepareCall(sql);
34              ps.setInt(1, 1415);
35              ps.registerOutParameter(2, java.sql.Types.VARCHAR);
36              ps.executeUpdate();
37              String   owner = ps.getString(2);
38              getRequest().setAttribute("owner", owner);
39          }
40          catch (Throwable   e)
41          {
42              throw e;
43          }
44          finally
45          {
46              if (ps!=null)
47                  ps.close();
48          }       
49          
50          return rc;
51      }
52  
53  }
54
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags