Ah damn, sorry!
Should be ofc: @Query("UPDATE BasketItem e SET e.status = ?1 WHERE
e.basket.basketId = ?2")
Will do further tests.
2014-06-17 16:49 GMT+02:00 Thomas Andraschko <[email protected]>:
> 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
>
