[JDO-570] Problem with schema handling when running TCK with oracle

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: JDO 2 maintenance release 1 (2.1)
• Component/s: tck, tck2-legacy
• Assignee: Unassigned
• Reporter: Michael Bouschen
• Created: 17/Jan/08 22:07
• Updated: 17/Jan/08 22:07

Description

Running the CompletenessTest against an Oracle database results in an exception:
[java] javax.jdo.JDODataStoreException: [JPOX-052208] Insert of object "org.apache.jdo.tck.pc.company.Company@c16b18
" using statement "INSERT INTO applicationidentity0.COMPANIES (ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,"NAME",FOUNDED
DATE,ID,DISCRIMINATOR) VALUES (?,?,?,?,?,?,?,?,?,?)" failed : ORA-00942: Tabelle oder View nicht vorhanden
[java]
[java] at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289)
[java] at org.jpox.jdo.AbstractPersistenceManager.jdoMakePersistent(AbstractPersistenceManager.java:646)
[java] at org.jpox.jdo.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:695)
[java] at org.apache.jdo.tck.mapping.CompletenessTest.localSetUp(CompletenessTest.java:79)
The table applicationidentity0.COMPANIES cannot be found.

The table qualifier applicationidentity0 comes from the option javax.jdo.mapping.Schema. The maven goal doRuntck.jdori adds this option to the pmf properties. Oracle is able to find the table if the option is omitted from the pmf properties.

I also tried using applicationidentity0 as a table qualifier when creating the schema. But Oracle seems to interpret the qualifier as the user name. Loading the schema with sqlplus results in an exception saying there is no such user 'APPLICATIONIDDENTITY0':
prefix
CREATE TABLE applicationidentity0.companies (
*
FEHLER in Zeile 1:
ORA-01918: Benutzer 'APPLICATIONIDENTITY0' ist nicht vorhanden