Re: Duplicate Query - where none exists

[Marc Prud'hommeaux]

Hmm. I don't see anything wrong with that mapping. How is the  
@OneToOne on the other side of the @ManyToOne defined (if you have one)?

It might be good to see the output of the mappingtool's validate  
action on your classes. E.g.:

  java org.apache.openjpa.jdbc.meta.MappingTool -action validate - 
Log DefaultLevel=TRACE META-INF/persistence.xml



On Apr 5, 2007, at 6:02 AM, Phill Moran wrote:

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.getClassMetaDa 
t
a
(
JPQLExpres
sionBuilder.java:151)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:131)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:211)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:181)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTy 
p
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.populateFromCompilat 
i
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.invokeJoinpointUsingReflec 
t
i
o
n(AopUtils
.java:280)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invoke 
J
o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(ReflectiveM
ethodInvocation.java:154)
        at
org.springframework.transaction.interceptor.TransactionInterceptor. 
i
n
v
oke(Transa
ctionInterceptor.java:107)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(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.AbstractAnnotationAwareTransact 
i
o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
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.initializ 
e
(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.initializ 
e
(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.getClassMetaDa 
t
a
(
JPQLExpres
sionBuilder.java:151)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:131)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:211)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:181)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTy 
p
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.populateFromCompilat 
i
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.invokeJoinpointUsingReflec 
t
i
o
n(AopUtils
.java:280)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invoke 
J
o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(ReflectiveM
ethodInvocation.java:154)
        at
org.springframework.transaction.interceptor.TransactionInterceptor. 
i
n
v
oke(Transa
ctionInterceptor.java:107)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(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.AbstractAnnotationAwareTransact 
i
o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
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.initializ 
e
(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.getClassMetaDa 
t
a
(
JPQLExpres
sionBuilder.java:151)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:131)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:211)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:181)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTy 
p
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.populateFromCompilat 
i
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.invokeJoinpointUsingReflec 
t
i
o
n(AopUtils
.java:280)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invoke 
J
o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(ReflectiveM
ethodInvocation.java:154)
        at
org.springframework.transaction.interceptor.TransactionInterceptor. 
i
n
v
oke(Transa
ctionInterceptor.java:107)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(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.AbstractAnnotationAwareTransact 
i
o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
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.initializ 
e
(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.getClassMetaDa 
t
a
(
JPQLExpres
sionBuilder.java:151)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:131)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:211)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMe 
t
a
D
ata(JPQLEx
pressionBuilder.java:181)
        at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateTy 
p
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.populateFromCompilat 
i
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.invokeJoinpointUsingReflec 
t
i
o
n(AopUtils
.java:280)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invoke 
J
o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(ReflectiveM
ethodInvocation.java:154)
        at
org.springframework.transaction.interceptor.TransactionInterceptor. 
i
n
v
oke(Transa
ctionInterceptor.java:107)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.procee 
d
(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.AbstractAnnotationAwareTransact 
i
o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at
org.springframework.test.annotation.AbstractAnnotationAwareTransact 
i
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