Hard to pull this little piece (of a much larger one) and package it. Let me tool around some more and see if I can uncover more. What is odd is not all my JPA classes have this problem but all inherit from the same base and are fairly similar. I will try commenting out parts of it and see if it clears. IF not I will have to package and send along
Phill -----Original Message----- From: Patrick Linskey [mailto:[EMAIL PROTECTED] Sent: April 30, 2007 1:45 PM To: open-jpa-dev@incubator.apache.org Subject: RE: How to debug object retrieveal in JPA? Odd. Any chance of packaging it up and attaching it to a JIRA issue? -Patrick -- Patrick Linskey BEA Systems, Inc. _______________________________________________________________________ Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its subsidiaries and affiliated entities, that may be confidential, proprietary, copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it. > -----Original Message----- > From: Phill Moran [mailto:[EMAIL PROTECTED] > Sent: Monday, April 30, 2007 10:37 AM > To: open-jpa-dev@incubator.apache.org > Subject: RE: How to debug object retrieveal in JPA? > > I upgraded and result stayed the same. Also this is in a spring > transaction. In fact these are all part of JUnit tests. > > -----Original Message----- > From: Patrick Linskey [mailto:[EMAIL PROTECTED] > Sent: April 30, 2007 12:05 PM > To: open-jpa-dev@incubator.apache.org > Subject: RE: How to debug object retrieveal in JPA? > > It looks like this exception is different than the others; it looks > like this exception is actually being thrown, rather than being put > into your result list. > Is that correct? > > Is this something that you could package up as a test case? > Also, I seem to remember some sort of issue with overly-eager result > list closing in non-transactional environments in 0.9.6, but I can't > find a related JIRA issue. > It's possible that moving up to 0.9.7 (released Friday; > http://cwiki.apache.org/openjpa/downloads.html) might get around the > problem. > > -Patrick > > -- > Patrick Linskey > BEA Systems, Inc. > ______________________________________________________________ > _________ > Notice: This email message, together with any attachments, may > contain information of BEA Systems, Inc., its subsidiaries and > affiliated entities, that may be confidential, proprietary, > copyrighted and/or legally privileged, and is intended solely for the > use of the individual or entity named in this message. If you are not > the intended recipient, and have received this message in error, > please immediately return this by email and then delete it. > > > -----Original Message----- > > From: Phill Moran [mailto:[EMAIL PROTECTED] > > Sent: Monday, April 30, 2007 7:28 AM > > To: open-jpa-dev@incubator.apache.org > > Subject: RE: How to debug object retrieveal in JPA? > > > > Anyone have any more suggestions on how to debug this? > > > > -----Original Message----- > > From: Phill Moran [mailto:[EMAIL PROTECTED] > > Sent: April 26, 2007 11:20 PM > > To: open-jpa-dev@incubator.apache.org > > Subject: RE: How to debug object retrieveal in JPA? > > > > I don't close it in anyway directly > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: April 26, 2007 11:16 PM > > To: open-jpa-dev@incubator.apache.org > > Subject: Re: How to debug object retrieveal in JPA? > > > > Can it be that there is a glue code that closes EM in > between? Just a > > thought... > > > > -marina > > > > Phill Moran wrote: > > > I had suspected the Locale so I made a set/getLocale that > > communicate > > > in > > String. > > > I figured that openJPA does not actually care how I implement. > > > > > > But for this run I removed it completely and did a clean > > rebuild. Good > > > news and bad the exception changed: > > > > > > > > > java.util.NoSuchElementException: The result list has been closed. > > > at > > > > > > org.apache.openjpa.lib.rop.AbstractResultList.assertOpen(AbstractResul > > > tList.java > > > :91) > > > at > > > > > > org.apache.openjpa.lib.rop.AbstractNonSequentialResultList.get(Abstrac > > > tNonSequen > > > tialResultList.java:68) > > > at > > > > > > org.apache.openjpa.kernel.DelegatingResultList.get(DelegatingResultLis > > > t.java:241 > > > ) > > > at > > > > > > ca.BidSpec.emall.user.PersonFactoryImpl.getLoginPersonValueObject(Pers > > > onFactoryI > > > mpl.java:99) > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > orImpl.java:39) > > > at > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > > > orImpl.jav > > > a:25) > > > at java.lang.reflect.Method.invoke(Method.java:597) > > > at > > > > > > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflectio > > > n(AopUtils > > > .java:304) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi > > > npoint(Ref > > > lectiveMethodInvocation.java:172) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > > > eflectiveM > > > ethodInvocation.java:139) > > > at > > > > > > org.springframework.transaction.interceptor.TransactionInterceptor.inv > > > oke(Transa > > > ctionInterceptor.java:107) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > > > eflectiveM > > > ethodInvocation.java:161) > > > at > > > > > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamic > > > AopProxy.j > > > ava:203) > > > at $Proxy34.getLoginPersonValueObject(Unknown Source) > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > orImpl.java:39) > > > at > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > > > orImpl.jav > > > a:25) > > > at java.lang.reflect.Method.invoke(Method.java:597) > > > at > > > > > > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflectio > > > n(AopUtils > > > .java:304) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi > > > npoint(Ref > > > lectiveMethodInvocation.java:172) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > > > eflectiveM > > > ethodInvocation.java:139) > > > at > > > > > > org.springframework.transaction.interceptor.TransactionInterceptor.inv > > > oke(Transa > > > ctionInterceptor.java:107) > > > at > > > > > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > > > eflectiveM > > > ethodInvocation.java:161) > > > at > > > > > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamic > > > AopProxy.j > > > ava:203) > > > at $Proxy34.getLoginPersonValueObject(Unknown Source) > > > at > > > > > ca.BidSpec.testing.emall.UserFactoryTest.testDelete(UserFactor > > yTest.java:119) > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > orImpl.java:39) > > > at > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > > > orImpl.jav > > > a:25) > > > at java.lang.reflect.Method.invoke(Method.java:597) > > > at junit.framework.TestCase.runTest(TestCase.java:168) > > > at junit.framework.TestCase.runBare(TestCase.java:134) > > > at > > > > > > org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCa > > > se.java:69 > > > ) > > > at > > > > > > org.springframework.test.annotation.AbstractAnnotationAwareTransaction > > > alTests.ac > > > cess$001(AbstractAnnotationAwareTransactionalTests.java:47) > > > at > > > > > org.springframework.test.annotation.AbstractAnnotationAwareTra > > nsactionalTests$1. > > > run(AbstractAnnotationAwareTransactionalTests.java:115) > > > at > > > > > > org.springframework.test.annotation.AbstractAnnotationAwareTransaction > > > alTests.ru > > > nTest(AbstractAnnotationAwareTransactionalTests.java:180) > > > at > > > > > > org.springframework.test.annotation.AbstractAnnotationAwareTransaction > > > alTests.ru > > > nTestTimed(AbstractAnnotationAwareTransactionalTests.java:153) > > > at > > > > > > org.springframework.test.annotation.AbstractAnnotationAwareTransaction > > > alTests.ru > > > nBare(AbstractAnnotationAwareTransactionalTests.java:111) > > > at > > > > > org.springframework.test.jpa.AbstractJpaTests.runBare(Abstract > > JpaTests.java:159) > > > at > > > > > org.springframework.test.jpa.AbstractJpaTests.runBare(Abstract > > JpaTests.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:124) > > > at junit.framework.TestSuite.runTest(TestSuite.java:232) > > > at junit.framework.TestSuite.run(TestSuite.java:227) > > > at > > > > > org.junit.internal.runners.OldTestClassRunner.run(OldTestClass > > Runner.java:35) > > > at > > > > > org.junit.internal.runners.CompositeRunner.run(CompositeRunner > > .java:29) > > > at > > > > > > org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassR > > > unner.java > > > :42) > > > at > > > > > > org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAnd > > > AfterRunne > > > r.java:34) > > > at > > > > > org.junit.internal.runners.TestClassRunner.run(TestClassRunner > > .java:52) > > > at > > > > > > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4T > > > estReferen > > > ce.java:38) > > > at > > > > > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestEx > > ecution.java:38) > > > at > > > > > > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote > > > TestRunner > > > .java:460) > > > at > > > > > > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote > > > TestRunner > > > .java:673) > > > at > > > > > > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR > > > unner.java > > > :386) > > > at > > > > > > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest > > > Runner.jav > > > a:196) > > > > > > -----Original Message----- > > > From: Patrick Linskey [mailto:[EMAIL PROTECTED] > > > Sent: April 26, 2007 9:59 PM > > > To: open-jpa-dev@incubator.apache.org > > > Subject: RE: How to debug object retrieveal in JPA? > > > > > > > > >>Caused by: java.lang.NullPointerException > > >> at java.util.Locale.toLowerCase(Locale.java:1060) > > >> at java.util.Locale.convertOldISOCodes(Locale.java:1083) > > >> at java.util.Locale.<init>(Locale.java:272) > > >> at java.util.Locale.<init>(Locale.java:302) > > >> at ca.BidSpec.emall.user.Person.pcsetLocale(Person.java:375) > > >> at ca.BidSpec.emall.user.Person.pcClearFields(Person.java) > > >> at ca.BidSpec.emall.user.Person.pcNewInstance(Person.java) > > >> at > > >>org.apache.openjpa.enhance.PCRegistry.newInstance(PCRegistry > > .java:117) > > > > > > > > > Now we're getting somewhere.... what happens if you remove > > the Locale > > > field from the Person class? > > > > > > -Patrick > > > > > > -- > > > Patrick Linskey > > > BEA Systems, Inc. > > > > > > ______________________________________________________________________ > > > _ > > > Notice: This email message, together with any attachments, may > > > contain information of BEA Systems, Inc., its > subsidiaries and > > > affiliated entities, that may be confidential, proprietary, > > > copyrighted and/or legally privileged, and is intended > > solely for the > > > use of the individual or entity named in this message. If > > you are not > > > the intended recipient, and have received this message in error, > > > please > > immediately return this by email and then delete it. > > > > > > > > >>-----Original Message----- > > >>From: Phill Moran [mailto:[EMAIL PROTECTED] > > >>Sent: Thursday, April 26, 2007 6:32 PM > > >>To: open-jpa-dev@incubator.apache.org > > >>Subject: RE: How to debug object retrieveal in JPA? > > >> > > >>Run that config gives us this lovely message: > > >> > > >><0|false|0.9.6-incubating> > > >>org.apache.openjpa.persistence.PersistenceException: > > >>null > > >> at > > >>org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:851) > > >> at > > >>org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:748) > > >> at > > >>org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStore > > >>Manager.java:773) > > >> at > > >>org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult > > >>.java:254) > > >> at > > >>org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(Selec > > >>tImpl.java:2115) > > >> at > > >>org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult > > >>.java:248) > > >> at > > >>org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.ge > > >>tResultObject(Inst > > >>anceResultObjectProvider.java:56) > > >> at > > >>org.apache.openjpa.lib.rop.WindowResultList.getInternal(Window > > >>ResultList.java:12 > > >>8) > > >> at > > >>org.apache.openjpa.lib.rop.AbstractNonSequentialResultList.get > > >>(AbstractNonSequen > > >>tialResultList.java:69) > > >> at > > >>org.apache.openjpa.kernel.DelegatingResultList.get(DelegatingR > > >>esultList.java:241 > > >>) > > >> at > > >>ca.BidSpec.emall.user.PersonFactoryImpl.getLoginPersonValueObj > > >>ect(PersonFactoryI > > >>mpl.java:99) > > >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > >> at > > >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > >>orImpl.java:39) > > >> at > > >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > > >>odAccessorImpl.jav > > >>a:25) > > >> at java.lang.reflect.Method.invoke(Method.java:597) > > >> at > > >>org.springframework.aop.support.AopUtils.invokeJoinpointUsingR > > >>eflection(AopUtils > > >>.java:304) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.i > > >>nvokeJoinpoint(Ref > > >>lectiveMethodInvocation.java:172) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.p > > >>roceed(ReflectiveM > > >>ethodInvocation.java:139) > > >> at > > >>org.springframework.transaction.interceptor.TransactionInterce > > >>ptor.invoke(Transa > > >>ctionInterceptor.java:107) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.p > > >>roceed(ReflectiveM > > >>ethodInvocation.java:161) > > >> at > > >>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd > > >>kDynamicAopProxy.j > > >>ava:203) > > >> at $Proxy34.getLoginPersonValueObject(Unknown Source) > > >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > >> at > > >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > >>orImpl.java:39) > > >> at > > >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > > >>odAccessorImpl.jav > > >>a:25) > > >> at java.lang.reflect.Method.invoke(Method.java:597) > > >> at > > >>org.springframework.aop.support.AopUtils.invokeJoinpointUsingR > > >>eflection(AopUtils > > >>.java:304) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.i > > >>nvokeJoinpoint(Ref > > >>lectiveMethodInvocation.java:172) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.p > > >>roceed(ReflectiveM > > >>ethodInvocation.java:139) > > >> at > > >>org.springframework.transaction.interceptor.TransactionInterce > > >>ptor.invoke(Transa > > >>ctionInterceptor.java:107) > > >> at > > >>org.springframework.aop.framework.ReflectiveMethodInvocation.p > > >>roceed(ReflectiveM > > >>ethodInvocation.java:161) > > >> at > > >>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd > > >>kDynamicAopProxy.j > > >>ava:203) > > >> at $Proxy34.getLoginPersonValueObject(Unknown Source) > > >> at > > >>ca.BidSpec.testing.emall.UserFactoryTest.testDelete(UserFactor > > >>yTest.java:119) > > >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > >> at > > >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > >>orImpl.java:39) > > >> at > > >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > > >>odAccessorImpl.jav > > >>a:25) > > >> at java.lang.reflect.Method.invoke(Method.java:597) > > >> at junit.framework.TestCase.runTest(TestCase.java:168) > > >> at junit.framework.TestCase.runBare(TestCase.java:134) > > >> at > > >>org.springframework.test.ConditionalTestCase.runBare(Condition > > >>alTestCase.java:69 > > >>) > > >> at > > >>org.springframework.test.annotation.AbstractAnnotationAwareTra > > >>nsactionalTests.ac > > >>cess$001(AbstractAnnotationAwareTransactionalTests.java:47) > > >> at > > >>org.springframework.test.annotation.AbstractAnnotationAwareTra > > >>nsactionalTests$1. > > >>run(AbstractAnnotationAwareTransactionalTests.java:115) > > >> at > > >>org.springframework.test.annotation.AbstractAnnotationAwareTra > > >>nsactionalTests.ru > > >>nTest(AbstractAnnotationAwareTransactionalTests.java:180) > > >> at > > >>org.springframework.test.annotation.AbstractAnnotationAwareTra > > >>nsactionalTests.ru > > >>nTestTimed(AbstractAnnotationAwareTransactionalTests.java:153) > > >> at > > >>org.springframework.test.annotation.AbstractAnnotationAwareTra > > >>nsactionalTests.ru > > >>nBare(AbstractAnnotationAwareTransactionalTests.java:111) > > >> at > > >>org.springframework.test.jpa.AbstractJpaTests.runBare(Abstract > > >>JpaTests.java:159) > > >> at > > >>org.springframework.test.jpa.AbstractJpaTests.runBare(Abstract > > >>JpaTests.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:124) > > >> at junit.framework.TestSuite.runTest(TestSuite.java:232) > > >> at junit.framework.TestSuite.run(TestSuite.java:227) > > >> at > > >>org.junit.internal.runners.OldTestClassRunner.run(OldTestClass > > >>Runner.java:35) > > >> at > > >>org.junit.internal.runners.CompositeRunner.run(CompositeRunner > > >>.java:29) > > >> at > > >>org.junit.internal.runners.TestClassRunner$1.runUnprotected(Te > > >>stClassRunner.java > > >>:42) > > >> at > > >>org.junit.internal.runners.BeforeAndAfterRunner.runProtected(B > > >>eforeAndAfterRunne > > >>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(TestEx > > >>ecution.java:38) > > >> at > > >>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTest > > >>s(RemoteTestRunner > > >>.java:460) > > >> at > > >>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTest > > >>s(RemoteTestRunner > > >>.java:673) > > >> at > > >>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(Rem > > >>oteTestRunner.java > > >>:386) > > >> at > > >>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(Re > > >>moteTestRunner.jav > > >>a:196) > > >>Caused by: java.lang.NullPointerException > > >> at java.util.Locale.toLowerCase(Locale.java:1060) > > >> at java.util.Locale.convertOldISOCodes(Locale.java:1083) > > >> at java.util.Locale.<init>(Locale.java:272) > > >> at java.util.Locale.<init>(Locale.java:302) > > >> at ca.BidSpec.emall.user.Person.pcsetLocale(Person.java:375) > > >> at ca.BidSpec.emall.user.Person.pcClearFields(Person.java) > > >> at ca.BidSpec.emall.user.Person.pcNewInstance(Person.java) > > >> at > > >>org.apache.openjpa.enhance.PCRegistry.newInstance(PCRegistry > > .java:117) > > >> at > > >>org.apache.openjpa.kernel.StateManagerImpl.initialize(StateMan > > >>agerImpl.java:247) > > >> at > > >>org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeStat > > >>e(JDBCStoreManager > > >>.java:327) > > >> at > > >>org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDB > > >>CStoreManager.java > > >>:252) > > >> at > > >>org.apache.openjpa.kernel.DelegatingStoreManager.initialize(De > > >>legatingStoreManag > > >>er.java:108) > > >> at > > >>org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreM > > >>anager.java:54) > > >> at > > > >>org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:870) > > >> at > > >>org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:828) > > >> ... 64 more > > >> > > >>-----Original Message----- > > >>From: Patrick Linskey [mailto:[EMAIL PROTECTED] > > >>Sent: April 26, 2007 5:40 PM > > >>To: open-jpa-dev@incubator.apache.org > > >>Subject: RE: How to debug object retrieveal in JPA? > > >> > > >> > > >>>Can you post what you get if you do '((Exception) > > >>>results.get(0)).printStackTrace()'? > > >> > > >>... so results.get(0) is returning a List? That's very odd. > > >>What if you > > >>do: > > >> > > >>System.out.println(results.get(0))? > > >> > > >>If it is a List of Exceptions, what if you print out the > > stacks of the > > >>exceptions in the list? > > >> > > >>-Patrick > > >> > > >>-- > > >>Patrick Linskey > > >>BEA Systems, Inc. > > >>______________________________________________________________ > > >>_________ > > >>Notice: This email message, together with any attachments, may > > >>contain information of BEA Systems, Inc., its > subsidiaries and > > >>affiliated entities, that may be confidential, proprietary, > > >>copyrighted and/or legally privileged, and is intended > > solely for the > > >>use of the individual or entity named in this message. If > > you are not > > >>the intended recipient, and have received this message in error, > > >>please immediately return this by email and then delete it. > > >> > > >> > > >>>-----Original Message----- > > >>>From: Phill Moran [mailto:[EMAIL PROTECTED] > > >>>Sent: Thursday, April 26, 2007 2:36 PM > > >>>To: open-jpa-dev@incubator.apache.org > > >>>Subject: RE: How to debug object retrieveal in JPA? > > >>> > > >>>Can't cast List to Exception > > >>> > > >>>-----Original Message----- > > >>>From: Patrick Linskey [mailto:[EMAIL PROTECTED] > > >>>Sent: April 26, 2007 5:00 PM > > >>>To: open-jpa-dev@incubator.apache.org > > >>>Subject: RE: How to debug object retrieveal in JPA? > > >>> > > >>>So you're saying that the ResultList contains an Exception? > > >>>Can you post what you get if you do '((Exception) > > >>>results.get(0)).printStackTrace()'? > > >>> > > >>>-Patrick > > >>> > > >>>-- > > >>>Patrick Linskey > > >>>BEA Systems, Inc. > > >>>______________________________________________________________ > > >>>_________ > > >>>Notice: This email message, together with any attachments, may > > >>>contain information of BEA Systems, Inc., its > > subsidiaries and > > >>>affiliated entities, that may be confidential, proprietary, > > >>>copyrighted and/or legally privileged, and is intended > > >> > > >>solely for the > > >> > > >>>use of the individual or entity named in this message. If > > >> > > >>you are not > > >> > > >>>the intended recipient, and have received this message in error, > > >>>please immediately return this by email and then delete it. > > >>> > > >>> > > >>>>-----Original Message----- > > >>>>From: Phill Moran [mailto:[EMAIL PROTECTED] > > >>>>Sent: Thursday, April 26, 2007 1:44 PM > > >>>>To: open-jpa-dev@incubator.apache.org > > >>>>Subject: RE: How to debug object retrieveal in JPA? > > >>>> > > >>>>Some more information on this exception > > >>>> > > >>>>Right after the execution the exception held inside the > result is > > >>>>"com.sun.jdi.InvocationException occurred invoking > > >> > > >>method..." Can't > > >> > > >>>>seem to get more data out of it > > >>>> > > >>>>Once the system.out is executed the exception changes to > > >>> > > >>>"The result > > >>> > > >>>>list has been closed" > > >>>> > > >>>>-----Original Message----- > > >>>>From: Phill Moran [mailto:[EMAIL PROTECTED] > > >>>>Sent: April 26, 2007 4:18 PM > > >>>>To: open-jpa-dev@incubator.apache.org > > >>>>Subject: RE: How to debug object retrieveal in JPA? > > >>>> > > >>>>I did not mean it threw an NPE but I was left with a null > > >>> > > >>>result list. > > >>> > > >>>>I have setup trace already and I actually get nothing back. > > >>>>Here is the trace across the execution point > > >>>> > > >>>>13734 WARN [main] openjpa.MetaData - Found duplicate query > > >>>>"PersonFXLastFirst" in "class ca.BidSpec.emall.user.Person". > > >>>>Ignoring. > > >>>>22594 TRACE [main] openjpa.jdbc.SQL - <t 31845311, conn > > >>>>9575056> executing prepstmnt 31103354 SELECT t0.id, > > >>>>t0.lastUpdated, t0.active, t0.activeFrom, t0.activeUntil, > > >>> > > >>>t0.created, > > >>> > > >>>>t0.displayName, t0.firstName, t0.lastLogin, t0.lastName, > > >> > > >>t0.locale, > > >> > > >>>>t0.loginName, t0.middleName, t2.id, t2.lastUpdated, > > >> > > >>t2.description, > > >> > > >>>>t3.id, t3.lastUpdated, t3.description, t2.value, t4.id, > > >>>>t4.lastUpdated, t4.description, t4.categoryTypeFK, > > >> > > >>t4.value, t1.id, > > >> > > >>>>t1.lastUpdated, t1.created, t1.description, t1.displayName, > > >>> > > >>>t1.name, > > >>> > > >>>>t5.id, t5.lastUpdated, t5.description, t5.categoryTypeFK, > > >> > > >>t5.value, > > >> > > >>>>t0.title, t0.visible FROM person t0 INNER JOIN > manufacturer t1 ON > > >>>>t0.manufacturerFK = t1.id LEFT OUTER JOIN category t2 ON > > >>> > > >>>t0.roleFK = > > >>> > > >>>>t2.id LEFT OUTER JOIN category > > >>>>t4 ON t0.salutationFK = t4.id LEFT OUTER JOIN category t5 > > >>> > > >>>ON t1.typeFK > > >>> > > >>>>= t5.id LEFT OUTER JOIN categorytype t3 ON > > >>> > > >>>t2.categoryTypeFK = t3.id > > >>> > > >>>>WHERE > > >>>>(UPPER(t1.name) = ? AND UPPER(t0.loginName) = ?) ORDER BY > > >>> > > >>>t0.lastName > > >>> > > >>>>ASC, t0.firstName ASC [params=(String) BIDSPEC, > > >>>>(String) PMORAN] > > >>>>22609 TRACE [main] openjpa.jdbc.SQL - <t 31845311, conn > > >>>>9575056> [15 ms] spent > > >>>>27469 TRACE [main] openjpa.jdbc.SQL - <t 31845311, conn > > >>>>9575056> executing prepstmnt 3888519 SELECT COUNT(*) FROM > > >>>>person t0 INNER JOIN manufacturer t1 ON t0.manufacturerFK = > > >>> > > >>>t1.id LEFT > > >>> > > >>>>OUTER JOIN category t2 ON t0.roleFK = t2.id LEFT OUTER > > >> > > >>JOIN category > > >> > > >>>>t4 ON t0.salutationFK = t4.id LEFT OUTER JOIN category t5 > > >>> > > >>>ON t1.typeFK > > >>> > > >>>>= t5.id LEFT OUTER JOIN categorytype t3 ON > > >>> > > >>>t2.categoryTypeFK = t3.id > > >>> > > >>>>WHERE > > >>>>(UPPER(t1.name) = ? AND UPPER(t0.loginName) = ?) > > >>>>[params=(String) BIDSPEC, > > >>>>(String) PMORAN] > > >>>>27469 TRACE [main] openjpa.jdbc.SQL - <t 31845311, conn > > >>>>9575056> [0 ms] spent > > >>>>1 > > >>>>[2007-04-26 16:07:36,125] INFO > > >>>>ca.BidSpec.testing.emall.UserFactoryTest Rolled back > > >>> > > >>>transaction after > > >>> > > >>>>test execution > > >>>> > > >>>>What is interesting is the line with a "1" (from > > >>>>System.out.println(results.size())). What this > represents is the > > >>>>message that the "result list is closed" nothing else in > > >> > > >>the trace. > > >> > > >>>>So what causes the result list to be closed? > > >>>> > > >>>>Phill > > >>>> > > >>>>-----Original Message----- > > >>>>From: Marc Prud'hommeaux [mailto:[EMAIL PROTECTED] > > >>> > > >>>On Behalf > > >>> > > >>>>Of Marc Prud'hommeaux > > >>>>Sent: April 26, 2007 3:54 PM > > >>>>To: open-jpa-dev@incubator.apache.org > > >>>>Subject: Re: How to debug object retrieveal in JPA? > > >>>> > > >>>>Phill- > > >>>> > > >>>>The maximum verbosity of logging is obtained by specifying the > > >>>>"openjpa.Log" > > >>>>property to "DefaultLevel=TRACE". > > >>>> > > >>>>What is the full exception stack trace? We might be > able to help > > >>>>identify the problem. In any case OpenJPA should never be > > >>> > > >>>throwing an > > >>> > > >>>>NPE, so we should at least probably fix the error message. > > >>>> > > >>>> > > >>>>On Apr 26, 2007, at 12:39 PM, Phill Moran wrote: > > >>>> > > >>>> > > >>>>>Community, > > >>>>> > > >>>>>How does one go about debugging object retrieval/creation. > > >>>> > > >>>>I continue > > >>>> > > >>>>>to have exceptions and little to go on as far as the cause. > > >>>>>The named JPQL is good since I know it generates a good sql > > >>>> > > >>>>(can trace > > >>>> > > >>>>>code and see it) . I know the sql is good as I can > > >>>> > > >>>>copy/paste it into > > >>>> > > >>>>>mysql query browser, execute and get the correct data > back. The > > >>>>>problem is that these lines result in an NPE. > > >>>>> > > >>>>> Query q = > > >>>>> > > >> > > >>this.getEntityManager().createNamedQuery("PersonFXStoreAndLogin"); > > >> > > >>>>> q.setParameter("storeName", > > >> > > >>storeName.toUpperCase()); > > >> > > >>>>> q.setParameter("loginName", > > >> > > >>loginName.toUpperCase()); > > >> > > >>>>> List<Person> results = null; > > >>>>> try { > > >>>>> results = (List<Person>) q.getResultList(); > > >>>>> System.out.println(results.size()); > > >>>>> } > > >>>>> catch(Exception e) { > > >>>>> e.printStackTrace(); > > >>>>> } > > >>>>> if (results.isEmpty()) { <- NPE thrown here > > >>>>> throw new UserNotFoundException("No > > >>>> > > >>>>user found"); > > >>>> > > >>>>> } > > >>>>>Also the "mappingTool validate" seems to work fine. Of > > >> > > >>course how > > >> > > >>>>>would I know since I can find no description of what a good > > >>>> > > >>>>one looks > > >>>> > > >>>>>like but reading it (no > > >>>>>exceptions) seem to make sense. > > >>>>> > > >>>>>Any help would be much appreciated. > > >>>>> > > >>>>>Phill > > >>>>> > > >>>> > > >>>> > > >>>Notice: This email message, together with any attachments, may > > >>>contain information of BEA Systems, Inc., its > > subsidiaries and > > >>>affiliated entities, that may be confidential, proprietary, > > >>>copyrighted and/or legally privileged, and is intended > > >> > > >>solely for the > > >> > > >>>use of the individual or entity named in this message. If > > >> > > >>you are not > > >> > > >>>the intended recipient, and have received this message in error, > > >>>please immediately return this by email and then delete it. > > >>> > > >>> > > >> > > >>Notice: This email message, together with any attachments, may > > >>contain information of BEA Systems, Inc., its > subsidiaries and > > >>affiliated entities, that may be confidential, proprietary, > > >>copyrighted and/or legally privileged, and is intended > > solely for the > > >>use of the individual or entity named in this message. If > > you are not > > >>the intended recipient, and have received this message in error, > > >>please immediately return this by email and then delete it. > > >> > > >> > > > > > > > > > Notice: This email message, together with any attachments, may > > > contain information of BEA Systems, Inc., its > subsidiaries and > > > affiliated entities, that may be confidential, proprietary, > > > copyrighted and/or legally privileged, and is intended > > solely for the > > > use of the individual or entity named in this message. If > > you are not > > > the intended recipient, and have received this message in error, > > > please > > immediately return this by email and then delete it. > > > > > > > > > Notice: This email message, together with any attachments, may > contain information of BEA Systems, Inc., its subsidiaries and > affiliated entities, that may be confidential, proprietary, > copyrighted and/or legally privileged, and is intended solely for the > use of the individual or entity named in this message. If you are not > the intended recipient, and have received this message in error, > please immediately return this by email and then delete it. > > Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its subsidiaries and affiliated entities, that may be confidential, proprietary, copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it.
