@Override public Integer getJdbcType() { return parameter.getType(); }
public int getType() { return parameter.getType(); }
/** * Sets a single OUT parameter of the CallableStatement. */ protected void setOutParam(CallableStatement stmt, ProcedureParameter param, int pos) throws Exception { int precision = param.getPrecision(); if (precision >= 0) { stmt.registerOutParameter(pos, param.getType(), precision); } else { stmt.registerOutParameter(pos, param.getType()); } } }
/** * Sets a single OUT parameter of the CallableStatement. */ protected void setOutParam(CallableStatement stmt, ProcedureParameter param, int pos) throws Exception { int precision = param.getPrecision(); if (precision >= 0) { stmt.registerOutParameter(pos, param.getType(), precision); } else { stmt.registerOutParameter(pos, param.getType()); } } }
protected String getParameterType(ProcedureParameter parameter) { return TypesMapping.getSqlNameByType(parameter.getType()); }
/** * Sets a single IN parameter of the CallableStatement. */ protected void setInParam( CallableStatement stmt, ProcedureParameter param, Object val, int pos) throws Exception { int type = param.getType(); adapter.bindParameter(stmt, val, pos, type, param.getPrecision()); }
/** * Creates and binds a PreparedStatement to execute query SQL via JDBC. */ public PreparedStatement createStatement() throws Exception { this.callParams = getProcedure().getCallParameters(); this.values = new ArrayList<>(callParams.size()); initValues(); String sqlStr = createSqlString(); if (logger.isLoggable()) { // need to convert OUT/VOID parameters to loggable strings ParameterBinding[] parameterBindings = new ParameterBinding[values.size()]; for (int i=0; i<values.size(); i++) { ProcedureParameter procedureParameter = callParams.get(i); Object value = values.get(i); if(value instanceof NotInParam) { value = value.toString(); } parameterBindings[i] = new ParameterBinding(value, procedureParameter.getType(), procedureParameter.getPrecision()); } logger.logQuery(sqlStr, parameterBindings); } CallableStatement stmt = connection.prepareCall(sqlStr); initStatement(stmt); return stmt; }
/** * Creates a ColumnDescriptor from stored procedure parameter. * * @since 1.2 */ public ColumnDescriptor(ProcedureParameter parameter) { this(parameter.getName(), parameter.getType()); if (parameter.getProcedure() != null) { this.procedureName = parameter.getProcedure().getName(); } }
if (parameter.getType() == OracleAdapter.getOracleCursorType()) { ResultSet rs = (ResultSet) statement.getObject(i + 1);
/** * Creates a ColumnDescriptor from stored procedure parameter. * * @since 1.2 */ public ColumnDescriptor(ProcedureParameter parameter) { this.name = parameter.getName(); this.qualifiedColumnName = name; this.label = name; this.jdbcType = parameter.getType(); this.javaClass = getDefaultJavaClass(parameter.getMaxLength(), parameter .getPrecision()); if (parameter.getProcedure() != null) { this.procedureName = parameter.getProcedure().getName(); } }
if (parameter.getType() == OracleAdapter.getOracleCursorType()) {
+ '\"'); String type = TypesMapping.getSqlNameByType(getType()); if (type != null) { encoder.print(" type=\"" + type + '\"');
+ '\"'); String type = TypesMapping.getSqlNameByType(getType()); if (type != null) { encoder.print(" type=\"" + type + '\"');