exception - org.hibernate.QueryException: could not resolve property: date of: -
i got exception :
org.springframework.web.util.nestedservletexception: request processing failed; nested exception org.springframework.dao.invaliddataaccessapiusageexception: org.hibernate.queryexception: not resolve property: date of: i have next query con spring data:
@query("select c.message conversationentity c , user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid"+ " , c.message.id = um.message.id") public list<messageentity> getallmessagesbyuser (@param("userid") long userid, pageable page); conversationentity:
@id @generatedvalue(strategy=generationtype.auto) private long id; private string text; private date createdate; /**mensaje leído o no**/ private integer isread; @manytoone(fetch=fetchtype.eager) private messageentity message; /* @manytoone(fetch=fetchtype.eager) private userentity usersender;*/
@manytoone(fetch=fetchtype.eager) private userentity userowner; messageentity:
@id @generatedvalue(strategy=generationtype.auto) private long id; private date createdate; @manytoone(fetch=fetchtype.eager) private messageentity message; @manytoone(fetch=fetchtype.eager) private userentity usersender; paramater page is:
sort sort = new sort(sort.direction.desc, "createdate"); pageable page = new pagerequest(0, 10, sort); what error?
estado http 500 - request processing failed; nested exception org.springframework.dao.invaliddataaccessapiusageexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc]; nested exception java.lang.illegalargumentexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc] type informe de excepción mensaje request processing failed; nested exception org.springframework.dao.invaliddataaccessapiusageexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc]; nested exception java.lang.illegalargumentexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc] descripción el servidor encontró united nations error interno que hizo que no pudiera rellenar este requerimiento. excepción org.springframework.web.util.nestedservletexception: request processing failed; nested exception org.springframework.dao.invaliddataaccessapiusageexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc]; nested exception java.lang.illegalargumentexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc] org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:894) org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:778) javax.servlet.http.httpservlet.service(httpservlet.java:620) javax.servlet.http.httpservlet.service(httpservlet.java:727) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:311) org.springframework.security.web.access.intercept.filtersecurityinterceptor.invoke(filtersecurityinterceptor.java:116) org.springframework.security.web.access.intercept.filtersecurityinterceptor.dofilter(filtersecurityinterceptor.java:83) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.access.exceptiontranslationfilter.dofilter(exceptiontranslationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.anonymousauthenticationfilter.dofilter(anonymousauthenticationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.servletapi.securitycontextholderawarerequestfilter.dofilter(securitycontextholderawarerequestfilter.java:54) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.savedrequest.requestcacheawarefilter.dofilter(requestcacheawarefilter.java:45) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.www.basicauthenticationfilter.dofilter(basicauthenticationfilter.java:150) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.abstractauthenticationprocessingfilter.dofilter(abstractauthenticationprocessingfilter.java:182) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.logout.logoutfilter.dofilter(logoutfilter.java:105) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.context.securitycontextpersistencefilter.dofilter(securitycontextpersistencefilter.java:87) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.filterchainproxy.dofilter(filterchainproxy.java:173) org.springframework.web.filter.delegatingfilterproxy.invokedelegate(delegatingfilterproxy.java:346) org.springframework.web.filter.delegatingfilterproxy.dofilter(delegatingfilterproxy.java:259) org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:88) org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:76) causa raíz org.springframework.dao.invaliddataaccessapiusageexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc]; nested exception java.lang.illegalargumentexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc] org.springframework.orm.jpa.entitymanagerfactoryutils.convertjpaaccessexceptionifpossible(entitymanagerfactoryutils.java:301) org.springframework.orm.jpa.vendor.hibernatejpadialect.translateexceptionifpossible(hibernatejpadialect.java:106) org.springframework.orm.jpa.abstractentitymanagerfactorybean.translateexceptionifpossible(abstractentitymanagerfactorybean.java:403) org.springframework.dao.support.chainedpersistenceexceptiontranslator.translateexceptionifpossible(chainedpersistenceexceptiontranslator.java:58) org.springframework.dao.support.dataaccessutils.translateifnecessary(dataaccessutils.java:213) org.springframework.dao.support.persistenceexceptiontranslationinterceptor.invoke(persistenceexceptiontranslationinterceptor.java:163) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.data.jpa.repository.support.lockmoderepositorypostprocessor$lockmodepopulatingmethodintercceptor.invoke(lockmoderepositorypostprocessor.java:91) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.aop.interceptor.exposeinvocationinterceptor.invoke(exposeinvocationinterceptor.java:90) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:202) com.sun.proxy.$proxy40.getallmessagesbyuser(unknown source) com.itripping.service.impl.messageserviceimpl.getallmessagesbyuser(messageserviceimpl.java:85) com.itripping.web.controller.messagecontroller.getmessages(messagecontroller.java:86) sun.reflect.nativemethodaccessorimpl.invoke0(native method) sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) java.lang.reflect.method.invoke(method.java:606) org.springframework.web.method.support.invocablehandlermethod.invoke(invocablehandlermethod.java:219) org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:132) org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:100) org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:604) org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:565) org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:80) org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:923) org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:852) org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:882) org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:778) javax.servlet.http.httpservlet.service(httpservlet.java:620) javax.servlet.http.httpservlet.service(httpservlet.java:727) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:311) org.springframework.security.web.access.intercept.filtersecurityinterceptor.invoke(filtersecurityinterceptor.java:116) org.springframework.security.web.access.intercept.filtersecurityinterceptor.dofilter(filtersecurityinterceptor.java:83) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.access.exceptiontranslationfilter.dofilter(exceptiontranslationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.anonymousauthenticationfilter.dofilter(anonymousauthenticationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.servletapi.securitycontextholderawarerequestfilter.dofilter(securitycontextholderawarerequestfilter.java:54) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.savedrequest.requestcacheawarefilter.dofilter(requestcacheawarefilter.java:45) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.www.basicauthenticationfilter.dofilter(basicauthenticationfilter.java:150) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.abstractauthenticationprocessingfilter.dofilter(abstractauthenticationprocessingfilter.java:182) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.logout.logoutfilter.dofilter(logoutfilter.java:105) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.context.securitycontextpersistencefilter.dofilter(securitycontextpersistencefilter.java:87) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.filterchainproxy.dofilter(filterchainproxy.java:173) org.springframework.web.filter.delegatingfilterproxy.invokedelegate(delegatingfilterproxy.java:346) org.springframework.web.filter.delegatingfilterproxy.dofilter(delegatingfilterproxy.java:259) org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:88) org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:76) causa raíz java.lang.illegalargumentexception: org.hibernate.queryexception: not resolve property: date of: com.itripping.entity.conversationentity [select c.message com.itripping.entity.conversationentity c , com.itripping.entity.user_messageentity um c.userowner.id = :userid , um.usersender.id= :userid , c.message.id = um.message.id order c.date desc] org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1347) org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1288) org.hibernate.ejb.abstractentitymanagerimpl.createquery(abstractentitymanagerimpl.java:289) sun.reflect.generatedmethodaccessor25.invoke(unknown source) sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) java.lang.reflect.method.invoke(method.java:606) org.springframework.orm.jpa.extendedentitymanagercreator$extendedentitymanagerinvocationhandler.invoke(extendedentitymanagercreator.java:365) com.sun.proxy.$proxy27.createquery(unknown source) sun.reflect.generatedmethodaccessor25.invoke(unknown source) sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) java.lang.reflect.method.invoke(method.java:606) org.springframework.orm.jpa.sharedentitymanagercreator$sharedentitymanagerinvocationhandler.invoke(sharedentitymanagercreator.java:240) com.sun.proxy.$proxy27.createquery(unknown source) org.springframework.data.jpa.repository.query.simplejpaquery.docreatequery(simplejpaquery.java:102) org.springframework.data.jpa.repository.query.abstractjpaquery.createquery(abstractjpaquery.java:144) org.springframework.data.jpa.repository.query.jpaqueryexecution$collectionexecution.doexecute(jpaqueryexecution.java:77) org.springframework.data.jpa.repository.query.jpaqueryexecution.execute(jpaqueryexecution.java:55) org.springframework.data.jpa.repository.query.abstractjpaquery.doexecute(abstractjpaquery.java:95) org.springframework.data.jpa.repository.query.abstractjpaquery.execute(abstractjpaquery.java:85) org.springframework.data.repository.core.support.repositoryfactorysupport$queryexecutormethodinterceptor.invoke(repositoryfactorysupport.java:313) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:110) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.dao.support.persistenceexceptiontranslationinterceptor.invoke(persistenceexceptiontranslationinterceptor.java:155) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.data.jpa.repository.support.lockmoderepositorypostprocessor$lockmodepopulatingmethodintercceptor.invoke(lockmoderepositorypostprocessor.java:91) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.aop.interceptor.exposeinvocationinterceptor.invoke(exposeinvocationinterceptor.java:90) org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:202) com.sun.proxy.$proxy40.getallmessagesbyuser(unknown source) com.itripping.service.impl.messageserviceimpl.getallmessagesbyuser(messageserviceimpl.java:85) com.itripping.web.controller.messagecontroller.getmessages(messagecontroller.java:86) sun.reflect.nativemethodaccessorimpl.invoke0(native method) sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) java.lang.reflect.method.invoke(method.java:606) org.springframework.web.method.support.invocablehandlermethod.invoke(invocablehandlermethod.java:219) org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:132) org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:100) org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:604) org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:565) org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:80) org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:923) org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:852) org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:882) org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:778) javax.servlet.http.httpservlet.service(httpservlet.java:620) javax.servlet.http.httpservlet.service(httpservlet.java:727) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:311) org.springframework.security.web.access.intercept.filtersecurityinterceptor.invoke(filtersecurityinterceptor.java:116) org.springframework.security.web.access.intercept.filtersecurityinterceptor.dofilter(filtersecurityinterceptor.java:83) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.access.exceptiontranslationfilter.dofilter(exceptiontranslationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.anonymousauthenticationfilter.dofilter(anonymousauthenticationfilter.java:113) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.servletapi.securitycontextholderawarerequestfilter.dofilter(securitycontextholderawarerequestfilter.java:54) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.savedrequest.requestcacheawarefilter.dofilter(requestcacheawarefilter.java:45) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.www.basicauthenticationfilter.dofilter(basicauthenticationfilter.java:150) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.abstractauthenticationprocessingfilter.dofilter(abstractauthenticationprocessingfilter.java:182) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.authentication.logout.logoutfilter.dofilter(logoutfilter.java:105) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.context.securitycontextpersistencefilter.dofilter(securitycontextpersistencefilter.java:87) org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:323) org.springframework.security.web.filterchainproxy.dofilter(filterchainproxy.java:173) org.springframework.web.filter.delegatingfilterproxy.invokedelegate(delegatingfilterproxy.java:346) org.springframework.web.filter.delegatingfilterproxy.dofilter(delegatingfilterproxy.java:259) org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:88) org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:76) causa raíz hibernate exception
No comments:
Post a Comment