com.liferay.portal.SystemException: java.lang.IllegalArgumentException: No positional parameters in query: FROM com.aa.portlet.model.practitioner WHERE email_address = ? ORDER BY last_name ASC

liferay.com | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    "No positional parameters in query" error when using service buil - Forums

    liferay.com | 8 months ago
    com.liferay.portal.SystemException: java.lang.IllegalArgumentException: No positional parameters in query: FROM com.aa.portlet.model.practitioner WHERE email_address = ? ORDER BY last_name ASC

    Root Cause Analysis

    1. com.liferay.portal.SystemException

      java.lang.IllegalArgumentException: No positional parameters in query: FROM com.aa.portlet.model.practitioner WHERE email_address = ? ORDER BY last_name ASC

      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException()
    2. Liferay Portal Service
      BasePersistenceImpl.processException
      1. com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91)
      1 frame
    3. com.aa.portlet
      practitionerLocalServiceImpl.findAllInEmail
      1. com.aa.portlet.service.persistence.practitionerPersistenceImpl.findByEmail(practitionerPersistenceImpl.java:356)
      2. com.aa.portlet.service.persistence.practitionerUtil.findByEmail(practitionerUtil.java:98)
      3. com.aa.portlet.service.impl.practitionerLocalServiceImpl.findAllInEmail(practitionerLocalServiceImpl.java:48)
      3 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    6. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    7. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      4 frames
    8. Unknown
      $Proxy218.findAllInEmail
      1. $Proxy218.findAllInEmail(Unknown Source)
      1 frame