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 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 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.