Is it possible to create a reference to the User class in com.openxava.naviox.model ?
I would like to create a reference to the User class from another class. The code that I have used is as follows:
@ManyToOne(fetch=FetchType.LAZY, optional=true)
@JoinColumn(name="depuser", referencedColumnName="name")
private User depuser;
I am able to select a user and save it. However, I get an error if I try to call the record up again.
The stacktrace is as follows:
SEVERE: Unable to find com.openxava.naviox.model.User with id admin
javax.persistence.EntityNotFoundException: Unable to find com.openxava.naviox.model.User with id admin
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$JpaEntityNotFoundDelegate.handleEntityNotFound(EntityManagerFactoryBuilderImpl.java:183)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:262)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:176)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:286)
at org.hibernate.Hibernate.getClass(Hibernate.java:111)
at org.openxava.model.impl.MapFacadeBean.getReferenceValues(MapFacadeBean.java:1092)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:966)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:936)
at org.openxava.model.impl.MapFacadeBean.getValuesImpl(MapFacadeBean.java:664)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:99)
at org.openxava.model.MapFacade.getValues(MapFacade.java:472)
at org.openxava.actions.SearchByViewKeyAction.execute(SearchByViewKeyAction.java:56)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:495)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:616)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:616)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.execute(ModuleManager.java:360)
at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:193)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
at org.openxava.web.dwr.Module.getURIAsStream(Module.java:205)
at org.openxava.web.dwr.Module.request(Module.java:64)
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.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)
Any help will be appreciated.
Regards
Med
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is it possible to create a reference to the User class in com.openxava.naviox.model ?
Yes, you can.
Unable to find com.openxava.naviox.model.User with id admin
It seem a problem about data. Does exist a user called "admin"? Does have "admin" in the oreign key filed spaces before or after? Does it work for othe records, even for ones with "name" column to null?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are quite right. There was spaces on the foreign key. I amended my table so that the definition of the field is character varying. It works correctly.
Thank you.
Regards
Med
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Is it possible to create a reference to the User class in com.openxava.naviox.model ?
I would like to create a reference to the User class from another class. The code that I have used is as follows:
@ManyToOne(fetch=FetchType.LAZY, optional=true)
@JoinColumn(name="depuser", referencedColumnName="name")
private User depuser;
I am able to select a user and save it. However, I get an error if I try to call the record up again.
The stacktrace is as follows:
SEVERE: Unable to find com.openxava.naviox.model.User with id admin
javax.persistence.EntityNotFoundException: Unable to find com.openxava.naviox.model.User with id admin
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$JpaEntityNotFoundDelegate.handleEntityNotFound(EntityManagerFactoryBuilderImpl.java:183)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:262)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:176)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:286)
at org.hibernate.Hibernate.getClass(Hibernate.java:111)
at org.openxava.model.impl.MapFacadeBean.getReferenceValues(MapFacadeBean.java:1092)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:966)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:936)
at org.openxava.model.impl.MapFacadeBean.getValuesImpl(MapFacadeBean.java:664)
at org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:99)
at org.openxava.model.MapFacade.getValues(MapFacade.java:472)
at org.openxava.actions.SearchByViewKeyAction.execute(SearchByViewKeyAction.java:56)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:495)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:616)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:616)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)
at org.openxava.controller.ModuleManager.execute(ModuleManager.java:360)
at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:193)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
at org.openxava.web.dwr.Module.getURIAsStream(Module.java:205)
at org.openxava.web.dwr.Module.request(Module.java:64)
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.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)
Any help will be appreciated.
Regards
Med
Hi Med,
Yes, you can.
It seem a problem about data. Does exist a user called "admin"? Does have "admin" in the oreign key filed spaces before or after? Does it work for othe records, even for ones with "name" column to null?
Hi Javier,
You are quite right. There was spaces on the foreign key. I amended my table so that the definition of the field is character varying. It works correctly.
Thank you.
Regards
Med