You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by gilbertoca <gi...@gmail.com> on 2010/06/09 16:29:48 UTC
Attribute 'pk-column-value' is not allowed to appear in element
'generated-value'
Hi, hope everyone is well!
Can anyone help me understand the following exception (
http://code.google.com/p/construtor/source/browse/trunk/park-jpa/core/src/main/resources/META-INF/orm.xml
my orm.xml file ):
[CODE]
[INFO] [compiler:compile {execution: default-compile}]
[INFO] Compiling 13 source files to
/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes
[INFO] [antrun:run {execution: default}]
[INFO] Executing tasks
216 parkPU INFO [main] openjpa.Tool - No targets were given. Running on
all classes in your persistent classes list, or all metadata files in
classpath directories if you have not listed your persistent classes. Use
-help to display tool usage information.
<openjpa-2.0.0-r422266:935683 nonfatal general error>
org.apache.openjpa.util.GeneralException: org.xml.sax.SAXException:
file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
[Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to appear
in element 'generated-value'.
at
org.apache.openjpa.persistence.PersistenceMetaDataFactory.parseXML(PersistenceMetaDataFactory.java:295)
at
org.apache.openjpa.persistence.PersistenceMetaDataFactory.load(PersistenceMetaDataFactory.java:228)
at
org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:554)
at
org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:374)
at
org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:358)
at org.apache.openjpa.enhance.PCEnhancer.<init>(PCEnhancer.java:256)
at org.apache.openjpa.enhance.PCEnhancer.run(PCEnhancer.java:4653)
at
org.apache.openjpa.ant.PCEnhancerTask.executeOn(PCEnhancerTask.java:89)
at
org.apache.openjpa.lib.ant.AbstractTask.execute(AbstractTask.java:171)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at
org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:118)
at
org.apache.maven.plugin.antrun.AntRunMojo.execute(AntRunMojo.java:98)
at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:556)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:535)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
at
org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: java.io.IOException: org.xml.sax.SAXException:
file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
[Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to appear
in element 'generated-value'.
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.parseNewResource(XMLMetaDataParser.java:396)
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:334)
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:311)
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:284)
at
org.apache.openjpa.persistence.XMLPersistenceMetaDataParser.parse(XMLPersistenceMetaDataParser.java:364)
at
org.apache.openjpa.persistence.PersistenceMetaDataFactory.parseXML(PersistenceMetaDataFactory.java:293)
... 37 more
Caused by: org.xml.sax.SAXException:
file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
[Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to appear
in element 'generated-value'.
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.getException(XMLMetaDataParser.java:675)
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.error(XMLMetaDataParser.java:434)
at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:137)
at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:387)
at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:321)
at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:413)
at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3168)
at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.processAttributes(XMLSchemaValidator.java:2633)
at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2040)
at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:708)
at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:353)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2723)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:624)
at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:116)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:486)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:810)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:740)
at
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:110)
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1208)
at
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:525)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:392)
at
org.apache.openjpa.lib.meta.XMLMetaDataParser.parseNewResource(XMLMetaDataParser.java:393)
... 42 more
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] An Ant BuildException has occured: <openjpa-2.0.0-r422266:935683
nonfatal general error> org.apache.openjpa.util.GeneralException:
org.xml.sax.SAXException:
file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
[Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to appear
in element 'generated-value'.
[INFO]
------------------------------------------------------------------------
[INFO] For more information, run Maven with the -e switch
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 9 seconds
[INFO] Finished at: Wed Jun 09 10:51:26 BRT 2010
[INFO] Final Memory: 17M/67M
[INFO]
------------------------------------------------------------------------
gilberto@SUGEP-DMASI:~/dev/netbeans-config/park-jpa/core>
[/CODE]
I've defined a per persistent unit table-generator element with default
pk-column-value="DEFAULT" and in the entity definition I override it like
so: pk-column-value="parking".
Regards,
Gilberto
--
View this message in context: http://openjpa.208410.n2.nabble.com/Attribute-pk-column-value-is-not-allowed-to-appear-in-element-generated-value-tp5158720p5158720.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: Attribute 'pk-column-value' is not allowed to appear in element
'generated-value'
Posted by gilbertoca <gi...@gmail.com>.
After I set a eclipse profile(maven) in my project[1] and see that all my
tests passes, I left the OpenJPA project aside for a while.
Today, I've time to discovery the openjpa's problem when it reads the
orm.xml[2]:
> <id name="id">
> <column name="id"/>
> <generated-value strategy="TABLE"
> generator="person_table_generator "/>
> </id>
>
Can you see the problem?
You will not believe! See the write space after the generator's attribute
contents. Yes, it was the cause of the problem!
I've tested with openjpa 2.0.0 and 2.0.1.
But, my tests doesn't pass. Giving me another exception:
> -------------------------------------------------------------------------------
> Test set: park.model.LegalEntityTest
> -------------------------------------------------------------------------------
> Tests run: 4, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 5.618 sec
> <<< FAILURE!
> findAll(park.model.LegalEntityTest) Time elapsed: 1.257 sec <<< ERROR!
> <openjpa-2.0.1-r422266:989424 fatal store error>
> org.apache.openjpa.persistence.RollbackException: Column "TABLE_NAME0" not
> found; SQL statement:
> SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ? FOR UPDATE
> [42122-131] {SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ?
> FOR UPDATE} [code=42122, state=42S22]
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:584)
> at park.model.LegalEntityTest.findAll(LegalEntityTest.java:125)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
> at
> org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
> at
> org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
> at
> org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
> at
> org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
> at
> org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
> at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
> at
> org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
> Caused by: <openjpa-2.0.1-r422266:989424 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Column "TABLE_NAME0"
> not found; SQL statement:
> SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ? FOR UPDATE
> [42122-131] {SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ?
> FOR UPDATE} [code=42122, state=42S22]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4832)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4792)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62)
> at
> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:66)
> at
> org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160)
> at
> org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:774)
> at
> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:487)
> at
> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:463)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:758)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135)
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:605)
> at
> org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:2952)
> at
> org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:40)
> at
> org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1047)
> at
> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2077)
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037)
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955)
> at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479)
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:560)
> ... 29 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Column
> "TABLE_NAME0" not found; SQL statement:
> SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ? FOR UPDATE
> [42122-131] {SELECT TABLE_VALUE FROM table_generator WHERE TABLE_NAME0 = ?
> FOR UPDATE} [code=42122, state=42S22]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:273)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:253)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:70)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:305)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:186)
> at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:155)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:175)
> at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:562)
> at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:542)
> at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:531)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.prepareStatement(TableJDBCSeq.java:806)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.getSequence(TableJDBCSeq.java:545)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.setSequence(TableJDBCSeq.java:587)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:892)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:454)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:305)
> at
> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60)
> ... 47 more
>
>
maven test log
> -------------------------------------------------------
> T E S T S
> -------------------------------------------------------
> Running park.model.LegalEntityTest
> 894 parkPU INFO [main] openjpa.Runtime - OpenJPA dynamically loaded
> the class enhancer. Any classes that were not enhanced at build time will
> be enhanced when they are loaded by the JVM.
> 960 parkPU INFO [main] openjpa.Runtime - Starting OpenJPA 2.0.1
> 1079 parkPU INFO [main] openjpa.jdbc.JDBC - Using dictionary class
> "org.apache.openjpa.jdbc.sql.H2Dictionary".
> 4445 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> executing prepstmnt 27750143 SELECT t1.id, t1.p_type, t1.version,
> t1.address, t1.name, t0.dt_foundation, t0.taxpayers_id FROM legal_entity
> t0 INNER JOIN person t1 ON t0.person_id = t1.id WHERE t1.p_type = ?
> [params=?]
> 4446 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> [1 ms] spent
> 4526 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> executing prepstmnt 27803692 SELECT t0.version FROM person t0 WHERE t0.id
> = ? [params=?]
> 4526 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> [0 ms] spent
> 4529 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> executing prepstmnt 4123674 SELECT t0.version FROM person t0 WHERE t0.id =
> ? [params=?]
> 4529 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> [0 ms] spent
> 4531 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> executing prepstmnt 16703414 SELECT t0.version FROM person t0 WHERE t0.id
> = ? [params=?]
> 4531 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 14864562>
> [0 ms] spent
>
> Getting an Legal Person by ID.
>
> 4619 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 4961129>
> executing prepstmnt 30021000 SELECT t1.p_type, t1.version, t1.address,
> t1.name, t0.dt_foundation, t0.taxpayers_id FROM legal_entity t0 INNER JOIN
> person t1 ON t0.person_id = t1.id WHERE t1.p_type = ? AND t0.person_id = ?
> [params=?, ?]
> 4621 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 4961129>
> [1 ms] spent
> 4624 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27844531>
> executing prepstmnt 28039881 SELECT t0.version FROM person t0 WHERE t0.id
> = ? [params=?]
> 4625 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27844531>
> [1 ms] spent
> Object loaded:
> Person [address=ADDRESS1002, id=1002, name=LEGAL_ENTITY1002]
>
> Deleting Legal Entity by ID.
>
> 4705 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27402470>
> executing prepstmnt 18093512 SELECT t1.id, t1.p_type, t1.version,
> t1.address, t1.name, t0.dt_foundation, t0.taxpayers_id FROM legal_entity
> t0 INNER JOIN person t1 ON t0.person_id = t1.id WHERE (t1.id = ?) AND
> t1.p_type = ? [params=?, ?]
> 4706 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27402470>
> [1 ms] spent
> 4707 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27402470>
> executing prepstmnt 18739556 SELECT t0.version FROM person t0 WHERE t0.id
> = ? [params=?]
> 4707 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 27402470>
> [0 ms] spent
> 4725 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 16729566>
> executing prepstmnt 29247075 DELETE FROM legal_entity WHERE person_id = ?
> [params=?]
> 4726 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 16729566>
> [1 ms] spent
> 4726 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 16729566>
> executing prepstmnt 21243558 DELETE FROM person WHERE id = ? [params=?]
> 4728 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 16729566>
> [2 ms] spent
>
> Getting an Legal Entity by name.
>
> 4746 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 6080834>
> executing prepstmnt 5520561 SELECT t1.id, t1.p_type, t1.version,
> t1.address, t1.name, t0.dt_foundation, t0.taxpayers_id FROM legal_entity
> t0 INNER JOIN person t1 ON t0.person_id = t1.id WHERE (t1.name LIKE ?
> ESCAPE '\') AND t1.p_type = ? [params=?, ?]
> 4748 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 6080834>
> [1 ms] spent
> 4749 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 6080834>
> executing prepstmnt 27341624 SELECT t0.version FROM person t0 WHERE t0.id
> = ? [params=?]
> 4749 parkPU TRACE [main] openjpa.jdbc.SQL - <t 23612966, conn 6080834>
> [0 ms] spent
> Object loaded:
> [Person [address=ADDRESS1002, id=1002, name=LEGAL_ENTITY1002]]
> Tests run: 4, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 5.618 sec
> <<< FAILURE!
>
OpenJpa looks for the TABLE_NAME0 column which, of course, doesn't exists!
Any idea on what is happening here?
Thanks,
Gilberto
[1]http://code.google.com/p/construtor/source/browse/trunk/cip/README.txt
[2]http://code.google.com/p/construtor/source/browse/trunk/cip/park/src/main/resources/META-INF/orm.xml
--
View this message in context: http://openjpa.208410.n2.nabble.com/Attribute-pk-column-value-is-not-allowed-to-appear-in-element-generated-value-tp5158720p5752779.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: Attribute 'pk-column-value' is not allowed to appear in element
'generated-value'
Posted by gilbertoca <gi...@gmail.com>.
Hi, Jeremy
I've followed your tip putting the table-generator element in the entity
element (
http://code.google.com/p/construtor/source/browse/trunk/park-jpa/core/src/main/resources/META-INF/orm.xml
orm.xml ) .
But openjpa complains about it:
[code]
-------------------------------------------------------------------------------
Test set: park.model.LegalEntityTest
-------------------------------------------------------------------------------
Tests run: 2, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 4.697 sec
<<< FAILURE!
park.model.LegalEntityTest Time elapsed: 0 sec <<< ERROR!
<openjpa-2.0.0-r422266:935683 fatal user error>
org.apache.openjpa.persistence.ArgumentException: Could not locate the
sequence with name "person_table_generator ". It is possible that the
metadata file containing the sequence has not been parsed yet. Make sure to
use a persistent class whose metadata is in the same file somewhere in your
application before requesting the sequence.
at
org.apache.openjpa.meta.MetaDataRepository.getSequenceMetaDataInternal(MetaDataRepository.java:2105)
at
org.apache.openjpa.meta.MetaDataRepository.getSequenceMetaData(MetaDataRepository.java:2090)
at
org.apache.openjpa.meta.MetaDataRepository.getSequenceMetaData(MetaDataRepository.java:2117)
at
org.apache.openjpa.meta.FieldMetaData.getValueSequenceMetaData(FieldMetaData.java:1052)
at
org.apache.openjpa.jdbc.meta.MappingTool.addSequenceComponents(MappingTool.java:623)
at
org.apache.openjpa.jdbc.meta.MappingTool.addSequenceComponents(MappingTool.java:597)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:484)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:155)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:117)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:199)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:213)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:151)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:57)
at
park.model.LegalEntityTest.initEntityManager(LegalEntityTest.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at
org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at
org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
park.model.LegalEntityTest Time elapsed: 0.002 sec <<< ERROR!
java.lang.NullPointerException
at
park.model.LegalEntityTest.closeEntityManager(LegalEntityTest.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:37)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at
org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at
org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
[/code]
As you can see it complains about a sequence object which I don't use. I'm
using a table to store ids.
Any idea on what is happing here?
Thanks,
Gilberto
--
View this message in context: http://openjpa.208410.n2.nabble.com/Attribute-pk-column-value-is-not-allowed-to-appear-in-element-generated-value-tp5158720p5187822.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: Attribute 'pk-column-value' is not allowed to appear in element
'generated-value'
Posted by Jeremy Bauer <te...@gmail.com>.
Hi Gilberto,
The generated-value element does not provide an attribute named
"pk-column-value", thus, the schema validator validating your orm.xml file
is throwing an exception.
This line is the culprit:
<generated-value strategy="TABLE" generator="table_generator"
pk-column-value="person"/>
The schema definition for generated-value is as follows:
<xsd:complexType name="generated-value">
<xsd:annotation>
<xsd:documentation>
@Target({METHOD, FIELD}) @Retention(RUNTIME)
public @interface GeneratedValue {
GenerationType strategy() default AUTO;
String generator() default "";
}
</xsd:documentation>
</xsd:annotation>
<xsd:attribute name="strategy" type="orm:generation-type"/>
<xsd:attribute name="generator" type="xsd:string"/>
</xsd:complexType>
The pk-column-name can only be specified on the table generator itself. I
don't think it is possible to override the pk-column-name at an attribute
level - certainly not via generated-value. According to the JPA 2.0 spec:
<spec>
3. The sequence-generator, table-generator, named-query,
named-native-query and sql-result-set-mapping elements are global
to the persistence unit. It is undefined to have more than one
sequence-generator or table-generator of the same name in the same
or different mapping files in a persistence unit.
</spec>
Once a table generator is defined, there can/should only be one definition
for the persistence unit. You can define multiples with a different
pk-column-name values, but the table-generator name needs to be unique.
hth,
-Jeremy
On Wed, Jun 9, 2010 at 9:29 AM, gilbertoca <gi...@gmail.com> wrote:
>
> Hi, hope everyone is well!
>
> Can anyone help me understand the following exception (
>
> http://code.google.com/p/construtor/source/browse/trunk/park-jpa/core/src/main/resources/META-INF/orm.xml
> my orm.xml file ):
> [CODE]
> [INFO] [compiler:compile {execution: default-compile}]
> [INFO] Compiling 13 source files to
> /home/gilberto/dev/netbeans-config/park-jpa/core/target/classes
> [INFO] [antrun:run {execution: default}]
> [INFO] Executing tasks
> 216 parkPU INFO [main] openjpa.Tool - No targets were given. Running
> on
> all classes in your persistent classes list, or all metadata files in
> classpath directories if you have not listed your persistent classes. Use
> -help to display tool usage information.
> <openjpa-2.0.0-r422266:935683 nonfatal general error>
> org.apache.openjpa.util.GeneralException: org.xml.sax.SAXException:
>
> file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
> [Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
> cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to
> appear
> in element 'generated-value'.
> at
>
> org.apache.openjpa.persistence.PersistenceMetaDataFactory.parseXML(PersistenceMetaDataFactory.java:295)
> at
>
> org.apache.openjpa.persistence.PersistenceMetaDataFactory.load(PersistenceMetaDataFactory.java:228)
> at
>
> org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:554)
> at
>
> org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:374)
> at
>
> org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:358)
> at org.apache.openjpa.enhance.PCEnhancer.<init>(PCEnhancer.java:256)
> at org.apache.openjpa.enhance.PCEnhancer.run(PCEnhancer.java:4653)
> at
> org.apache.openjpa.ant.PCEnhancerTask.executeOn(PCEnhancerTask.java:89)
> at
> org.apache.openjpa.lib.ant.AbstractTask.execute(AbstractTask.java:171)
> at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at
> org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
> at org.apache.tools.ant.Task.perform(Task.java:348)
> at org.apache.tools.ant.Target.execute(Target.java:357)
> at
>
> org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:118)
> at
> org.apache.maven.plugin.antrun.AntRunMojo.execute(AntRunMojo.java:98)
> at
>
> org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:556)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:535)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348)
> at
>
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
> at
> org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at
> org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> at
> org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> Caused by: java.io.IOException: org.xml.sax.SAXException:
>
> file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
> [Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
> cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to
> appear
> in element 'generated-value'.
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.parseNewResource(XMLMetaDataParser.java:396)
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:334)
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:311)
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.parse(XMLMetaDataParser.java:284)
> at
>
> org.apache.openjpa.persistence.XMLPersistenceMetaDataParser.parse(XMLPersistenceMetaDataParser.java:364)
> at
>
> org.apache.openjpa.persistence.PersistenceMetaDataFactory.parseXML(PersistenceMetaDataFactory.java:293)
> ... 37 more
> Caused by: org.xml.sax.SAXException:
>
> file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
> [Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
> cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to
> appear
> in element 'generated-value'.
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.getException(XMLMetaDataParser.java:675)
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.error(XMLMetaDataParser.java:434)
> at
>
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:137)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:387)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:321)
> at
>
> com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:413)
> at
>
> com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3168)
> at
>
> com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.processAttributes(XMLSchemaValidator.java:2633)
> at
>
> com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2040)
> at
>
> com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:708)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:353)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2723)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:624)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:116)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:486)
> at
>
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:810)
> at
>
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:740)
> at
>
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:110)
> at
>
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1208)
> at
>
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:525)
> at javax.xml.parsers.SAXParser.parse(SAXParser.java:392)
> at
>
> org.apache.openjpa.lib.meta.XMLMetaDataParser.parseNewResource(XMLMetaDataParser.java:393)
> ... 42 more
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] An Ant BuildException has occured: <openjpa-2.0.0-r422266:935683
> nonfatal general error> org.apache.openjpa.util.GeneralException:
> org.xml.sax.SAXException:
>
> file:/home/gilberto/dev/netbeans-config/park-jpa/core/target/classes/META-INF/orm.xml
> [Location: Line: 30, C: 105]: org.xml.sax.SAXParseException:
> cvc-complex-type.3.2.2: Attribute 'pk-column-value' is not allowed to
> appear
> in element 'generated-value'.
>
> [INFO]
> ------------------------------------------------------------------------
> [INFO] For more information, run Maven with the -e switch
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Total time: 9 seconds
> [INFO] Finished at: Wed Jun 09 10:51:26 BRT 2010
> [INFO] Final Memory: 17M/67M
> [INFO]
> ------------------------------------------------------------------------
> gilberto@SUGEP-DMASI:~/dev/netbeans-config/park-jpa/core>
> [/CODE]
>
> I've defined a per persistent unit table-generator element with default
> pk-column-value="DEFAULT" and in the entity definition I override it like
> so: pk-column-value="parking".
>
> Regards,
>
> Gilberto
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/Attribute-pk-column-value-is-not-allowed-to-appear-in-element-generated-value-tp5158720p5158720.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>