Examples of SqlParameter

cn.org.rapid_framework.generator.provider.db.sql.model.SqlParameter
org.springframework.jdbc.core.SqlParameter
Object to represent a SQL parameter definition.
Parameters may be anonymous, in which case "name" is null. However, all parameters must define a SQL type according to {@link java.sql.Types}. @author Rod Johnson @author Thomas Risberg @author Juergen Hoeller @see java.sql.Types

Examples of org.springframework.jdbc.core.SqlParameter

      if (meta.getParameterName() != null)
        parNameToCheck = metaDataProvider.parameterNameToUse(meta.getParameterName()).toLowerCase();
      String parNameToUse = metaDataProvider.parameterNameToUse(meta.getParameterName());
      if (declaredParameters.containsKey(parNameToCheck) ||
          (meta.getParameterType() == DatabaseMetaData.procedureColumnReturn && returnDeclared)) {
        SqlParameter parameter;
        if (meta.getParameterType() == DatabaseMetaData.procedureColumnReturn) {
          parameter = declaredParameters.get(this.getFunctionReturnName());
          if (parameter == null && this.getOutParameterNames().size() > 0) {
            parameter = declaredParameters.get(this.getOutParameterNames().get(0).toLowerCase());
          }
          if (parameter == null) {
            throw new InvalidDataAccessApiUsageException(
                "Unable to locate declared parameter for function return value - " +
                    " add an SqlOutParameter with name \"" + this.getFunctionReturnName() +"\"");
          }
          else {
            this.setFunctionReturnName(parameter.getName());
          }
        }
        else {
          parameter = declaredParameters.get(parNameToCheck);
        }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

        parNameToCheck = this.metaDataProvider.parameterNameToUse(meta.getParameterName()).toLowerCase();
      }
      String parNameToUse = this.metaDataProvider.parameterNameToUse(meta.getParameterName());
      if (declaredParameters.containsKey(parNameToCheck) ||
          (meta.getParameterType() == DatabaseMetaData.procedureColumnReturn && returnDeclared)) {
        SqlParameter parameter;
        if (meta.getParameterType() == DatabaseMetaData.procedureColumnReturn) {
          parameter = declaredParameters.get(this.getFunctionReturnName());
          if (parameter == null && this.getOutParameterNames().size() > 0) {
            parameter = declaredParameters.get(this.getOutParameterNames().get(0).toLowerCase());
          }
          if (parameter == null) {
            throw new InvalidDataAccessApiUsageException(
                "Unable to locate declared parameter for function return value - " +
                    " add an SqlOutParameter with name \"" + getFunctionReturnName() +"\"");
          }
          else {
            this.setFunctionReturnName(parameter.getName());
          }
        }
        else {
          parameter = declaredParameters.get(parNameToCheck);
        }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  @Override
  public Object convertOutputValue(SqlParameter sqlParameter, Object value){
    CallMetaDataProvider metaDataProvider = callMetaDataContext.getMetaDataProvider();
    
    if (metaDataProvider instanceof VendorTypeHandler){
      SqlParameter logicalParameter = getLogicalParameterByDbName(sqlParameter.getName());
    
      if (logicalParameter instanceof TypedSqlOutParameter){
        return ((VendorTypeHandler)callMetaDataContext.getMetaDataProvider()).transformOutputValue(getJdbcTemplate(), sqlParameter, value, ((TypedSqlOutParameter)logicalParameter).getType());
      }
    }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  @SuppressWarnings("nls")
  @Override
  protected void onCompileInternal(){
    Iterator<SqlParameter> logicalParametersIterator = logicalParameters.iterator();
    List<SqlParameter> callParameters = getCallParameters();
    SqlParameter logicalParameter;
    Object value = null;
    int index = 0;
    
    compiled = true;
    
    for (SqlParameter callParameter : callParameters){
      if (!logicalParametersIterator.hasNext()){
        // Metadata has more parameters than were passed
        throw new BadSqlGrammarException("JDBC Call", this.getCallString(), new SQLException("Not enough parameters provided."));
      }
      
      // The logical name is the name this parameter is known as to a client
      logicalParameter = logicalParametersIterator.next();
      
      // Map the database parameter name to the logical parameter and the logical
      // parameter name to the db name
      dbNameToLogicalParameterMap.put(callParameter.getName(), logicalParameter);
      logicalNameToDbNameMap.put(logicalParameter.getName(), callParameter.getName());
      
      // If this is an IN or IN/OUT parameter, map the database name to
      // the value supplied by the client.  Calls convertInputValue to
      // give subclasses a chance to convert the provided input value.
      if (callParameter.isInputValueProvided()){

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

   * db name.
   * 
   * @param dbName the name of the parameter as defined in the db
   */
  protected String getLogicalParameterName(String dbName){
    SqlParameter parameter = dbNameToLogicalParameterMap.get(dbName);
    
    return parameter != null ? parameter.getName() : null;
  }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

      if (isRefCursorType(meta)){
        throw new UnsupportedOperationException("A ref cursor is not supported as an input parameter.");
      }else if (isPLSQLRecordType(meta)){
        throw new UnsupportedOperationException("A PL/SQL record is not currently supported as an input parameter.");
      }else if (isArrayType(meta)){
        return new SqlParameter(parameterName, getArrayType(), getArgumentType(meta));
      }else if (isFloatType(meta)){
        return new SqlParameter(parameterName, OracleTypes.FLOAT);
      }else{
        return new SqlParameter(parameterName, getStructType(), meta.getTypeName());
      }
    }


    return super.createDefaultInParameter(parameterName, meta);
  }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  protected void compileInternal() {
    this.callMetaDataContext.initializeMetaData(getJdbcTemplate().getDataSource());


    // iterate over the declared RowMappers and register the corresponding SqlParameter
    for (Map.Entry<String, ParameterizedRowMapper> entry : this.declaredRowMappers.entrySet()) {
      SqlParameter resultSetParameter =
          this.callMetaDataContext.createReturnResultSetParameter(entry.getKey(), entry.getValue());
      this.declaredParameters.add(resultSetParameter);
    }
    callMetaDataContext.processParameters(this.declaredParameters);

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  protected void compileInternal() {
    this.callMetaDataContext.initializeMetaData(getJdbcTemplate().getDataSource());


    // iterate over the declared RowMappers and register the corresponding SqlParameter
    for (Map.Entry<String, RowMapper> entry : this.declaredRowMappers.entrySet()) {
      SqlParameter resultSetParameter =
          this.callMetaDataContext.createReturnResultSetParameter(entry.getKey(), entry.getValue());
      this.declaredParameters.add(resultSetParameter);
    }
    callMetaDataContext.processParameters(this.declaredParameters);

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

    List<String> paramNames = parsedSql.getParameterNames();
    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

          return declaredParam;
        }
      }
      // Second pass: Look for parameter index match.
      if (paramIndex < declaredParams.size()) {
        SqlParameter declaredParam = declaredParams.get(paramIndex);
        // Only accept unnamed parameters for index matches.
        if (declaredParam.getName() == null) {
          return declaredParam;
        }
      }
    }
    return null;

View Full Code Here

0 1 2 3 4 5

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.