Attempt to store an instance of a non persistable type com.objectdb.jpa.criteria.Expressions$h (error 303)

Question

I'm trying to do a select using a few simple where conditions but I keep getting the exception Attempt to store an instance of a non persistable type com.objectdb.jpa.criteria.Expressions$h (error 303)

public Person read(String surname, String name, String password) throws NonUniqueResultException, NoResultException, PersistenceException, UserException {
        EntityManager entityManager = entityManagerFactory.createEntityManager();
        Person Person = null;
        try {
            entityManager.getTransaction().begin();
            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            CriteriaQuery<Person> criteriaQuery = criteriaBuilder.createQuery(Person.class);
            Root<Person> root = criteriaQuery.from(Person.class);
            criteriaQuery.select(root);
            ParameterExpression<String> name2 = criteriaBuilder.parameter(String.class);
            ParameterExpression<String> surname2 = criteriaBuilder.parameter(String.class);
            ParameterExpression<String> password2 = criteriaBuilder.parameter(String.class);
            criteriaQuery.where(
                    criteriaBuilder.equal(root.get("name"), criteriaBuilder.literal(name2)),
                    criteriaBuilder.equal(root.get("surname"), criteriaBuilder.literal(surname2)),
                    criteriaBuilder.equal(root.get("password"), criteriaBuilder.literal(password2))
            );
            TypedQuery<Person> query = entityManager.createQuery(criteriaQuery);
            query.setParameter("name", name2);
            query.setParameter("surname", surname2);
            query.setParameter("password", password2);
            System.out.println("sout: " + query.toString());
            System.out.println("sout2: " + query.getSingleResult());
            entityManager.getTransaction().commit();
        } finally {
            if (entityManager.getTransaction().isActive()) {
                entityManager.getTransaction().rollback();
            }
            entityManager.close();
        }
        return Person;
    }

Output:

    sout: SELECT $1 FROM Person $1 WHERE (($1.name=:p1) AND ($1.surname=:p1) AND ($1.password=:p1))
    [ObjectDB 2.5.7_03] javax.persistence.PersistenceException
Attempt to store an instance of a non persistable type com.objectdb.jpa.criteria.Expressions$h (error 303)
    at com.objectdb.jpa.JpaQuery.getSingleResult(JpaQuery.java:754)
    ...

Answer 1

In your code you define three parameters, and then wrap them with literals. Sending these invalid literals fails since these expressions are not supported by ObjectDB.

Try:

    ParameterExpression<String> name2 = criteriaBuilder.parameter(String.class);
    ParameterExpression<String> surname2 = criteriaBuilder.parameter(String.class);
    ParameterExpression<String> password2 = criteriaBuilder.parameter(String.class);
    criteriaQuery.where(
        criteriaBuilder.equal(root.get("name"), name2),
        criteriaBuilder.equal(root.get("surname"), surname2),
        criteriaBuilder.equal(root.get("password"), password2)
    );

The parameters should be set by:

    query.setParameter(name2, name);
    query.setParameter(surname2, surname);
    query.setParameter(password2, password);