Hi all,
I need your help with a named query which i have which returns a org.apache.openjpa.persistence.ArgumentException: null .
Here is my named query:
@NamedQuery(name="user_deactivateUser", query="update UserImpl u SET u.bisdeleted=1,u.dtupdatedate=SYSDATE, u.dtdeletedate=SYSDATE where u.nID=?1"
Now when i call this query in my method it gives an null pointer exception at q.executeUpdate().
public void doDeactivateAllUsers(int userID) throws ServiceException{
EntityManager em = null;
em = BaseDAO.getEntityManager();
Query q = em.createNamedQuery("user_deactivateUser");
q.setParameter(1,userID);
int count = q.executeUpdate();
here is the full stack trace of this exception.
<openjpa-1.2.1-r752877:753278 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:814)
at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:884)
at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:336)
at com.forrester.companyadmin.service.DeactivateUserService.doDeactivateUser(DeactivateUserService.java:98)
at com.forrester.companyadmin.service.DeactivateUserService.doDeactivateAllUsers(DeactivateUserService.java:225)
at com.forrester.companyadmin.controller.DeactivateUsersController.action(DeactivateUsersController.java:376)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:146)
at javax.faces.component.UICommand.broadcast(UICommand.java:325)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:287)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:401)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:95)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.forrester.companyadmin.filters.CompanyAdminFilter.doFilter(CompanyAdminFilter.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
.
Can someone let me know if there is anything wrong in the way iam passing these parameteres
Edited by: user8769643 on Mar 19, 2010 7:37 AM