environment:
OpenSuse 11.0
Jdk: 1.6.0_17
openjpa: OpenJPA 2.0.0-M3
Hi, I'm using just the orm.xml file[1] and the java code has no
annotation[2]. My persistence.xml file[3] has no special properties as well.
As you can see below it generates my tables correctly with exception the
legal_entity table. In the legal_entity table it generates one strange
column: PARKINGCOLLECTION OTHER. Maybe trying to identify one relationship
that I've not specified yet.
Other thing, in the test when I try
[quote]
NaturalPerson nP = em.find(NaturalPerson.class, 1000);
[/quote]
it doesn't use the discriminator-column that in my case is
CHAR(2)//NATURALPERSON(NP) OR LEGALENTITY(LE):
[quote]
[INFO] Surefire report directory:
/home/gilberto/dev/netbeans-config/park-jpa/core/target/surefire-reports
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running park.model.NaturalPersonTest
714 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.
787 parkPU INFO [main] openjpa.Runtime - Starting OpenJPA 2.0.0-M3
2062 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 14418997>
executing prepstmnt 19306178 SELECT SEQUENCE_SCHEMA, SEQUENCE_NAME FROM
INFORMATION_SCHEMA.SEQUENCES
2063 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 14418997> [0
ms] spent
2596 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 2342353>
executing stmnt 33039485 DROP TABLE legal_entity
2603 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 2342353> [7
ms] spent
2712 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 12171472>
executing stmnt 20194874 DROP TABLE natural_person
2713 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 12171472> [1
ms] spent
2786 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 13320911>
executing stmnt 28713819 DROP TABLE person
2787 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 13320911> [1
ms] spent
2860 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 23360120>
executing prepstmnt 3658896 SELECT SEQUENCE_SCHEMA, SEQUENCE_NAME FROM
INFORMATION_SCHEMA.SEQUENCES
2861 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 23360120> [1
ms] spent
3237 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 6848169>
executing stmnt 26108059 CREATE TABLE legal_entity (id_person INTEGER NOT
NULL, dt_foundation DATE, taxpayers_id VARCHAR(20), PARKINGCOLLECTION OTHER,
PRIMARY KEY (id_person))
3240 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 6848169> [1
ms] spent
3288 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 25935701>
executing stmnt 2870450 CREATE TABLE natural_person (id_person INTEGER NOT
NULL, dt_birth DATE, legal_document VARCHAR(20), PRIMARY KEY (id_person))
3290 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 25935701> [1
ms] spent
3390 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 32112901>
executing stmnt 29948747 CREATE TABLE person (id_person INTEGER NOT NULL
IDENTITY, address VARCHAR(100), name VARCHAR(100), p_type CHAR(2), version
INTEGER)
3392 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 32112901> [2
ms] spent
3462 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 7789321>
executing stmnt 9876930 CREATE INDEX I_PERSON_DTYPE ON person (p_type)
3463 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 7789321> [1
ms] spent
2010-01-25 12:12:18,190 [main] WARN
org.dbunit.dataset.AbstractTableMetaData - Potential problem found: The
configured data type factory 'class
org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems
with the current database 'H2' (e.g. some datatypes may not be supported
properly). In rare cases you might see this message because the list of
supported database products is incomplete (list=[derby]). If so please
request a java-class update via the forums.If you are using your own
IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override
getValidDbProducts() to specify the supported database products.
2010-01-25 12:12:18,207 [main] WARN
org.dbunit.dataset.AbstractTableMetaData - Potential problem found: The
configured data type factory 'class
org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems
with the current database 'H2' (e.g. some datatypes may not be supported
properly). In rare cases you might see this message because the list of
supported database products is incomplete (list=[derby]). If so please
request a java-class update via the forums.If you are using your own
IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override
getValidDbProducts() to specify the supported database products.
2010-01-25 12:12:18,218 [main] DEBUG park.model.NaturalPersonTest -
Getting an Natural Person by ID.
4122 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 19492125>
executing prepstmnt 22199751 SELECT t1.p_type, t1.version, t1.address,
t1.name, t0.dt_birth, t0.legal_document FROM natural_person t0 INNER JOIN
person t1 ON t0.id_person = t1.id_person WHERE t1.p_type = ? AND
t0.id_person = ? [params=(int) 78, (int) 1000]
4123 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 19492125> [0
ms] spent
4134 parkPU WARN [main] openjpa.Runtime - Finder for
"park.model.NaturalPerson" is not cachable.
2010-01-25 12:12:18,461 [main] DEBUG park.model.NaturalPersonTest - Object
loaded:
null
4402 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 272782>
executing prepstmnt 19679080 SELECT t1.id_person, t1.p_type, t1.version,
t1.address, t1.name, t0.dt_birth, t0.legal_document FROM natural_person t0
INNER JOIN person t1 ON t0.id_person = t1.id_person WHERE t1.p_type = ?
[params=(int) 78]
4404 parkPU TRACE [main] openjpa.jdbc.SQL - <t 7577407, conn 272782> [2
ms] spent
Tests run: 2, Failures: 1, Errors: 1, Skipped: 0, Time elapsed: 4.876 sec
<<< FAILURE!
Results :
Failed tests:
findAll(park.model.NaturalPersonTest)
Tests in error:
GetNaturalPersonById(park.model.NaturalPersonTest)
Tests run: 2, Failures: 1, Errors: 1, Skipped: 0
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[/quote]
Any tip here?
Gilberto
[1] http://n2.nabble.com/file/n4455011/orm.xml orm.xml
[2] http://n2.nabble.com/file/n4455011/Person.java Person.java
http://n2.nabble.com/file/n4455011/NaturalPerson.java
NaturalPerson.java
http://n2.nabble.com/file/n4455011/LegalEntity.java LegalEntity.java
[3] http://n2.nabble.com/file/n4455011/persistence.xml persistence.xml
--
View this message in context:
http://n2.nabble.com/orm-xml-discriminator-column-strange-column-tp4455011p4455011.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
