I'm using Datanucleus with Spring Data JPA on App Engine.
The basis persisting and queries go well. But as I was exploring further I stumbled against a problem with ParameterExpressions. Which does not seem to work.

When having:

{code}
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<User> cq = cb.createQuery(User.class);
Root<User> root = cq.from(User.class);
ParameterExpression<String> username = cb.parameter(String.class);
cq.select(root);
cq.where(cb.like(root.<String> get("username"), username));
TypedQuery<User> tq = em.createQuery(cq);
tq.setParameter(username, "man" + "%");
List<User> users = tq.getResultList();
{code}

See also full test case I will attach after creating this issue.

The error I get is:

INFO: >> Exception thrown retrieving objects
java.lang.IllegalArgumentException: Query has parameter "-1" supplied at execution yet the query doesnt make use of this parameter
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:461)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:419)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:56)
at org.datanucleus.test.Main.main(Main.java:108)
Caused by: org.datanucleus.store.query.QueryInvalidParametersException: Query has parameter "-1" supplied at execution yet the query doesnt make use of this parameter
at org.datanucleus.store.query.Query.applyImplicitParameterValueToCompilation(Query.java:881)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:828)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:457)
... 3 more


Note that with Spring Data JPA I was getting a little bit different exception, but I don't know the exact code created by Spring Data JPA.
Nevertheless when experimenting with the query builder/criteria I found above issue.


Btw this is the error I see with Spring Data JPA:
Numbered parameter syntax starting ? but isnt followed by numeric!; nested exception is javax.persistence.PersistenceException: Numbered parameter syntax starting ? but isnt followed by numeric!