java.sql.PreparedStatement#getMoreResults

Source File: ResultSetReturnImpl.java From lams with GNU General Public License v2.0

6 votes

@Override
public ResultSet execute(PreparedStatement statement) {
	// sql logged by StatementPreparerImpl
	try {
		final ResultSet rs;
		try {
			jdbcExecuteStatementStart();
			if ( !statement.execute() ) {
				while ( !statement.getMoreResults() && statement.getUpdateCount() != -1 ) {
					// do nothing until we hit the resultset
				}
			}
			rs = statement.getResultSet();
		}
		finally {
			jdbcExecuteStatementEnd();
		}
		postExtract( rs, statement );
		return rs;
	}
	catch (SQLException e) {
		throw sqlExceptionHelper.convert( e, "could not execute statement" );
	}
}

Source File: Swarm.java From gemfirexd-oss with Apache License 2.0

6 votes

public static DUnitMethodInfo getOrCreateDUnitMethodInfo(String name,
    int class_id) throws SQLException {
  PreparedStatement ps = Database
      .prepareStatement("SELECT id from dunit_test_method where name=? and test_class_id=?");
  ps.setString(1, name);
  ps.setInt(2, class_id);
  ResultSet rs = ps.executeQuery();
  if (rs.next()) {
    DUnitMethodInfo duci = new DUnitMethodInfo(rs.getInt(1), name, class_id);
    return duci;
  }
  else {
    PreparedStatement psi = Database
        .prepareStatement("INSERT INTO dunit_test_method(name,test_class_id) values(?,?);SELECT currval('dunit_test_method_id_seq');");
    psi.setString(1, name);
    psi.setInt(2, class_id);
    psi.execute();
    psi.getMoreResults();
    ResultSet rsi = psi.getResultSet();
    rsi.next();
    System.out.println("2XXXXX:" + rsi.getInt(1));
    return new DUnitMethodInfo(rsi.getInt(1), name, class_id);
  }
}

Source File: Swarm.java From gemfirexd-oss with Apache License 2.0

6 votes

public static DUnitClassInfo getOrCreateDUnitClassInfo(String name)
    throws SQLException {
  PreparedStatement ps = Database
      .prepareStatement("SELECT ID,NAME from dunit_test_class where name=?");
  ps.setString(1, name);
  ResultSet rs = ps.executeQuery();
  if (rs.next()) {
    DUnitClassInfo duci = new DUnitClassInfo(rs.getInt(1), rs.getString(2));
    return duci;
  }
  else {
    PreparedStatement psi = Database
        .prepareStatement("INSERT INTO dunit_test_class(name) values(?);SELECT currval('dunit_test_class_id_seq');");
    psi.setString(1, name);
    psi.execute();
    psi.getMoreResults();
    ResultSet rsi = psi.getResultSet();
    rsi.next();
    System.out.println("XXXXX:" + rsi.getInt(1));
    return new DUnitClassInfo(rsi.getInt(1), name);
  }
}

Source File: Swarm.java From gemfirexd-oss with Apache License 2.0

6 votes

public static DUnitClassInfo getOrCreateDUnitClassInfo(String name)
    throws SQLException {
  PreparedStatement ps = Database
      .prepareStatement("SELECT ID,NAME from dunit_test_class where name=?");
  ps.setString(1, name);
  ResultSet rs = ps.executeQuery();
  if (rs.next()) {
    DUnitClassInfo duci = new DUnitClassInfo(rs.getInt(1), rs.getString(2));
    return duci;
  }
  else {
    PreparedStatement psi = Database
        .prepareStatement("INSERT INTO dunit_test_class(name) values(?);SELECT currval('dunit_test_class_id_seq');");
    psi.setString(1, name);
    psi.execute();
    psi.getMoreResults();
    ResultSet rsi = psi.getResultSet();
    rsi.next();
    System.out.println("XXXXX:" + rsi.getInt(1));
    return new DUnitClassInfo(rsi.getInt(1), name);
  }
}

Source File: ProcedureJdbcTemplate.java From opscenter with Apache License 2.0

6 votes

/**
 * 创建结果集列表
 * @param cstmt
 * @param rs
 * @return List<List<Map<String, Object>>>
 * @throws IOException
 */
public List<List<Map<String, Object>>> createRows(PreparedStatement ps, ResultSet rs) throws IOException{
	List<List<Map<String, Object>>> list = new ArrayList<>();
	RowMapperResultSetExtractor<Map<String, Object>> rse = new RowMapperResultSetExtractor<>(new ColumnMapRowMapper());
	boolean label = true;
	int health = 0;
	while(label){
		try {
			rs=ps.getResultSet();
			if(rs !=null){
				list.add(rse.extractData(rs));
		    	label = ps.getMoreResults();
		    	health++;
		    	if(health > MAX_LOOP) break;
				continue;
		    }
		    label = false;
		} catch (SQLException e) {
			label = false;
		}
	}
	return list;
}

Source File: IdentityGenerator.java From cacheonix-core with GNU Lesser General Public License v2.1

5 votes

public Serializable executeAndExtract(PreparedStatement insert) throws SQLException {
	if ( !insert.execute() ) {
		while ( !insert.getMoreResults() && insert.getUpdateCount() != -1 ) {
			// do nothing until we hit the rsult set containing the generated id
		}
	}
	ResultSet rs = insert.getResultSet();
	try {
		return IdentifierGeneratorFactory.getGeneratedIdentity( rs, persister.getIdentifierType() );
	}
	finally {
		rs.close();
	}
}

Source File: JdbcStatement.java From quarks with Apache License 2.0

5 votes

private void executeStatement(T tuple, List<R> results) {
    nTuples++;
    try {
        logger.debug("executing statement nTuples={} nTuplesFailed={}", nTuples, nTuplesFailed);
        Connection cn = connector.getConnection(this);
        PreparedStatement stmt = getPreparedStatement(cn);
        paramSetter.setParameters(tuple, stmt);
        boolean hasResult = stmt.execute();
        if (resultsHandler != null) {
            if (!hasResult) {
                resultsHandler.handleResults(tuple, null/*rs*/, null/*exc*/,
                        (result) -> results.add(result));
            }
            else {
                do {
                    try (ResultSet rs = stmt.getResultSet()) {
                        resultsHandler.handleResults(tuple, rs, null/*exc*/,
                                (result) -> results.add(result));
                    }
                } while (stmt.getMoreResults());
            }
        }
    }
    catch (Exception e) {
        nTuplesFailed++;
        logger.trace("executing statement failed nTuples={} nTuplesFailed={}", nTuples, nTuplesFailed);
        if (resultsHandler != null) {
            try {
                resultsHandler.handleResults(tuple, null/*rs*/, e, 
                        (result) -> results.add(result));
            }
            catch (Exception e2) {
                logger.error("failure result handler failed", e2);
            }
        }
        closeStmt();
        connector.statementFailed(this, e);
    }
}