com.vertica.jdbc.kv

Interface VerticaRoutableExecutor

Deprecated.

This feature is likely to stop working in a future release and to be removed as a result.

@Deprecated
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

Modifier and Type	Method and Description
void	close() Deprecated. 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) Deprecated. 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) Deprecated. Execute a query using a single column name/value pair as the routing information.
java.sql.SQLWarning	getWarnings() Deprecated. 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

Deprecated.

Execute a query using these segmentation key values arguments.

Parameters:

sql - The query to be routed.

segKey - The map containing column name/value pairs.

Returns:

the result set created by the routable query.

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

Deprecated.

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.

Returns:

the result set created by the routable query.

Throws:

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

close

void close()
    throws java.sql.SQLException

Deprecated.

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

Throws:

java.sql.SQLException - close operation has failed.

getWarnings

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

Deprecated.

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

Returns:

SQLWarning from execute call.

Throws:

java.sql.SQLException - attempt to get warning has failed.