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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • ORMException in liferay 5.2.3 - Forums | Liferay
    via by Unknown author,
  • ORMException in liferay 5.2.3 - Forums | Liferay
    via by Unknown author,
  • I am working in 5.2, and I am receiving the errors below when I attempt to save a piece of content. What's interesting, is the content saved fine, but when I changed a table's cell padding, this happened. There are no page templates or structures here, so everything is pretty pure. I am running against MySQL and Tomcat 5.5. [code]22:00:27,361 ERROR [JDBCExceptionReporter:101] Incorrect string value: '\xEF\xBF\xBD fo...' for column 'content' at row 1 22:00:27,362 ERROR [AbstractFlushingEventListener:324] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) [/code] ...and later on... [code]22:00:27,457 ERROR [BasePersistenceImpl:81] Caught ORMException 22:00:27,672 ERROR [jsp:165] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91) at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.updateImpl(JournalArticlePersistenceImpl.java:230) at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.update(JournalArticlePersistenceImpl.java:195) at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.updateArticle(JournalArticleLocalServiceImpl.java:1881) at com.liferay.portal.mirage.aop.MirageInvoker.invoke(MirageInvoker.java:47) at com.liferay.portal.mirage.aop.ContentInvoker.invoke(ContentInvoker.java:47) at com.liferay.portal.mirage.service.ContentServiceImpl.process(ContentServiceImpl.java:247) at com.liferay.portal.mirage.service.ContentServiceImpl.updateContent(ContentServiceImpl.java:228) at com.liferay.portal.spring.aop.LogAdvice.invoke(LogAdvice.java:73)[/code] ...and later on... [code]Caused by: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:41) at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:117) at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:74) at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:52)[/code]
    via by Josh Asbury,
    • 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(BasePersistenceImpl.java:91) at com.aa.portlet.service.persistence.practitionerPersistenceImpl.findByEmail(practitionerPersistenceImpl.java:356) at com.aa.portlet.service.persistence.practitionerUtil.findByEmail(practitionerUtil.java:98) at com.aa.portlet.service.impl.practitionerLocalServiceImpl.findAllInEmail(practitionerLocalServiceImpl.java:48) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy218.findAllInEmail(Unknown Source)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,