Examples of java.sql.CallableStatement.registerOutParameter()

java.sql.CallableStatement.registerOutParameter()
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method {@link #getObject} retrieves the value. @param parameterIndex the first parameter is 1, the second is 2,and so on @param sqlType the JDBC type code defined by java.sql.Types.If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used. @exception SQLException if the parameterIndex is not valid;if a database access error occurs or this method is called on a closed CallableStatement @exception SQLFeatureNotSupportedException if sqlType isa ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type @see Types

        DebugFile.writeln("Connection.prepareCall({ call k_sp_get_prod_fare('"+getStringNull(DB.gu_product,null)+"','"+sIdFare+"',?) }");
      }
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_get_prod_fare(?,?,?) }");
      oCall.setString(1, getStringNull(DB.gu_product,null));
      oCall.setString(2, sIdFare);
      oCall.registerOutParameter(3, java.sql.Types.DECIMAL);
      oCall.execute();
      oFare = oCall.getBigDecimal(3);
      oCall.close();
    }

View Full Code Here

    else {
      // Patched for MySQL at v 3.0.13
      oCall = oConn.prepareCall("{ call k_sp_cat_obj_position(?,?,?)}");
      oCall.setString(1, getString(DB.gu_product));
      oCall.setString(2, sCategoryId);
      oCall.registerOutParameter(3, Types.INTEGER);
      oCall.execute();
      oPos = oCall.getObject(3);
      oCall.close();
      oCall = null;
    }

View Full Code Here

         throw new Exception(
               "SpecificDefault.incrementReplKey: the DB connection is null");
      CallableStatement st = null;
      try {
         st = conn.prepareCall("{? = call " + this.replPrefix + "increment()}");
         st.registerOutParameter(1, Types.INTEGER);
         st.executeQuery();
         long ret = st.getLong(1);
         return ret;
      } finally {
         try {

View Full Code Here

      try {
         String sql = "{? = call " + this.replPrefix + "check_structure()}";
         conn = this.dbPool.reserve();
         conn.setAutoCommit(true);
         st = conn.prepareCall(sql);
         st.registerOutParameter(1, Types.VARCHAR);
         st.executeQuery();
      }
      catch (Exception ex) {
         conn = removeFromPool(conn, ROLLBACK_NO);
      }

View Full Code Here

               if (forceSend)
                  post = "<attr id='_forceSend'>true</attr>" + post;
               String destinationTxt = "<desc><attr id='_destination'>" + toString(destinations) + "</attr>" + post;
               st.setString(5, destinationTxt);
            }
            st.registerOutParameter(1, Types.VARCHAR);
            st.executeQuery();
            st.close();
            return false;
         }
         /*

View Full Code Here

      try {
         String sql = "{call dbms_alert.waitone(?,?,?,?)}";
         st = conn.prepareCall(sql);
         st.setString(1, event);
         st.setLong(4, timeout / 1000L);
         st.registerOutParameter(2, Types.VARCHAR);
         st.registerOutParameter(3, Types.INTEGER);
         st.executeQuery();
      }
      finally {
         if (st != null)

View Full Code Here

         String sql = "{call dbms_alert.waitone(?,?,?,?)}";
         st = conn.prepareCall(sql);
         st.setString(1, event);
         st.setLong(4, timeout / 1000L);
         st.registerOutParameter(2, Types.VARCHAR);
         st.registerOutParameter(3, Types.INTEGER);
         st.executeQuery();
      }
      finally {
         if (st != null)
            st.close();

View Full Code Here

      oCall = oConn.prepareCall("{ call k_sp_read_pageset (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }");


      clear();


      oCall.setObject(1, aPK[0], Types.CHAR);       // gu_pageset
      oCall.registerOutParameter(2, Types.CHAR);    // gu_microsite
      oCall.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oCall.registerOutParameter(4, Types.CHAR);    // gu_workarea
      oCall.registerOutParameter(5, Types.VARCHAR); // nm_pageset
      oCall.registerOutParameter(6, Types.VARCHAR); // vs_stamp
      oCall.registerOutParameter(7, Types.CHAR); // id_language

View Full Code Here


      clear();


      oCall.setObject(1, aPK[0], Types.CHAR);       // gu_pageset
      oCall.registerOutParameter(2, Types.CHAR);    // gu_microsite
      oCall.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oCall.registerOutParameter(4, Types.CHAR);    // gu_workarea
      oCall.registerOutParameter(5, Types.VARCHAR); // nm_pageset
      oCall.registerOutParameter(6, Types.VARCHAR); // vs_stamp
      oCall.registerOutParameter(7, Types.CHAR); // id_language
      oCall.registerOutParameter(8, Types.TIMESTAMP); // dt_modified

View Full Code Here

      clear();


      oCall.setObject(1, aPK[0], Types.CHAR);       // gu_pageset
      oCall.registerOutParameter(2, Types.CHAR);    // gu_microsite
      oCall.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oCall.registerOutParameter(4, Types.CHAR);    // gu_workarea
      oCall.registerOutParameter(5, Types.VARCHAR); // nm_pageset
      oCall.registerOutParameter(6, Types.VARCHAR); // vs_stamp
      oCall.registerOutParameter(7, Types.CHAR); // id_language
      oCall.registerOutParameter(8, Types.TIMESTAMP); // dt_modified
      oCall.registerOutParameter(9, Types.VARCHAR); // path_data

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.