Execute an update or delete statement.

The position of the first result the query object was set to retrieve. Returns 0 if setFirstResult was not applied to the query object.

Get the flush mode in effect for the query execution. If a flush mode has not been set for the query object, returns the flush mode in effect for the entity manager.

Get the properties and hints and associated values that are in effect for the query instance.

Get the current lock mode for the query.

The maximum number of results the query object was set to retrieve. Returns Integer.MAX_VALUE if setMaxResults was not applied to the query object.

Get the parameter object corresponding to the declared positional parameter with the given position. This method is not required to be supported for native queries.

Get the parameter object corresponding to the declared parameter of the given name. This method is not required to be supported for native queries.

Get the parameter object corresponding to the declared positional parameter with the given position and type. This method is not required to be supported by the provider.

Get the parameter object corresponding to the declared parameter of the given name and type. This method is required to be supported for criteria queries only.

Get the parameter objects corresponding to the declared parameters of the query. Returns empty set if the query has no parameters. This method is not required to be supported for native queries.

Return the value bound to the positional parameter.

Return the value bound to the named parameter.

Return the value bound to the parameter.

Execute a SELECT query and return the query results as an untyped List.

Execute a SELECT query and return the query results as a typed List.

Return Value

a list of the results if called for a Java Persistence query language UPDATE or DELETE statement if the query execution exceeds the query timeout value set and only the statement is rolled back if a lock mode has been set and there is no transaction if pessimistic locking fails and the transaction is rolled back if pessimistic locking fails and only the statement is rolled back if the query execution exceeds the query timeout value set and the transaction is rolled back

Execute a SELECT query that returns a single untyped result.

Execute a SELECT query that returns a single result.

Return Value

the result if there is no result if more than one result if called for a Java Persistence query language UPDATE or DELETE statement if the query execution exceeds the query timeout value set and only the statement is rolled back if a lock mode has been set and there is no transaction if pessimistic locking fails and the transaction is rolled back if pessimistic locking fails and only the statement is rolled back if the query execution exceeds the query timeout value set and the transaction is rolled back

Return a boolean indicating whether a value has been bound to the parameter.

Set the position of the first result to retrieve.

Set the position of the first result to retrieve. position of the first result, numbered from 0

Return Value

the same query instance if the argument is negative

Set the flush mode type to be used for the query execution. The flush mode type applies to the query regardless of the flush mode type in use for the entity manager.

Set the flush mode type to be used for the query execution. The flush mode type applies to the query regardless of the flush mode type in use for the entity manager. flush mode

Return Value

the same query instance

Set a query property or hint. The hints elements may be used to specify query properties and hints. Properties defined by this specification must be observed by the provider. Vendor-specific hints that are not recognized by a provider must be silently ignored. Portable applications should not rely on the standard timeout hint. Depending on the database in use and the locking mechanisms used by the provider, this hint may or may not be observed.

Set a query property or hint. The hints elements may be used to specify query properties and hints. Properties defined by this specification must be observed by the provider. Vendor-specific hints that are not recognized by a provider must be silently ignored. Portable applications should not rely on the standard timeout hint. Depending on the database in use and the locking mechanisms used by the provider, this hint may or may not be observed. name of property or hint value for the property or hint

Return Value

the same query instance if the second argument is not valid for the implementation

Set the lock mode type to be used for the query execution.

Set the lock mode type to be used for the query execution. lock mode

Return Value

the same query instance if the query is found not to be a Java Persistence query language SELECT query or a Criteria API query

Set the maximum number of results to retrieve.

Set the maximum number of results to retrieve. maximum number of results to retrieve

Return Value

the same query instance if the argument is negative

Bind an argument to a positional parameter.

Bind an argument to a named parameter.

Bind an argument to a positional parameter. position parameter value

Return Value

the same query instance if position does not correspond to a positional parameter of the query or if the argument is of incorrect type

Bind an argument to a named parameter. parameter name parameter value

Return Value

the same query instance if the parameter name does not correspond to a parameter of the query or if the argument is of incorrect type

Bind the value of a Parameter object.

Bind the value of a Parameter object. parameter object parameter value

Return Value

the same query instance if the parameter does not correspond to a parameter of the query

Bind an instance of System.DateTime to a positional parameter.

Bind an instance of System.DateTime to a named parameter.

Bind an instance of System.DateTime to a positional parameter. position parameter value temporal type

Return Value

the same query instance if position does not correspond to a positional parameter of the query or if the value argument is of incorrect type

Bind an instance of System.DateTime to a named parameter. parameter name parameter value temporal type

Return Value

the same query instance if the parameter name does not correspond to a parameter of the query or if the value argument is of incorrect type

Bind an instance of System.DateTime to a Parameter object.

Bind an instance of System.DateTime to a Parameter object. parameter object parameter value temporal type

Return Value

the same query instance if the parameter does not correspond to a parameter of the query

Return an object of the specified type to allow access to the provider-specific API. If the provider's query implementation does not support the specified class, the PersistenceException is thrown.