Clients -
java.jdbc :
Client
Represents a JDBC client endpoint.
Constructor
__init
Remote Methods
The call remote function implementation for JDBC Client to invoke stored procedures/functions.
The select remote function implementation for JDBC Client to select data from tables.
The update remote function implementation for JDBC Client to update data and schema of the database.
The batchUpdate remote function implementation for JDBC Client to batch data insert.
Methods
The call remote function implementation for JDBC Client to invoke stored procedures/functions.
The select remote function implementation for JDBC Client to select data from tables.
The update remote function implementation for JDBC Client to update data and schema of the database.
Parameters
- sqlQuery string
-
SQL statement to execute
- parameters Param[]
-
The parameters to be passed to the update query. The number of parameters is variable
-
Return Type
(UpdateResult | Error) UpdateResult
with the updated row count and key column values, elseError
will be returned if there is any error
batchUpdate
(string sqlQuery, boolean rollbackAllInFailure, Param[] parameters)
returns BatchUpdateResultThe batchUpdate remote function implementation for JDBC Client to batch data insert.
Parameters
- sqlQuery string
-
SQL statement to execute
- rollbackAllInFailure boolean
-
If one of the commands in a batch update fails to execute properly, the JDBC driver may or may not continue to process the remaining commands in the batch. But this property can be used to override this behavior. If it is sets to true, if there is a failure in few commands and JDBC driver continued with the remaining commands, the successfully executed commands in the batch also will get rollback.
- parameters Param[]
-
Variable number of parameter arrays each representing the set of parameters of belonging to each individual update
-
Return Type
(BatchUpdateResult) A
BatchUpdateResult
with the updated row count and returned error. If all the commands in the batch has executed successfully, the error will benil
. If one or more commands has failed, thereturnedError
field will give the correspoingJdbcClientError
along with the int[] which conains updated row count or the status returned from the each command in the batch.