Hi,
i currently try to execute a update via @Query ->
@Modifying
@Query("UPDATE BasketItem SET status = ?1 WHERE e.basket.basketId = ?2")
public abstract int updateStatus(int status, String basketId);
Is it possible?
Is it also possible with a DELETE statement?
I get following exception:
Caused by: java.lang.NullPointerException
at
org.eclipse.persistence.queries.DatabaseQuery.addArgument(DatabaseQuery.java:449)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.queries.DatabaseQuery.addArgument(DatabaseQuery.java:419)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.jpql.HermesParser.addArguments(HermesParser.java:98)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQueryImp(HermesParser.java:287)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuery(HermesParser.java:163)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:142)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:116)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:102)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:86)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1603)
~[eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]
at
org.apache.webbeans.custom.persistence.EntityManager$$OwbNormalScopeProxy0.createQuery(javax/persistence/EntityManager.java)
~[?:?]
at
org.apache.deltaspike.data.impl.builder.AnnotatedQueryBuilder.createJpaQuery(AnnotatedQueryBuilder.java:80)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.builder.AnnotatedQueryBuilder.execute(AnnotatedQueryBuilder.java:48)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.builder.QueryBuilder.executeQuery(QueryBuilder.java:57)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner$1.proceed(TransactionalQueryRunner.java:77)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.jpa.impl.transaction.ResourceLocalTransactionStrategy.execute(ResourceLocalTransactionStrategy.java:132)
~[deltaspike-jpa-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner.executeTransactional(TransactionalQueryRunner.java:72)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner.executeQuery(TransactionalQueryRunner.java:54)
~[deltaspike-data-module-impl-0.7.jar:0.7]
at
org.apache.deltaspike.data.impl.handler.QueryHandler.invoke(QueryHandler.java:79)
~[deltaspike-data-module-impl-0.7.jar:0.7]
Regards,
Thomas
