Re: Duplicate Query - where none exists

Thu, 05 Apr 2007 11:25:05 -0700 

Hans-
I just did a query test with the examples/hellojpa/Message.java class in the latest openjpa-0.9.7-incubating-SNAPSHOT, and when I add: 

@NamedQueries({
    @NamedQuery(name="q1", query="select x from Message x"),
    @NamedQuery(name="q1", query="select x from Message x")
})


I get the duplicate query warning. But when I remove one of the  
queries, I get no warning. So it appears to be working as expected.



Can you show us your class that is giving the warning, as well as the  
logging output with verbose logging enabled (i.e., setting  
"openjpa.Log" to "DefaultLevel=TRACE")?



On Apr 5, 2007, at 12:01 AM, Hans Prueller wrote:


perhaps this can help out:


I just started using OpenJPA and I have ONLY A SINGLE CLASS WITHOUT  
ANY RELATIONS where I get this duplicate-query warning. So I can't  
believe that its related to that somehow...


Hans

-------- Original-Nachricht --------
Datum: Wed, 4 Apr 2007 23:42:01 -0700
Von: Marc Prud\'hommeaux <[EMAIL PROTECTED]>
An: open-jpa-dev@incubator.apache.org
Betreff: 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.getClassMetaD 
at

a
(
JPQLExpres
sionBuilder.java:151)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassM 
et

a
D
ata(JPQLEx
pressionBuilder.java:131)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:211)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:181)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateT 
yp

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.populateFromCompila 
ti

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.invokeJoinpointUsingRefle 
ct

i
o
n(AopUtils
.java:280)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.invok 
eJ

o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(ReflectiveM
ethodInvocation.java:154)
        at

org.springframework.transaction.interceptor.TransactionInterceptor 
.i

n
v
oke(Transa
ctionInterceptor.java:107)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(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.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

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.initiali 
ze

(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.initiali 
ze

(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.getClassMetaD 
at

a
(
JPQLExpres
sionBuilder.java:151)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassM 
et

a
D
ata(JPQLEx
pressionBuilder.java:131)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:211)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:181)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateT 
yp

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.populateFromCompila 
ti

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.invokeJoinpointUsingRefle 
ct

i
o
n(AopUtils
.java:280)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.invok 
eJ

o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(ReflectiveM
ethodInvocation.java:154)
        at

org.springframework.transaction.interceptor.TransactionInterceptor 
.i

n
v
oke(Transa
ctionInterceptor.java:107)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(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.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

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.initiali 
ze

(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.getClassMetaD 
at

a
(
JPQLExpres
sionBuilder.java:151)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassM 
et

a
D
ata(JPQLEx
pressionBuilder.java:131)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:211)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:181)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateT 
yp

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.populateFromCompila 
ti

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.invokeJoinpointUsingRefle 
ct

i
o
n(AopUtils
.java:280)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.invok 
eJ

o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(ReflectiveM
ethodInvocation.java:154)
        at

org.springframework.transaction.interceptor.TransactionInterceptor 
.i

n
v
oke(Transa
ctionInterceptor.java:107)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(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.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

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.initiali 
ze

(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.getClassMetaD 
at

a
(
JPQLExpres
sionBuilder.java:151)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassM 
et

a
D
ata(JPQLEx
pressionBuilder.java:131)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:211)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateM 
et

a
D
ata(JPQLEx
pressionBuilder.java:181)
        at

org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateT 
yp

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.populateFromCompila 
ti

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.invokeJoinpointUsingRefle 
ct

i
o
n(AopUtils
.java:280)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.invok 
eJ

o
i
npoint(Ref
lectiveMethodInvocation.java:187)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(ReflectiveM
ethodInvocation.java:154)
        at

org.springframework.transaction.interceptor.TransactionInterceptor 
.i

n
v
oke(Transa
ctionInterceptor.java:107)
        at

org.springframework.aop.framework.ReflectiveMethodInvocation.proce 
ed

(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.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ac
cess$001(AbstractAnnotationAwareTransactionalTests.java:44)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests$1.
run(AbstractAnnotationAwareTransactionalTests.java:112)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTest(AbstractAnnotationAwareTransactionalTests.java:177)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

o
n
alTests.ru
nTestTimed(AbstractAnnotationAwareTransactionalTests.java:150)
        at

org.springframework.test.annotation.AbstractAnnotationAwareTransac 
ti

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







--
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
























					Reply via email to