Then i dont get the "referencedColumnName" Feature, because the db field of the @ID fields doesnt need to be declared, this JPA does already know. I will migrate it nevertheless and leave out the "referencedColumnName" completely.
--- regards Marc Logemann http://www.logemann.org http://www.logentis.de Am 23.12.2011 um 09:39 schrieb Boblitz John: > Hello Marc, > > You stated: "Please note that referencedColumnName value is not the primary > key. " > > Accorging to the Manual (13.8.4) - the referencedColumnName is > "The name of the primary key column being joined to. If there is only one > identity > field in the related entity class, the join column name defaults to the name > of the > identity field's column." > > Regards, > >  > > John > > ---- > > Who is General Failure, and why is he reading my hard disk? > > > > > > > > >> -----Ursprüngliche Nachricht----- >> Von: Marc Logemann [mailto:l...@logemann.org] >> Gesendet: Donnerstag, 22. Dezember 2011 17:55 >> An: users@openjpa.apache.org >> Betreff: Re: org.apache.openjpa.util.LongId cannot be cast to >> MyDomainObject >> >> Hi, >> >> The customer has the same database, the same application >> (same build and stuff like that) and same everything. This is >> what freaks me out ;-) Of course something must be different... >> I compared the schema several times and they are the same. >> >> Turning on Trace is quite impossible on a production machine. >> I would rather do a DB migration and use the primary key >> "oid" as foreign key constraint instead of some random string field. >> >> Perhaps i can get my hands on another machine which is not >> production and also results in that error. Then i could do >> remote debugging. But even with remote debugging turned on, >> its not likely that i fully understand whats wrong. >> >> --- >> regards >> Marc Logemann >> http://www.logemann.org >> http://www.logentis.de >> >> >> >> >> Am 22.12.2011 um 17:00 schrieb Kevin Sutter: >> >>> Hi Marc, >>> I'm not seeing anything wrong with your object model >> definition. But, >>> it definitely looks like OpenJPA is getting confused on this join >>> column reference (string id) and the type of the primary >> key (long). >>> Have you been able to verify that the database schemas are >> consistent >>> with the object model? Does your customer and your development >>> system(s) use the same database type (ie. mysql)? I really >> don't think it's a data issue. >>> It looks more like a data-definition issue either in the >> object model >>> or the database itself. >>> >>> How about your persistence unit definition? Does the customer >>> environment and your development environment use the same >>> persistence.xml? For example, do you dynamically sync the database >>> schema with the object model, or do you pre-create the >> database schema via ddl? >>> >>> I'd start with turning on Trace and comparing the flows to >> see where >>> there are differences. >>> >>> BTW, I totally agree with your comment that OpenJPA is too >> complex to >>> comprehend in just a few hours... :-) >>> >>> Good luck, >>> Kevin >>> >>> On Wed, Dec 21, 2011 at 5:21 PM, Marc Logemann >> <l...@logemann.org> wrote: >>> >>>> Hi, >>>> >>>> me again. This time with something i also dont get. >>>> >>>> OrderPosition.class >>>> --------------------------- >>>> @XmlTransient >>>> @ManyToOne >>>> @JoinColumn(name = "con_ship_id", referencedColumnName = "id") >>>> ContainerShipment containerShipment; >>>> >>>> ContainerShipment.class >>>> ----------------------------------- >>>> @XmlTransient >>>> @Id >>>> @GeneratedValue(strategy = GenerationType.TABLE, generator = >>>> "contShipGen") >>>> @TableGenerator(name = "contShipGen", table = "jpa_sequence", >>>> pkColumnName = "ID", >>>> pkColumnValue = "ContainerShipment", valueColumnName = >>>> "SEQUENCE_VALUE", initialValue = 2000, allocationSize = 2) >>>> long oid; >>>> >>>> @Column(name = "id") >>>> String id; >>>> >>>> @OneToMany(mappedBy = "containerShipment", cascade = >>>> CascadeType.ALL, fetch = FetchType.EAGER) >>>> List<OrderPosition> orderPositions; >>>> >>>> >>>> Please note that referencedColumnName value is not the >> primary key. >>>> Its just a simple String/varchar field. >>>> >>>> Following Stack produced. Even more scary. This stack >> doesnt appear >>>> on my developer machine with test DB, but on customer machine with >>>> different dataset. So it looks data related but i cant be for sure >>>> because i have not seen any data problems in the DB. >>>> Thanks again for hints. It seems that inside TransferFieldManager, >>>> there is a LongId on field index = 12 instead of a >> ContainerShipment. >>>> But i dont know why its there. As i said, i cant say for >> sure because >>>> on my development machine everything is fine which makes >> debugging a >>>> little bit hard. Its also not that easy to fully understand the >>>> OpenJPA code. Its just too complex to analyze in a few hours. >>>> >>>> >>>> >>>> <openjpa-2.1.1-r422266:1148538 nonfatal general error> >>>> org.apache.openjpa.persistence.PersistenceException: >>>> org.apache.openjpa.util.LongId cannot be cast to >>>> de.logentis.bwh.model.ContainerShipment >>>> FailedObject: SELECT cs FROM ContainerShipment cs >> [java.lang.String] >>>> at >> org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1008) >>>> at >> org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:907) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStore >> Manager.java:1041) >>>> at >>>> >> org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult >> .java:280) >>>> at >>>> >> org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(Selec >> tImpl.java:2381) >>>> at >>>> >> org.apache.openjpa.jdbc.meta.strats.RelationToManyInverseKeyFi >> eldStrategy.loadElement(RelationToManyInverseKeyFieldStrategy.java:90) >>>> at >>>> >> org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseK >> eyFieldStrategy.loadElement(RelationCollectionInverseKeyFieldS >> trategy.java:76) >>>> at >>>> >> org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrate >> gy.processEagerParallelResult(StoreCollectionFieldStrategy.java:312) >>>> at >>>> >> org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrate >> gy.loadEagerParallel(StoreCollectionFieldStrategy.java:246) >>>> at >>>> >> org.apache.openjpa.jdbc.meta.FieldMapping.loadEagerParallel(Fi >> eldMapping.java:916) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStore >> Manager.java:1114) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStore >> Manager.java:1067) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeStat >> e(JDBCStoreManager.java:438) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDB >> CStoreManager.java:333) >>>> at >>>> >> org.apache.openjpa.kernel.DelegatingStoreManager.initialize(De >> legatingStoreManager.java:112) >>>> at >>>> >> org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreM >> anager.java:57) >>>> at >>>> >> org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1027) >>>> at >> org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:985) >>>> at >> org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:907) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStore >> Manager.java:1041) >>>> at >>>> >> org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult >> .java:280) >>>> at >>>> >> org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(Selec >> tImpl.java:2381) >>>> at >>>> >> org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult >> .java:274) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.ge >> tResultObject(InstanceResultObjectProvider.java:59) >>>> at >>>> >> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultL >> ist.java:36) >>>> at >> org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) >>>> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) >>>> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) >>>> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) >>>> at >>>> >> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQu >> ery.java:542) >>>> at >>>> >> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:315) >>>> at >>>> >> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryIm >> pl.java:331) >>>> at >>>> >> de.netstorsys.dao.repositories.ContainerShipmentRepositoryImpl >> .findAllCustom(ContainerShipmentRepositoryImpl.java:39) >>>> at >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess >> orImpl.java:39) >>>> at >>>> >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth >> odAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingR >> eflection(AopUtils.java:311) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.i >> nvokeJoinpoint(ReflectiveMethodInvocation.java:183) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.p >> roceed(ReflectiveMethodInvocation.java:150) >>>> at >>>> >> org.springframework.transaction.interceptor.TransactionInterce >> ptor.invoke(TransactionInterceptor.java:110) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.p >> roceed(ReflectiveMethodInvocation.java:172) >>>> at >>>> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd >> kDynamicAopProxy.java:202) >>>> at $Proxy903.findAllCustom(Unknown Source) >>>> at >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess >> orImpl.java:39) >>>> at >>>> >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth >> odAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> >> org.springframework.data.repository.core.support.RepositoryFac >> torySupport$QueryExecutorMethodInterceptor.executeMethodOn(Rep >> ositoryFactorySupport.java:368) >>>> at >>>> >> org.springframework.data.repository.core.support.RepositoryFac >> torySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFa >> ctorySupport.java:338) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.p >> roceed(ReflectiveMethodInvocation.java:172) >>>> at >>>> >> org.springframework.transaction.interceptor.TransactionInterce >> ptor.invoke(TransactionInterceptor.java:110) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.p >> roceed(ReflectiveMethodInvocation.java:172) >>>> at >>>> >> org.springframework.dao.support.PersistenceExceptionTranslatio >> nInterceptor.invoke(PersistenceExceptionTranslationInterceptor >> .java:155) >>>> at >>>> >> org.springframework.aop.framework.ReflectiveMethodInvocation.p >> roceed(ReflectiveMethodInvocation.java:172) >>>> at >>>> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd >> kDynamicAopProxy.java:202) >>>> at $Proxy904.findAllCustom(Unknown Source) >>>> at >>>> >> de.netstorsys.controller.rest.ContainerShipmentRestController. >> showAll(ContainerShipmentRestController.java:53) >>>> at >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess >> orImpl.java:39) >>>> at >>>> >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth >> odAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> >> org.springframework.web.bind.annotation.support.HandlerMethodI >> nvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) >>>> at >>>> >> org.springframework.web.servlet.mvc.annotation.AnnotationMetho >> dHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAda >> pter.java:426) >>>> at >>>> >> org.springframework.web.servlet.mvc.annotation.AnnotationMetho >> dHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) >>>> at >>>> >> org.springframework.web.servlet.DispatcherServlet.doDispatch(D >> ispatcherServlet.java:790) >>>> at >>>> >> org.springframework.web.servlet.DispatcherServlet.doService(Di >> spatcherServlet.java:719) >>>> at >>>> >> org.springframework.web.servlet.FrameworkServlet.processReques >> t(FrameworkServlet.java:644) >>>> at >>>> >> org.springframework.web.servlet.FrameworkServlet.doGet(Framewo >> rkServlet.java:549) >>>> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >>>> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >>>> at >>>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt >> er(ApplicationFilterChain.java:290) >>>> at >>>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli >> cationFilterChain.java:206) >>>> at >>>> >> org.springframework.web.filter.CharacterEncodingFilter.doFilte >> rInternal(CharacterEncodingFilter.java:88) >>>> at >>>> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(O >> ncePerRequestFilter.java:76) >>>> at >>>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt >> er(ApplicationFilterChain.java:235) >>>> at >>>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli >> cationFilterChain.java:206) >>>> at >>>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW >> rapperValve.java:233) >>>> at >>>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardC >> ontextValve.java:191) >>>> at >>>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHost >> Valve.java:127) >>>> at >>>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport >> Valve.java:102) >>>> at >>>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn >> gineValve.java:109) >>>> at >>>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap >> ter.java:293) >>>> at >>>> >> org.apache.coyote.http11.Http11Processor.process(Http11Process >> or.java:859) >>>> at >>>> >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle >> r.process(Http11Protocol.java:602) >>>> at >>>> >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint. >> java:489) >>>> at java.lang.Thread.run(Thread.java:680) >>>> Caused by: java.lang.ClassCastException: >>>> org.apache.openjpa.util.LongId cannot be cast to >> de.logentis.bwh.model.ContainerShipment >>>> at >>>> >> de.logentis.bwh.model.OrderPosition.pcReplaceField(OrderPosition.java) >>>> at >>>> >> org.apache.openjpa.kernel.StateManagerImpl.replaceField(StateM >> anagerImpl.java:3162) >>>> at >>>> >> org.apache.openjpa.kernel.StateManagerImpl.storeObjectField(St >> ateManagerImpl.java:2596) >>>> at >>>> >> org.apache.openjpa.kernel.StateManagerImpl.storeObject(StateMa >> nagerImpl.java:2586) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.setMappedBy(JD >> BCStoreManager.java:505) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeStat >> e(JDBCStoreManager.java:431) >>>> at >>>> >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDB >> CStoreManager.java:333) >>>> at >>>> >> org.apache.openjpa.kernel.DelegatingStoreManager.initialize(De >> legatingStoreManager.java:112) >>>> at >>>> >> org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreM >> anager.java:57) >>>> at >>>> >> org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1027) >>>> at >> org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:985) >>>> ... 86 more >>>> --- >>>> regards >>>> Marc Logemann >>>> http://www.logemann.org >>>> http://www.logentis.de >>>> >>>> >>>> >>>> >>>> >>
