Problem with schema handling when running TCK with oracle
----------------------------------------------------------
Key: JDO-570
URL: https://issues.apache.org/jira/browse/JDO-570
Project: JDO
Issue Type: Bug
Components: tck2, tck2-legacy
Affects Versions: JDO 2 maintenance release 1
Reporter: Michael Bouschen
Priority: Minor
Running the CompletenessTest against an Oracle database results in an
exception:
[java] javax.jdo.JDODataStoreException: [JPOX-052208] Insert of object
"[EMAIL PROTECTED]
" 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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
