Object getSingleResultOrNull()

Execute a SELECT query that returns a single untyped result.

Returns:

the result, or null if there is no result.

Throws:

IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement.

LockTimeoutException - if pessimistic locking fails and only the statement is rolled back.

NonUniqueResultException - if more than one result.

QueryTimeoutException - if the query execution exceeds the query timeout value set and only the statement is rolled back.

PessimisticLockException - if pessimistic locking fails and the transaction is rolled back.

PersistenceException - if the query execution exceeds the query timeout value set and the transaction is rolled back.

TransactionRequiredException - if a lock mode other than NONE has been set and there is no transaction or the persistence context has not been joined to the transaction.

Since:

Jakarta Persistence (JPA) 3.2