Interface RelationalStatement
- All Superinterfaces:
AutoCloseable
,RelationalDirectAccessStatement
,Statement
,Wrapper
Extension of
Statement
to allow support for non-query database access.
There are two ways that the database can be accessed:
- Query Language
- The Query language used by Relational is a subset of the PartiQL Spec.
- Direct Access
- The Direct Access API allows a user to access simplified database-like functions without requiring the writing of a SQL query. Its primary purpose for existing is historical, to allow for easier integration support with existing system users, and is not (generally) recommended for new use cases.
Direct Access API Details
The Direct Access API allows simplified execution of the following functionality:
- Get By Key
- Scan By Key range
- Insert one or more records
- Delete one or more records
-
Field Summary
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
-
Method Summary
Modifier and TypeMethodDescriptiondefault void
default void
cancel()
default void
default void
default void
default boolean
default boolean
default boolean
default int[]
executeQuery
(String sql) default int
executeUpdate
(String sql, int autoGeneratedKeys) default int
executeUpdate
(String sql, int[] columnIndexes) default int
executeUpdate
(String sql, String[] columnNames) default int
default int
default ResultSet
default int
default boolean
default boolean
getMoreResults
(int current) default int
default int
default int
default int
default int
default SQLWarning
default boolean
default boolean
default boolean
isWrapperFor
(Class<?> iface) default void
setCursorName
(String name) default void
setEscapeProcessing
(boolean enable) default void
setFetchDirection
(int direction) default void
setFetchSize
(int rows) default void
setMaxFieldSize
(int max) default void
setPoolable
(boolean poolable) default void
setQueryTimeout
(int seconds) default <T> T
Methods inherited from interface com.apple.foundationdb.relational.api.RelationalDirectAccessStatement
close, executeDelete, executeDelete, executeDelete, executeDelete, executeDeleteRange, executeGet, executeInsert, executeInsert, executeInsert, executeInsert, executeScan
Methods inherited from interface java.sql.Statement
close, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, getConnection, getLargeMaxRows, getLargeUpdateCount, getMaxRows, isClosed, isSimpleIdentifier, setLargeMaxRows, setMaxRows
-
Method Details
-
executeQuery
- Specified by:
executeQuery
in interfaceStatement
- Throws:
SQLException
-
getResultSet
- Specified by:
getResultSet
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
getMaxFieldSize
- Specified by:
getMaxFieldSize
in interfaceStatement
- Throws:
SQLException
-
setMaxFieldSize
- Specified by:
setMaxFieldSize
in interfaceStatement
- Throws:
SQLException
-
setEscapeProcessing
- Specified by:
setEscapeProcessing
in interfaceStatement
- Throws:
SQLException
-
getQueryTimeout
- Specified by:
getQueryTimeout
in interfaceStatement
- Throws:
SQLException
-
setQueryTimeout
- Specified by:
setQueryTimeout
in interfaceStatement
- Throws:
SQLException
-
cancel
- Specified by:
cancel
in interfaceStatement
- Throws:
SQLException
-
getWarnings
- Specified by:
getWarnings
in interfaceStatement
- Throws:
SQLException
-
clearWarnings
- Specified by:
clearWarnings
in interfaceStatement
- Throws:
SQLException
-
setCursorName
- Specified by:
setCursorName
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
getUpdateCount
- Specified by:
getUpdateCount
in interfaceStatement
- Throws:
SQLException
-
getMoreResults
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
-
getMoreResults
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
-
setFetchDirection
- Specified by:
setFetchDirection
in interfaceStatement
- Throws:
SQLException
-
getFetchDirection
- Specified by:
getFetchDirection
in interfaceStatement
- Throws:
SQLException
-
setFetchSize
- Specified by:
setFetchSize
in interfaceStatement
- Throws:
SQLException
-
getFetchSize
- Specified by:
getFetchSize
in interfaceStatement
- Throws:
SQLException
-
getResultSetConcurrency
- Specified by:
getResultSetConcurrency
in interfaceStatement
- Throws:
SQLException
-
getResultSetType
- Specified by:
getResultSetType
in interfaceStatement
- Throws:
SQLException
-
addBatch
- Specified by:
addBatch
in interfaceStatement
- Throws:
SQLException
-
clearBatch
- Specified by:
clearBatch
in interfaceStatement
- Throws:
SQLException
-
executeBatch
- Specified by:
executeBatch
in interfaceStatement
- Throws:
SQLException
-
getGeneratedKeys
- Specified by:
getGeneratedKeys
in interfaceStatement
- Throws:
SQLException
-
getResultSetHoldability
- Specified by:
getResultSetHoldability
in interfaceStatement
- Throws:
SQLException
-
setPoolable
- Specified by:
setPoolable
in interfaceStatement
- Throws:
SQLException
-
isPoolable
- Specified by:
isPoolable
in interfaceStatement
- Throws:
SQLException
-
closeOnCompletion
- Specified by:
closeOnCompletion
in interfaceStatement
- Throws:
SQLException
-
isCloseOnCompletion
- Specified by:
isCloseOnCompletion
in interfaceStatement
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-