com.vertica.jdbc.kv

Interface VerticaRoutableExecutor

public interface VerticaRoutableExecutor

An alternate API for KV queries that takes a SQL query as an argument, plus the column/value bindings that are necessary to compute the targeted node. Simply call the execute(String, Map) method (or, if there is only one column name/value pair, execute(String, String, Object)) to run query.

Both VerticaRoutableExecutor and the VGet API uses the same internal operations to route the queries.

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Release resource used by this VerticaRoutableExecutor - close the result set(s)
java.sql.ResultSet	execute(java.lang.String sql, java.util.Map<java.lang.String,java.lang.Object> segKey) Execute a query using these segmentation key values arguments.
java.sql.ResultSet	execute(java.lang.String sql, java.lang.String segCol, java.lang.Object value) Execute a query using a single column name/value pair as the routing information.
java.sql.SQLWarning	getWarnings() Get SQLWarning after an VGet.execute() call.

Method Detail

execute

java.sql.ResultSet execute(java.lang.String sql,
                         java.util.Map<java.lang.String,java.lang.Object> segKey)
                           throws java.sql.SQLException

Execute a query using these segmentation key values arguments.

Parameters:

sql - The query to be routed.

segKey - The map containing column name/value pairs.

Throws:

java.sql.SQLException - Query not routable or has failed.

execute

java.sql.ResultSet execute(java.lang.String sql,
                         java.lang.String segCol,
                         java.lang.Object value)
                           throws java.sql.SQLException

Execute a query using a single column name/value pair as the routing information.

Parameters:

sql - The query to be routed.

segCol - The column name.

value - The column value.

Throws:

java.sql.SQLException - Query not routable or has failed.

close

void close()
           throws java.sql.SQLException

Release resource used by this VerticaRoutableExecutor - close the result set(s)

Throws:

java.sql.SQLException

getWarnings

java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Get SQLWarning after an VGet.execute() call. See VGet.getWarnings()

Throws:

java.sql.SQLException