/** * Creates an SQL String for the stored procedure call. */ protected String createSqlString() { Procedure procedure = getProcedure(); StringBuffer buf = new StringBuffer(); int totalParams = callParams.size(); // check if procedure returns values if (procedure.isReturningValue()) { totalParams--; buf.append("{? = call "); } else { buf.append("{call "); } buf.append(procedure.getFullyQualifiedName()); if (totalParams > 0) { // unroll the loop buf.append("(?"); for (int i = 1; i < totalParams; i++) { buf.append(", ?"); } buf.append(")"); } buf.append("}"); return buf.toString(); }
if (procedure.getFullyQualifiedName().indexOf('.') > -1) { buf.append("\"").append(procedure.getFullyQualifiedName()).append("\""); buf.append(procedure.getFullyQualifiedName());
/** * Creates an SQL String for the stored procedure call. */ protected String createSqlString() { Procedure procedure = getProcedure(); StringBuilder buf = new StringBuilder(); int totalParams = callParams.size(); // check if procedure returns values if (procedure.isReturningValue()) { totalParams--; buf.append("{? = call "); } else { buf.append("{call "); } buf.append(procedure.getFullyQualifiedName()); if (totalParams > 0) { // unroll the loop buf.append("(?"); for (int i = 1; i < totalParams; i++) { buf.append(", ?"); } buf.append(")"); } buf.append("}"); return buf.toString(); }
if (procedure.getFullyQualifiedName().indexOf('.') > -1) { buf.append("\"").append(procedure.getFullyQualifiedName()).append("\""); buf.append(procedure.getFullyQualifiedName());
@Override protected void processResultSetRow(CatalogFilter catalog, SchemaFilter schema, DbLoadDataStore map, ResultSet rs) throws SQLException { String procSchema = rs.getString("PROCEDURE_SCHEM"); String procCatalog = rs.getString("PROCEDURE_CAT"); String name = rs.getString("PROCEDURE_NAME"); String key = Procedure.generateFullyQualifiedName(procCatalog, procSchema, name); Procedure procedure = map.getProcedure(name); // should be filtered out in getResultSet() method, but check full name here too.. if (procedure == null || !key.equals(procedure.getFullyQualifiedName())) { return; } ProcedureParameter column = loadProcedureParams(rs, key, procedure); if (column == null) { return; } procedure.addCallParameter(column); }
procedures.put(procedure.getFullyQualifiedName(), procedure);