public ProcedureBatchHandler(Call proc, ProcedureExecution procExec) { this.proc = proc; this.procExec = procExec; List<Argument> params = proc.getArguments(); resultSetCols = proc.getResultSetColumnTypes().length; if (proc.getReturnType() != null) { paramCols++; } if(params != null && !params.isEmpty()){ for (Argument param : params) { if(param.getDirection() == Direction.OUT || param.getDirection() == Direction.INOUT){ paramCols += 1; } } } if (paramCols > 0) { filler = Collections.nCopies(paramCols, null); } }
public ProcedureBatchHandler(Call proc, ProcedureExecution procExec) { this.proc = proc; this.procExec = procExec; List<Argument> params = proc.getArguments(); resultSetCols = proc.getResultSetColumnTypes().length; if (proc.getReturnType() != null) { paramCols++; } if(params != null && !params.isEmpty()){ for (Argument param : params) { if(param.getDirection() == Direction.OUT || param.getDirection() == Direction.INOUT){ paramCols += 1; } } } if (paramCols > 0) { filler = Collections.nCopies(paramCols, null); } }
public ProcedureBatchHandler(Call proc, ProcedureExecution procExec) { this.proc = proc; this.procExec = procExec; List<Argument> params = proc.getArguments(); resultSetCols = proc.getResultSetColumnTypes().length; if (proc.getReturnType() != null) { paramCols++; } if(params != null && !params.isEmpty()){ for (Argument param : params) { if(param.getDirection() == Direction.OUT || param.getDirection() == Direction.INOUT){ paramCols += 1; } } } if (paramCols > 0) { filler = Collections.nCopies(paramCols, null); } }
if (arg.getDirection() != Direction.IN) { throw new IllegalArgumentException(DataPlugin.Util.getString("SQLConversionVisitor.not_in_parameter", index+1)); //$NON-NLS-1$
if(param.getDirection() == Direction.IN || param.getDirection() == Direction.OUT || param.getDirection() == Direction.INOUT){ if(numberOfParameters > 0){ prepareCallBuffer.append(","); //$NON-NLS-1$
public void visit(Call obj) { appendCallStart(obj); if(obj.getMetadataObject() != null) { buffer.append(getName(obj.getMetadataObject())); } else { buffer.append(obj.getProcedureName()); } buffer.append(Tokens.LPAREN); final List<Argument> params = obj.getArguments(); if (params != null && params.size() != 0) { Argument param = null; for (int i = 0; i < params.size(); i++) { param = params.get(i); if (param.getDirection() == Direction.IN || param.getDirection() == Direction.INOUT) { if (i != 0) { buffer.append(Tokens.COMMA) .append(Tokens.SPACE); } append(param); } } } buffer.append(Tokens.RPAREN); }
private boolean setOutCursorType(Call call) { boolean set = false; for (Argument arg : call.getArguments()) { if (arg.getDirection() == Direction.OUT) { ProcedureParameter param = arg.getMetadataObject(); if (param != null && REF_CURSOR.equalsIgnoreCase(param.getNativeType())) { arg.setType(RefCursorType.class); set = true; } } } return set; }
static String getQueryParameters(Call obj) throws EdmPrimitiveTypeException { StringBuilder sb = new StringBuilder(); final List<Argument> params = obj.getArguments(); if (params != null && params.size() != 0) { Argument param = null; for (int i = 0; i < params.size(); i++) { param = params.get(i); if (param.getDirection() == Direction.IN || param.getDirection() == Direction.INOUT) { if (i != 0) { sb.append("&"); //$NON-NLS-1$ } sb.append(WSUtil.httpURLEncode(param.getMetadataObject().getName())); sb.append(Tokens.EQ); sb.append(WSUtil.httpURLEncode(ODataTypeManager.convertToODataURIValue(param.getArgumentValue().getValue(), ODataTypeManager.odataType(param.getType()).getFullQualifiedName() .getFullQualifiedNameAsString()))); } } } return sb.toString(); }
Argument param = (Argument)iter.next(); if(param.getDirection() == Direction.INOUT){ registerSpecificTypeOfOutParameter(statement,param.getType(), index); }else if(param.getDirection() == Direction.OUT){ registerSpecificTypeOfOutParameter(statement,param.getType(), index++); if(param.getDirection() == Direction.IN || param.getDirection() == Direction.INOUT){ bindValue(statement, param.getArgumentValue().getValue(), param.getType(), index++);
public void testGetDirection() throws Exception { assertEquals(Direction.IN, example(0).getDirection()); assertEquals(Direction.IN, example(1).getDirection()); }
for (int i = 0; i < params.size(); i++) { param = params.get(i); if (param.getDirection() == Direction.IN || param.getDirection() == Direction.INOUT) { if (i != 0) { this.buffer.append("&"); //$NON-NLS-1$
ProcedureParameter metadata = param.getMetadataObject(); String argName = WSUtil.httpURLEncode(param.getMetadataObject().getName()); if (param.getDirection() == Direction.IN || param.getDirection() == Direction.INOUT) { String in = metadata.getProperty(RestMetadataExtension.PARAMETER_TYPE, false); if (in.equalsIgnoreCase(RestMetadataExtension.ParameterType.QUERY.name())) {
@Override public List<?> getOutputParameterValues() throws TranslatorException { try { Call proc = (Call)this.command; List<Object> result = new ArrayList<Object>(); int paramIndex = 1; if (proc.getReturnType() != null) { if (proc.getReturnParameter() != null) { addParameterValue(result, paramIndex, proc.getReturnType()); } paramIndex++; } for (Argument parameter : proc.getArguments()) { switch (parameter.getDirection()) { case IN: paramIndex++; break; case INOUT: case OUT: addParameterValue(result, paramIndex++, parameter.getType()); break; } } return result; } catch (SQLException e) { throw new TranslatorException(JDBCPlugin.Event.TEIID11005, e); } }