-
Convert the query to a DTO bean query.
Convert the query to a DTO bean query.
Create a named Query for DTO beans.
Create a Query for DTO beans.
Create a Query for DTO beans.
Bind the named multi-value array parameter which we would use with Postgres ANY.
A hint which for JDBC translates to the Statement.fetchSize().
Set the index of the first row of the results to return.
Set a label on the query to make it easier to identify queries related to query execution statistics.
Set the maximum number of query results to return.
Bind the parameter by its index position (1 based like JDBC).
Bind the next parameter using index position.
Bind the named parameter.
Bind all the parameters using index positions.
Set the profile location of this query.
When resultSet columns are not able to be mapped to a bean property then instead of
throwing effectively skip reading that column.
Set a timeout on this query.
Use the explicit transaction to execute the query.