It is actually called categoryTypeFK and is char(45) related to ID, char(45) in categoryType table.
I like the less is more but I remember getting some complaints in eclipse. I'll try again -----Original Message----- From: Marc Prud'hommeaux [mailto:[EMAIL PROTECTED] On Behalf Of Marc Prud'hommeaux Sent: April 5, 2007 2:42 AM To: open-jpa-dev@incubator.apache.org Subject: Re: Duplicate Query - where none exists How is the "category.categoryTypeFK" column defined in the database? An is there a corresponding "id" column in the table for the CategoryType class? Also, when there is just a single column in the join for a ManyToOne, I think you can skip setting the "referencedColumnName" attribute, since it will implicitly join to the single primary key of the related table. I.e., you should be able to do: @ManyToOne @JoinColumn(name = "categoryTypeFK") On Apr 4, 2007, at 8:34 PM, Phill Moran wrote: > I think you may be on to something and have been looking into it. > It is mapped > and I thought worked but I am learning that I have a pretty messed up > config (I had both Toplink and OpenJPA, I am accessing fields directly > not through getters and am not positive that the mapping is right as > it is one to many). I have other versions of the same mapping and this > fairly commonly used class for my application as it represents > categories that are grouped by categoryTpye. It does have a relation > into the offended query class though > > - Here is the pertinent parts of the Store class: > > @ManyToOne > @JoinColumn(name = "typeFK", referencedColumnName = "id") > public Category getType() throws StoreTypeNotFoundException { > return type; > } > > - Here is the pertinent parts of the Category class: > > @Entity > @Table(name = "category", schema = "bidspec") @Inheritance(strategy = > InheritanceType.TABLE_PER_CLASS) @NamedQueries( { > @NamedQuery(name = "CategoryFXType", query = "SELECT c FROM Category > c WHERE c.type = :type"), > @NamedQuery(name = "CategoryValueObjectFXPK", query = "SELECT c FROM > Category c WHERE c.id = :primaryKey"), > @NamedQuery(name = "CategoryFXDescription", query = "SELECT c FROM > Category c WHERE UPPER(c.description) LIKE :description ORDER BY > c.description") }) > public class Category extends Persistable { > > ... > > @ManyToOne > @JoinColumn(name = "categoryTypeFK", referencedColumnName = "id") > public CategoryType getType() { > return this.type; > } > > Persistable is my base JPA persistable class housing the String id for > all persistable classes > > -----Original Message----- > From: Marc Prud'hommeaux [mailto:[EMAIL PROTECTED] On Behalf > Of Marc Prud'hommeaux > Sent: April 4, 2007 11:13 PM > To: open-jpa-dev@incubator.apache.org > Subject: Re: Duplicate Query - where none exists > > Phill- > > While I'm not sure the cause of the duplicate query error, I do notice > the original cause in the nested stack trace is: > >> Caused by: <4|true|0.0.0> >> org.apache.openjpa.persistence.ArgumentException: You cannot join on >> column "category.categoryTypeFK". It is not managed by a mapping >> that supports joins. > > It could be that this error is indirectly causing the next one. > > Have you looked into this? How is categoryTypeFK mapped? > > > > > On Apr 4, 2007, at 8:03 PM, Phill Moran wrote: > >> I did a workspace search and it exists in only one place. Also if I >> comment out the one it complains about it complains about the next >> one. But only in this java file. I even did an clean and build to >> make sure there were no old class files hanging out. >> >> -----Original Message----- >> From: Dain Sundstrom [mailto:[EMAIL PROTECTED] >> Sent: April 4, 2007 5:06 PM >> To: open-jpa-dev@incubator.apache.org >> Subject: Re: Duplicate Query - where none exists >> >> I think I saw this once. The problem is in JPA named queries are all >> contained in a single global namespace, so if you have to persistent >> beans that define queries with the same name you get a warning. It >> would be nice if the warning told you where the duplicate >> declarations are located. >> >> -dain >> >> On Apr 3, 2007, at 10:07 PM, Phill Moran wrote: >> >>> Anyone seen this before >>> >>> WARN [main] openjpa.MetaData - Found duplicate query "StoreFXPK" >>> in "class >>> .....". Ignoring. >>> >>> This class has only three such named queries all different names and >>> different actual queries. See following @NamedQueries( { >>> @NamedQuery(name = "StoreFXPK", query = "SELECT s FROM Store s >> WHERE >>> s.id = :primaryKey"), >>> @NamedQuery(name = "StoreFXTypeAndName", query = "SELECT s FROM >>> Store s WHERE s.type = :type AND UPPER(s.name) LIKE :storeName OR >>> UPPER(s.displayName) = :storeName2"), >>> @NamedQuery(name = "StoreFXName", query = "SELECT s FROM Store s >> >>> WHERE UPPER(s.name) = :storeName OR UPPER(s.displayName) = >>> :storeName2") >>> }) >>> >>> I even renamed the duplicate parms to make sure it was not a trickle >>> down exception. Not only that, if I comment out the StoreFXPK query >>> I get the same error on the next named Query. I did a search on the >>> workspace an this is only used in one place (factory class) and >>> define in another (persistent class). I have no doubt this is >>> something I have done but am unsure what it is I get the follow >>> stack trace when executing the following line: >>> >>> Query q = em.createNamedQuery("StoreFXName"); <- not the same query >>> mentioned in the above warning...the plot thickens >>> >>> The unmapped field in the stack trace is mapped. >>> >>> <4|true|0.0.0> org.apache.openjpa.persistence.ArgumentException: >>> Errors >>> encountered while resolving metadata. See nested exceptions for >>> details. >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolve >>> (MetaDataRepository.java:501) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:2 >>> 83) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:3 >>> 38) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaDat >>> a >>> ( >>> JPQLExpres >>> sionBuilder.java:151) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:131) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:211) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:181) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTyp >>> e >>> ( >>> JPQLExpres >>> sionBuilder.java:174) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$500 >>> (JPQLExpressionBu >>> ilder.java:61) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder >>> $ParsedJPQL.populate(JPQLExp >>> ressionBuilder.java:1657) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java: >>> 52) >>> at >>> org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilati >>> o >>> n >>> (Expressio >>> nStoreQuery.java:145) >>> at >>> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java: >>> 642) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compilationFromCache >>> (QueryImpl.java:623) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForCompilation >>> (QueryImpl.java:589) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForExecutor >>> (QueryImpl.java:651) >>> at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:558) >>> at >>> org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery >>> (EntityManagerI >>> mpl.java:699) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.orm.jpa.ExtendedEntityManagerCreator >>> $ExtendedEntityManagerIn >>> vocationHandler.invoke(ExtendedEntityManagerCreator.java:237) >>> at $Proxy34.createNamedQuery(Unknown Source) >>> at >>> ca.BidSpec.emall.stores.StoreFactoryImpl.getStoreValueObjectByName >>> (StoreFactoryI >>> mpl.java:88) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect >>> i >>> o >>> n(AopUtils >>> .java:280) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ >>> o >>> i >>> npoint(Ref >>> lectiveMethodInvocation.java:187) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:154) >>> at >>> org.springframework.transaction.interceptor.TransactionInterceptor.i >>> n >>> v >>> oke(Transa >>> ctionInterceptor.java:107) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:176) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke >>> (JdkDynamicAopProxy.j >>> ava:210) >>> at $Proxy32.getStoreValueObjectByName(Unknown Source) >>> at >>> ca.BidSpec.testing.emall.UserFactoryTest.testSetup >>> (UserFactoryTest.java:110) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at junit.framework.TestCase.runTest(TestCase.java:164) >>> at junit.framework.TestCase.runBare(TestCase.java:130) >>> at >>> org.springframework.test.ConditionalTestCase.runBare >>> (ConditionalTestCase.java:69 >>> ) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ac >>> cess$001(AbstractAnnotationAwareTransactionalTests.java:44) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests$1. >>> run(AbstractAnnotationAwareTransactionalTests.java:112) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTest(AbstractAnnotationAwareTransactionalTests.java:177) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nBare(AbstractAnnotationAwareTransactionalTests.java:108) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:159) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:239) >>> at junit.framework.TestResult$1.protect(TestResult.java:110) >>> at junit.framework.TestResult.runProtected(TestResult.java:128) >>> at junit.framework.TestResult.run(TestResult.java:113) >>> at junit.framework.TestCase.run(TestCase.java:120) >>> at junit.framework.TestSuite.runTest(TestSuite.java:228) >>> at junit.framework.TestSuite.run(TestSuite.java:223) >>> at >>> org.junit.internal.runners.OldTestClassRunner.run >>> (OldTestClassRunner.java:35) >>> at >>> org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: >>> 29) >>> at >>> org.junit.internal.runners.TestClassRunner$1.runUnprotected >>> (TestClassRunner.java >>> :42) >>> at >>> org.junit.internal.runners.BeforeAndAfterRunner.runProtected >>> (BeforeAndAfterRunne >>> r.java:34) >>> at >>> org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: >>> 52) >>> at >>> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run >>> (JUnit4TestReferen >>> ce.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.TestExecution.run >>> (TestExecution.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:460) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:673) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run >>> (RemoteTestRunner.java >>> :386) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main >>> (RemoteTestRunner.jav >>> a:196) >>> Caused by: <4|true|0.0.0> >>> org.apache.openjpa.persistence.ArgumentException: You cannot join on >>> column "category.categoryTypeFK". It is not managed by a mapping >>> that supports joins. >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.assertJoinable >>> (ClassMapping.java:235) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.isForeignKeyObjectId >>> (ClassMapping.java >>> :299) >>> at >>> org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.initialize >>> (RelationFie >>> ldStrategy.java:189) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.initializeMapping >>> (FieldMapping.java:48 >>> 3) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.resolve(FieldMapping.java: >>> 402) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.initializeMapping >>> (ClassMapping.java:83 >>> 0) >>> at >>> org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java: >>> 1574) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolveMapping >>> (MetaDataRepository.jav >>> a:624) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolve >>> (MetaDataRepository.java:493) >>> ... 67 more >>> NestedThrowables: >>> <4|true|0.0.0> org.apache.openjpa.persistence.ArgumentException: >>> You cannot join >>> on column "category.categoryTypeFK". It is not managed by a mapping >>> that supports joins. >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.assertJoinable >>> (ClassMapping.java:235) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.isForeignKeyObjectId >>> (ClassMapping.java >>> :299) >>> at >>> org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.initialize >>> (RelationFie >>> ldStrategy.java:189) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.initializeMapping >>> (FieldMapping.java:48 >>> 3) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.resolve(FieldMapping.java: >>> 402) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.initializeMapping >>> (ClassMapping.java:83 >>> 0) >>> at >>> org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java: >>> 1574) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolveMapping >>> (MetaDataRepository.jav >>> a:624) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolve >>> (MetaDataRepository.java:493) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:2 >>> 83) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:3 >>> 38) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaDat >>> a >>> ( >>> JPQLExpres >>> sionBuilder.java:151) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:131) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:211) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:181) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTyp >>> e >>> ( >>> JPQLExpres >>> sionBuilder.java:174) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$500 >>> (JPQLExpressionBu >>> ilder.java:61) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder >>> $ParsedJPQL.populate(JPQLExp >>> ressionBuilder.java:1657) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java: >>> 52) >>> at >>> org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilati >>> o >>> n >>> (Expressio >>> nStoreQuery.java:145) >>> at >>> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java: >>> 642) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compilationFromCache >>> (QueryImpl.java:623) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForCompilation >>> (QueryImpl.java:589) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForExecutor >>> (QueryImpl.java:651) >>> at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:558) >>> at >>> org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery >>> (EntityManagerI >>> mpl.java:699) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.orm.jpa.ExtendedEntityManagerCreator >>> $ExtendedEntityManagerIn >>> vocationHandler.invoke(ExtendedEntityManagerCreator.java:237) >>> at $Proxy34.createNamedQuery(Unknown Source) >>> at >>> ca.BidSpec.emall.stores.StoreFactoryImpl.getStoreValueObjectByName >>> (StoreFactoryI >>> mpl.java:88) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect >>> i >>> o >>> n(AopUtils >>> .java:280) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ >>> o >>> i >>> npoint(Ref >>> lectiveMethodInvocation.java:187) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:154) >>> at >>> org.springframework.transaction.interceptor.TransactionInterceptor.i >>> n >>> v >>> oke(Transa >>> ctionInterceptor.java:107) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:176) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke >>> (JdkDynamicAopProxy.j >>> ava:210) >>> at $Proxy32.getStoreValueObjectByName(Unknown Source) >>> at >>> ca.BidSpec.testing.emall.UserFactoryTest.testSetup >>> (UserFactoryTest.java:110) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at junit.framework.TestCase.runTest(TestCase.java:164) >>> at junit.framework.TestCase.runBare(TestCase.java:130) >>> at >>> org.springframework.test.ConditionalTestCase.runBare >>> (ConditionalTestCase.java:69 >>> ) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ac >>> cess$001(AbstractAnnotationAwareTransactionalTests.java:44) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests$1. >>> run(AbstractAnnotationAwareTransactionalTests.java:112) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTest(AbstractAnnotationAwareTransactionalTests.java:177) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nBare(AbstractAnnotationAwareTransactionalTests.java:108) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:159) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:239) >>> at junit.framework.TestResult$1.protect(TestResult.java:110) >>> at junit.framework.TestResult.runProtected(TestResult.java:128) >>> at junit.framework.TestResult.run(TestResult.java:113) >>> at junit.framework.TestCase.run(TestCase.java:120) >>> at junit.framework.TestSuite.runTest(TestSuite.java:228) >>> at junit.framework.TestSuite.run(TestSuite.java:223) >>> at >>> org.junit.internal.runners.OldTestClassRunner.run >>> (OldTestClassRunner.java:35) >>> at >>> org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: >>> 29) >>> at >>> org.junit.internal.runners.TestClassRunner$1.runUnprotected >>> (TestClassRunner.java >>> :42) >>> at >>> org.junit.internal.runners.BeforeAndAfterRunner.runProtected >>> (BeforeAndAfterRunne >>> r.java:34) >>> at >>> org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: >>> 52) >>> at >>> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run >>> (JUnit4TestReferen >>> ce.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.TestExecution.run >>> (TestExecution.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:460) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:673) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run >>> (RemoteTestRunner.java >>> :386) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main >>> (RemoteTestRunner.jav >>> a:196) >>> <4|true|0.0.0> org.apache.openjpa.persistence.ArgumentException: >>> You cannot join >>> on column "category.categoryTypeFK". It is not managed by a mapping >>> that supports joins. >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.assertJoinable >>> (ClassMapping.java:235) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.isForeignKeyObjectId >>> (ClassMapping.java >>> :299) >>> at >>> org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.initialize >>> (RelationFie >>> ldStrategy.java:189) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.initializeMapping >>> (FieldMapping.java:48 >>> 3) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.resolve(FieldMapping.java: >>> 402) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.initializeMapping >>> (ClassMapping.java:83 >>> 0) >>> at >>> org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java: >>> 1574) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolveMapping >>> (MetaDataRepository.jav >>> a:624) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolve >>> (MetaDataRepository.java:493) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:2 >>> 83) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:3 >>> 38) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaDat >>> a >>> ( >>> JPQLExpres >>> sionBuilder.java:151) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:131) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:211) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:181) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTyp >>> e >>> ( >>> JPQLExpres >>> sionBuilder.java:174) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$500 >>> (JPQLExpressionBu >>> ilder.java:61) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder >>> $ParsedJPQL.populate(JPQLExp >>> ressionBuilder.java:1657) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java: >>> 52) >>> at >>> org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilati >>> o >>> n >>> (Expressio >>> nStoreQuery.java:145) >>> at >>> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java: >>> 642) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compilationFromCache >>> (QueryImpl.java:623) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForCompilation >>> (QueryImpl.java:589) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForExecutor >>> (QueryImpl.java:651) >>> at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:558) >>> at >>> org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery >>> (EntityManagerI >>> mpl.java:699) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.orm.jpa.ExtendedEntityManagerCreator >>> $ExtendedEntityManagerIn >>> vocationHandler.invoke(ExtendedEntityManagerCreator.java:237) >>> at $Proxy34.createNamedQuery(Unknown Source) >>> at >>> ca.BidSpec.emall.stores.StoreFactoryImpl.getStoreValueObjectByName >>> (StoreFactoryI >>> mpl.java:88) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect >>> i >>> o >>> n(AopUtils >>> .java:280) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ >>> o >>> i >>> npoint(Ref >>> lectiveMethodInvocation.java:187) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:154) >>> at >>> org.springframework.transaction.interceptor.TransactionInterceptor.i >>> n >>> v >>> oke(Transa >>> ctionInterceptor.java:107) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:176) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke >>> (JdkDynamicAopProxy.j >>> ava:210) >>> at $Proxy32.getStoreValueObjectByName(Unknown Source) >>> at >>> ca.BidSpec.testing.emall.UserFactoryTest.testSetup >>> (UserFactoryTest.java:110) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at junit.framework.TestCase.runTest(TestCase.java:164) >>> at junit.framework.TestCase.runBare(TestCase.java:130) >>> at >>> org.springframework.test.ConditionalTestCase.runBare >>> (ConditionalTestCase.java:69 >>> ) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ac >>> cess$001(AbstractAnnotationAwareTransactionalTests.java:44) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests$1. >>> run(AbstractAnnotationAwareTransactionalTests.java:112) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTest(AbstractAnnotationAwareTransactionalTests.java:177) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nBare(AbstractAnnotationAwareTransactionalTests.java:108) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:159) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:239) >>> at junit.framework.TestResult$1.protect(TestResult.java:110) >>> at junit.framework.TestResult.runProtected(TestResult.java:128) >>> at junit.framework.TestResult.run(TestResult.java:113) >>> at junit.framework.TestCase.run(TestCase.java:120) >>> at junit.framework.TestSuite.runTest(TestSuite.java:228) >>> at junit.framework.TestSuite.run(TestSuite.java:223) >>> at >>> org.junit.internal.runners.OldTestClassRunner.run >>> (OldTestClassRunner.java:35) >>> at >>> org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: >>> 29) >>> at >>> org.junit.internal.runners.TestClassRunner$1.runUnprotected >>> (TestClassRunner.java >>> :42) >>> at >>> org.junit.internal.runners.BeforeAndAfterRunner.runProtected >>> (BeforeAndAfterRunne >>> r.java:34) >>> at >>> org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: >>> 52) >>> at >>> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run >>> (JUnit4TestReferen >>> ce.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.TestExecution.run >>> (TestExecution.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:460) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:673) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run >>> (RemoteTestRunner.java >>> :386) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main >>> (RemoteTestRunner.jav >>> a:196) >>> <4|true|0.0.0> org.apache.openjpa.persistence.ArgumentException: >>> You cannot join >>> on column "category.categoryTypeFK". It is not managed by a mapping >>> that supports joins. >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.assertJoinable >>> (ClassMapping.java:235) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.isForeignKeyObjectId >>> (ClassMapping.java >>> :299) >>> at >>> org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.initialize >>> (RelationFie >>> ldStrategy.java:189) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.initializeMapping >>> (FieldMapping.java:48 >>> 3) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.resolve(FieldMapping.java: >>> 402) >>> at >>> org.apache.openjpa.jdbc.meta.ClassMapping.initializeMapping >>> (ClassMapping.java:83 >>> 0) >>> at >>> org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java: >>> 1574) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolveMapping >>> (MetaDataRepository.jav >>> a:624) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.resolve >>> (MetaDataRepository.java:493) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:2 >>> 83) >>> at >>> org.apache.openjpa.meta.MetaDataRepository.getMetaData >>> (MetaDataRepository.java:3 >>> 38) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaDat >>> a >>> ( >>> JPQLExpres >>> sionBuilder.java:151) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:131) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:211) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMet >>> a >>> D >>> ata(JPQLEx >>> pressionBuilder.java:181) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTyp >>> e >>> ( >>> JPQLExpres >>> sionBuilder.java:174) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$500 >>> (JPQLExpressionBu >>> ilder.java:61) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder >>> $ParsedJPQL.populate(JPQLExp >>> ressionBuilder.java:1657) >>> at >>> org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java: >>> 52) >>> at >>> org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilati >>> o >>> n >>> (Expressio >>> nStoreQuery.java:145) >>> at >>> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java: >>> 642) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compilationFromCache >>> (QueryImpl.java:623) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForCompilation >>> (QueryImpl.java:589) >>> at >>> org.apache.openjpa.kernel.QueryImpl.compileForExecutor >>> (QueryImpl.java:651) >>> at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:558) >>> at >>> org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery >>> (EntityManagerI >>> mpl.java:699) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.orm.jpa.ExtendedEntityManagerCreator >>> $ExtendedEntityManagerIn >>> vocationHandler.invoke(ExtendedEntityManagerCreator.java:237) >>> at $Proxy34.createNamedQuery(Unknown Source) >>> at >>> ca.BidSpec.emall.stores.StoreFactoryImpl.getStoreValueObjectByName >>> (StoreFactoryI >>> mpl.java:88) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect >>> i >>> o >>> n(AopUtils >>> .java:280) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ >>> o >>> i >>> npoint(Ref >>> lectiveMethodInvocation.java:187) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:154) >>> at >>> org.springframework.transaction.interceptor.TransactionInterceptor.i >>> n >>> v >>> oke(Transa >>> ctionInterceptor.java:107) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed >>> (ReflectiveM >>> ethodInvocation.java:176) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke >>> (JdkDynamicAopProxy.j >>> ava:210) >>> at $Proxy32.getStoreValueObjectByName(Unknown Source) >>> at >>> ca.BidSpec.testing.emall.UserFactoryTest.testSetup >>> (UserFactoryTest.java:110) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke >>> (NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke >>> (DelegatingMethodAccessorImpl.jav >>> a:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at junit.framework.TestCase.runTest(TestCase.java:164) >>> at junit.framework.TestCase.runBare(TestCase.java:130) >>> at >>> org.springframework.test.ConditionalTestCase.runBare >>> (ConditionalTestCase.java:69 >>> ) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ac >>> cess$001(AbstractAnnotationAwareTransactionalTests.java:44) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests$1. >>> run(AbstractAnnotationAwareTransactionalTests.java:112) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTest(AbstractAnnotationAwareTransactionalTests.java:177) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150) >>> at >>> org.springframework.test.annotation.AbstractAnnotationAwareTransacti >>> o >>> n >>> alTests.ru >>> nBare(AbstractAnnotationAwareTransactionalTests.java:108) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:159) >>> at >>> org.springframework.test.jpa.AbstractJpaTests.runBare >>> (AbstractJpaTests.java:239) >>> at junit.framework.TestResult$1.protect(TestResult.java:110) >>> at junit.framework.TestResult.runProtected(TestResult.java:128) >>> at junit.framework.TestResult.run(TestResult.java:113) >>> at junit.framework.TestCase.run(TestCase.java:120) >>> at junit.framework.TestSuite.runTest(TestSuite.java:228) >>> at junit.framework.TestSuite.run(TestSuite.java:223) >>> at >>> org.junit.internal.runners.OldTestClassRunner.run >>> (OldTestClassRunner.java:35) >>> at >>> org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: >>> 29) >>> at >>> org.junit.internal.runners.TestClassRunner$1.runUnprotected >>> (TestClassRunner.java >>> :42) >>> at >>> org.junit.internal.runners.BeforeAndAfterRunner.runProtected >>> (BeforeAndAfterRunne >>> r.java:34) >>> at >>> org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: >>> 52) >>> at >>> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run >>> (JUnit4TestReferen >>> ce.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.TestExecution.run >>> (TestExecution.java:38) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:460) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests >>> (RemoteTestRunner >>> .java:673) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run >>> (RemoteTestRunner.java >>> :386) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main >>> (RemoteTestRunner.jav >>> a:196) >>> >>> >>> Phill >>> >> >
