/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* Mike Norman - May 2008, created DBWS test package
******************************************************************************/
package dbws.testing.keymappings;
//javase imports
import java.io.ByteArrayInputStream;
import java.io.Reader;
import java.io.StringReader;
import java.util.ArrayList;
import java.util.Vector;
import org.w3c.dom.Document;
import org.xml.sax.InputSource;
//JUnit4 imports
import org.junit.AfterClass;
import org.junit.BeforeClass;
import org.junit.Test;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertTrue;
import static org.junit.Assert.fail;
//EclipseLink imports
import org.eclipse.persistence.dbws.DBWSModel;
import org.eclipse.persistence.dbws.DBWSModelProject;
import org.eclipse.persistence.dynamic.DynamicEntity;
import org.eclipse.persistence.internal.databaseaccess.Platform;
import org.eclipse.persistence.internal.helper.ConversionManager;
import org.eclipse.persistence.internal.sessions.factories.EclipseLinkObjectPersistenceRuntimeXMLProject;
import org.eclipse.persistence.internal.xr.XRDynamicClassLoader;
import org.eclipse.persistence.internal.xr.Invocation;
import org.eclipse.persistence.internal.xr.Operation;
import org.eclipse.persistence.internal.xr.ProjectHelper;
import org.eclipse.persistence.internal.xr.XRDynamicEntity_CollectionWrapper;
import org.eclipse.persistence.internal.xr.XRServiceAdapter;
import org.eclipse.persistence.internal.xr.XRServiceFactory;
import org.eclipse.persistence.internal.xr.XRServiceModel;
import org.eclipse.persistence.oxm.XMLContext;
import org.eclipse.persistence.oxm.XMLMarshaller;
import org.eclipse.persistence.oxm.XMLUnmarshaller;
import org.eclipse.persistence.platform.database.MySQLPlatform;
import org.eclipse.persistence.platform.xml.XMLComparer;
import org.eclipse.persistence.platform.xml.XMLParser;
import org.eclipse.persistence.platform.xml.XMLPlatform;
import org.eclipse.persistence.platform.xml.XMLPlatformFactory;
import org.eclipse.persistence.sessions.DatabaseLogin;
import org.eclipse.persistence.sessions.DatasourceLogin;
import org.eclipse.persistence.sessions.Project;
import dbws.testing.AllTests;
// testing imports
import static dbws.testing.DBWSTestHelper.CONSTANT_PROJECT_BUILD_VERSION;
import static dbws.testing.DBWSTestHelper.DATABASE_DRIVER_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_PASSWORD_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_URL_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_USERNAME_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_DDL_CREATE_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_DDL_DROP_KEY;
import static dbws.testing.DBWSTestHelper.DATABASE_DDL_DEBUG_KEY;
import static dbws.testing.DBWSTestHelper.DEFAULT_DATABASE_DDL_CREATE;
import static dbws.testing.DBWSTestHelper.DEFAULT_DATABASE_DDL_DROP;
import static dbws.testing.DBWSTestHelper.DEFAULT_DATABASE_DDL_DEBUG;
public class KeyMappingsTestSuite {
static final String CREATE_DDL =
"CREATE TABLE IF NOT EXISTS XR_KEYMAP_ADDRESS (" +
" ADDRESS_ID NUMERIC(15) NOT NULL," +
" STREET VARCHAR(80)," +
" CITY VARCHAR(80)," +
" PROVINCE VARCHAR(80)," +
" PRIMARY KEY (ADDRESS_ID)" +
")|" +
"INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (1, '20 Pinetrail Cres.', 'Nepean', 'Ont')|" +
"INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (2, 'Davis Side Rd.', 'Carleton Place', 'Ont')|" +
"CREATE TABLE IF NOT EXISTS XR_KEYMAP_EMPLOYEE (" +
" EMP_ID NUMERIC(15) NOT NULL," +
" F_NAME VARCHAR(40)," +
" L_NAME VARCHAR(40)," +
" ADDR_ID NUMERIC(15)," +
" PRIMARY KEY (EMP_ID)," +
" CONSTRAINT XR_KEYMAP_EMPLOYEE_ADDRESS FOREIGN KEY (ADDR_ID) REFERENCES XR_KEYMAP_ADDRESS (ADDRESS_ID)" +
")|" +
"INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (1, 'Mike', 'Norman', 1)|" +
"INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (2, 'Rick', 'Barkhouse', 2)|" +
"CREATE TABLE IF NOT EXISTS XR_KEYMAP_PHONE (" +
" PHONE_ID NUMERIC(15) NOT NULL," +
" OWNER_ID NUMERIC(15) NOT NULL," +
" AREA_CODE VARCHAR(3)," +
" P_NUMBER VARCHAR(7)," +
" TYPE VARCHAR(15) NOT NULL," +
" PRIMARY KEY (PHONE_ID)," +
" CONSTRAINT XR_KEYMAP_PHONE_EMPLOYEE FOREIGN KEY (OWNER_ID) REFERENCES XR_KEYMAP_EMPLOYEE (EMP_ID)" +
")|" +
"INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (1, 1, '613', '2281808', 'Home')|" +
"INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (2, 1, '613', '2884638', 'Work')|" +
"INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (3, 2, '613', '2832684', 'Home')|" +
"INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (4, 2, '613', '2884613', 'Work')|" ;
static final String DROP_DDL =
"DROP TABLE XR_KEYMAP_PHONE|" +
"DROP TABLE XR_KEYMAP_EMPLOYEE|" +
"DROP TABLE XR_KEYMAP_ADDRESS|" ;
static final String KEYMAPPINGS_SCHEMA =
"<?xml version='1.0' encoding='UTF-8'?>" +
"<xsd:schema targetNamespace=\"urn:keymappings\" xmlns=\"urn:keymappings\" elementFormDefault=\"qualified\"\n" +
"xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n" +
">\n" +
"<xsd:complexType name=\"phone\">\n" +
"<xsd:sequence>\n" +
"<xsd:element name=\"area-code\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"phone-number\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"type\" type=\"xsd:string\" />\n" +
"</xsd:sequence>\n" +
"<xsd:attribute name=\"phone-id\" type=\"xsd:int\" use=\"required\" />\n" +
"<xsd:attribute name=\"owner-ref-id\" type=\"xsd:int\" use=\"required\" />\n" +
"</xsd:complexType>\n" +
"<xsd:complexType name=\"address\">\n" +
"<xsd:sequence>\n" +
"<xsd:element name=\"street\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"city\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"province\" type=\"xsd:string\" />\n" +
"</xsd:sequence>\n" +
"<xsd:attribute name=\"address-id\" type=\"xsd:int\" use=\"required\" />\n" +
"</xsd:complexType>\n" +
"<xsd:complexType name=\"employee\">\n" +
"<xsd:sequence>\n" +
"<xsd:element name=\"first-name\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"last-name\" type=\"xsd:string\" />\n" +
"<xsd:element name=\"address\" type=\"address\" minOccurs=\"0\" />\n" +
"<xsd:element name=\"phones\">\n" +
"<xsd:complexType>\n" +
"<xsd:sequence>\n" +
"<xsd:element maxOccurs=\"unbounded\" name=\"phone-ref\">\n" +
"<xsd:complexType>\n" +
"<xsd:attribute name=\"phone-id\" type=\"xsd:int\" use=\"required\" />\n" +
"</xsd:complexType>\n" +
"</xsd:element>\n" +
"</xsd:sequence>\n" +
"</xsd:complexType>\n" +
"</xsd:element>\n" +
"</xsd:sequence>\n" +
"<xsd:attribute name=\"employee-id\" type=\"xsd:int\" use=\"required\" />\n" +
"<xsd:attribute name=\"address-ref-id\" type=\"xsd:int\" use=\"required\" />\n" +
"</xsd:complexType>\n" +
"</xsd:schema>";
static final String KEYMAPPINGS_DBWS =
"<?xml version='1.0' encoding='UTF-8'?>\n" +
"<dbws\n" +
"xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n" +
"xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n" +
"xmlns:ns1=\"urn:keymappings\"\n" +
">\n" +
"<name>keymappings</name>\n" +
"<query>\n" +
"<name>getAllEmployees</name>\n" +
"<result isCollection=\"true\">\n" +
"<type>ns1:employee</type>\n" +
"</result>\n" +
"<sql><![CDATA[select * from XR_KEYMAP_EMPLOYEE]]></sql>\n" +
"</query>\n" +
"</dbws>\n";
static final String KEYMAPPINGS_OR_PROJECT =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
"<object-persistence version=\"" + CONSTANT_PROJECT_BUILD_VERSION + "\"\n" +
" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n" +
" xmlns=\"http://www.eclipse.org/eclipselink/xsds/persistence\"\n" +
" >\n" +
"<name>keymappings</name>\n" +
"<class-mapping-descriptors>\n" +
"<class-mapping-descriptor xsi:type=\"relational-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Address</class>\n" +
"<alias>address</alias>\n" +
"<primary-key>\n" +
"<field table=\"XR_KEYMAP_ADDRESS\" name=\"ADDRESS_ID\" xsi:type=\"column\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>addressId</attribute-name>\n" +
"<field table=\"XR_KEYMAP_ADDRESS\" name=\"ADDRESS_ID\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>street</attribute-name>\n" +
"<field table=\"XR_KEYMAP_ADDRESS\" name=\"STREET\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>city</attribute-name>\n" +
"<field table=\"XR_KEYMAP_ADDRESS\" name=\"CITY\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>province</attribute-name>\n" +
"<field table=\"XR_KEYMAP_ADDRESS\" name=\"PROVINCE\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>independent</descriptor-type>\n" +
"<instantiation/>\n" +
"<copying xsi:type=\"instantiation-copy-policy\"/>\n" +
"<change-policy xsi:type=\"deferred-detection-change-policy\"/>\n" +
"<tables>\n" +
"<table name=\"XR_KEYMAP_ADDRESS\"/>\n" +
"</tables>\n" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"relational-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Employee</class>\n" +
"<alias>employee</alias>\n" +
"<primary-key>\n" +
"<field table=\"XR_KEYMAP_EMPLOYEE\" name=\"EMP_ID\" xsi:type=\"column\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\">\n" +
"</querying>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>employeeId</attribute-name>\n" +
"<field table=\"XR_KEYMAP_EMPLOYEE\" name=\"EMP_ID\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>firstName</attribute-name>\n" +
"<field table=\"XR_KEYMAP_EMPLOYEE\" name=\"F_NAME\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>lastName</attribute-name>\n" +
"<field table=\"XR_KEYMAP_EMPLOYEE\" name=\"L_NAME\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"one-to-one-mapping\">\n" +
"<attribute-name>address</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Address</reference-class>\n" +
"<foreign-key>\n" +
"<field-reference>\n" +
"<source-field table=\"XR_KEYMAP_EMPLOYEE\" name=\"ADDR_ID\" xsi:type=\"column\"/>\n" +
"<target-field table=\"XR_KEYMAP_ADDRESS\" name=\"ADDRESS_ID\" xsi:type=\"column\"/>\n" +
"</field-reference>\n" +
"</foreign-key>\n" +
"<foreign-key-fields>\n" +
"<field table=\"XR_KEYMAP_EMPLOYEE\" name=\"ADDR_ID\" xsi:type=\"column\"/>\n" +
"</foreign-key-fields>\n" +
"<selection-query xsi:type=\"read-object-query\"/>\n" +
"<join-fetch>inner-join</join-fetch>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"one-to-many-mapping\">\n" +
"<attribute-name>phones</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Phone</reference-class>\n" +
"<target-foreign-key>\n" +
"<field-reference>\n" +
"<source-field table=\"XR_KEYMAP_PHONE\" name=\"OWNER_ID\" xsi:type=\"column\"/>\n" +
"<target-field table=\"XR_KEYMAP_EMPLOYEE\" name=\"EMP_ID\" xsi:type=\"column\"/>\n" +
"</field-reference>\n" +
"</target-foreign-key>\n" +
"<container xsi:type=\"list-container-policy\">\n" +
"<collection-type>org.eclipse.persistence.indirection.IndirectList</collection-type>\n" +
"</container>\n" +
"<indirection xsi:type=\"transparent-collection-indirection-policy\"/>\n" +
"<selection-query xsi:type=\"read-all-query\">\n" +
"<container xsi:type=\"list-container-policy\">\n" +
"<collection-type>org.eclipse.persistence.indirection.IndirectList</collection-type>\n" +
"</container>\n" +
"</selection-query>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>independent</descriptor-type>\n" +
"<instantiation/>\n" +
"<copying xsi:type=\"instantiation-copy-policy\"/>\n" +
"<change-policy xsi:type=\"deferred-detection-change-policy\"/>\n" +
"<tables>\n" +
"<table name=\"XR_KEYMAP_EMPLOYEE\"/>\n" +
"</tables>\n" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"relational-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Phone</class>\n" +
"<alias>phone</alias>\n" +
"<primary-key>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"PHONE_ID\" xsi:type=\"column\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>phoneId</attribute-name>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"PHONE_ID\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>areaCode</attribute-name>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"AREA_CODE\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>phonenumber</attribute-name>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"P_NUMBER\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"direct-mapping\">\n" +
"<attribute-name>type</attribute-name>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"TYPE\" xsi:type=\"column\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"one-to-one-mapping\">\n" +
"<attribute-name>owner</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Employee</reference-class>\n" +
"<private-owned>false</private-owned>\n" +
"<foreign-key>\n" +
"<field-reference>\n" +
"<source-field table=\"XR_KEYMAP_PHONE\" name=\"OWNER_ID\" xsi:type=\"column\"/>\n" +
"<target-field table=\"XR_KEYMAP_EMPLOYEE\" name=\"EMP_ID\" xsi:type=\"column\"/>\n" +
"</field-reference>\n" +
"</foreign-key>\n" +
"<foreign-key-fields>\n" +
"<field table=\"XR_KEYMAP_PHONE\" name=\"OWNER_ID\" xsi:type=\"column\"/>\n" +
"</foreign-key-fields>\n" +
"<batch-reading>true</batch-reading>\n" +
"<selection-query xsi:type=\"read-object-query\"/>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>independent</descriptor-type>\n" +
"<instantiation/>\n" +
"<copying xsi:type=\"instantiation-copy-policy\"/>\n" +
"<change-policy xsi:type=\"deferred-detection-change-policy\"/>\n" +
"<tables>\n" +
"<table name=\"XR_KEYMAP_PHONE\"/>\n" +
"</tables>\n" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"class-mapping-descriptor\">" +
"<class>org.eclipse.persistence.internal.xr.XRDynamicEntity_CollectionWrapper</class>" +
"<alias>XRDynamicEntity_CollectionWrapper</alias>" +
"<events xsi:type=\"event-policy\"/>" +
"<querying xsi:type=\"query-policy\"/>" +
"<attribute-mappings>" +
"<attribute-mapping xsi:type=\"aggregate-collection-mapping\">" +
"<attribute-name>items</attribute-name>" +
"<private-owned>true</private-owned>" +
"<cascade-persist>true</cascade-persist>" +
"<cascade-merge>true</cascade-merge>" +
"<cascade-refresh>true</cascade-refresh>" +
"<cascade-remove>true</cascade-remove>" +
"<container xsi:type=\"list-container-policy\">" +
"<collection-type>java.util.ArrayList</collection-type>" +
"</container>" +
"<selection-query xsi:type=\"read-all-query\">" +
"<container xsi:type=\"list-container-policy\">" +
"<collection-type>java.util.ArrayList</collection-type>" +
"</container>" +
"</selection-query>" +
"</attribute-mapping>" +
"</attribute-mappings>" +
"<descriptor-type>aggregate</descriptor-type>" +
"<caching>" +
"<cache-size>-1</cache-size>" +
"</caching>" +
"<remote-caching>" +
"<cache-size>-1</cache-size>" +
"</remote-caching>" +
"<instantiation/>" +
"<copying xsi:type=\"instantiation-copy-policy\"/>" +
"</class-mapping-descriptor>" +
"</class-mapping-descriptors>\n" +
"<login xsi:type=\"database-login\">\n" +
"<bind-all-parameters>true</bind-all-parameters>\n" +
"</login>\n" +
"</object-persistence>";
static final String KEYMAPPINGS_OX_PROJECT =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
"<object-persistence version=\"" + CONSTANT_PROJECT_BUILD_VERSION + "\"\n" +
"xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n" +
"xmlns=\"http://www.eclipse.org/eclipselink/xsds/persistence\"\n" +
">\n" +
"<name>keymappings</name>\n" +
"<class-mapping-descriptors>\n" +
"<class-mapping-descriptor xsi:type=\"xml-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Phone</class>\n" +
"<alias>phone</alias>\n" +
"<primary-key>\n" +
"<field name=\"@phone-id\" xsi:type=\"node\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>phoneId</attribute-name>\n" +
"<field name=\"@phone-id\" xsi:type=\"node\">\n" +
"</field>\n" +
"<converter xsi:type=\"type-conversion-converter\">\n" +
"<object-class>java.lang.Integer</object-class>\n" +
"<data-class>java.lang.String</data-class>\n" +
"</converter>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>areaCode</attribute-name>\n" +
"<field name=\"area-code/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>phonenumber</attribute-name>\n" +
"<field name=\"phone-number/text()\" xsi:type=\"node\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>type</attribute-name>\n" +
"<field name=\"type/text()\" xsi:type=\"node\"/>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-object-reference-mapping\">\n" +
"<attribute-name>owner</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Employee</reference-class>\n" +
"<source-to-target-key-field-association>\n" +
"<field-reference>\n" +
"<source-field name=\"@owner-ref-id\" xsi:type=\"node\"/>\n" +
"<target-field name=\"@employee-id\" xsi:type=\"node\"/>\n" +
"</field-reference>\n" +
"</source-to-target-key-field-association>\n" +
"<source-to-target-key-fields>\n" +
"<field name=\"@owner-ref-id\" xsi:type=\"node\"/>\n" +
"</source-to-target-key-fields>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>aggregate</descriptor-type>\n" +
"<default-root-element>phone</default-root-element>\n" +
"<namespace-resolver>" +
" <default-namespace-uri>urn:keymappings</default-namespace-uri>" +
"</namespace-resolver>" +
"<schema xsi:type=\"schema-url-reference\">" +
" <resource></resource>" +
" <schema-context>/phone</schema-context>" +
" <node-type>complex-type</node-type>" +
"</schema>" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"xml-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Address</class>\n" +
"<alias>address</alias>\n" +
"<primary-key>\n" +
"<field name=\"@address-id\" xsi:type=\"node\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>addressId</attribute-name>\n" +
"<field name=\"@address-id\" xsi:type=\"node\">\n" +
"</field>\n" +
"<converter xsi:type=\"type-conversion-converter\">\n" +
"<object-class>java.lang.Integer</object-class>\n" +
"<data-class>java.lang.String</data-class>\n" +
"</converter>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>street</attribute-name>\n" +
"<field name=\"street/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>city</attribute-name>\n" +
"<field name=\"city/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>province</attribute-name>\n" +
"<field name=\"province/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>aggregate</descriptor-type>\n" +
"<default-root-element>address</default-root-element>\n" +
"<namespace-resolver>" +
" <default-namespace-uri>urn:keymappings</default-namespace-uri>" +
"</namespace-resolver>" +
"<schema xsi:type=\"schema-url-reference\">" +
" <resource></resource>" +
" <schema-context>/address</schema-context>" +
" <node-type>complex-type</node-type>" +
"</schema>" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"xml-class-mapping-descriptor\">\n" +
"<class>dbws.testing.keymappings.Employee</class>\n" +
"<alias>employee</alias>\n" +
"<primary-key>\n" +
"<field name=\"@employee-id\" xsi:type=\"node\"/>\n" +
"</primary-key>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>employeeId</attribute-name>\n" +
"<field name=\"@employee-id\" xsi:type=\"node\">\n" +
"</field>\n" +
"<converter xsi:type=\"type-conversion-converter\">\n" +
"<object-class>java.lang.Integer</object-class>\n" +
"<data-class>java.lang.String</data-class>\n" +
"</converter>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>firstName</attribute-name>\n" +
"<field name=\"first-name/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-direct-mapping\">\n" +
"<attribute-name>lastName</attribute-name>\n" +
"<field name=\"last-name/text()\" xsi:type=\"node\">\n" +
"<schema-type>{http://www.w3.org/2001/XMLSchema}string</schema-type>\n" +
"</field>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-object-reference-mapping\">\n" +
"<attribute-name>address</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Address</reference-class>\n" +
"<source-to-target-key-field-association>\n" +
"<field-reference>\n" +
"<source-field name=\"@address-ref-id\" xsi:type=\"node\"/>\n" +
"<target-field name=\"@address-id\" xsi:type=\"node\"/>\n" +
"</field-reference>\n" +
"</source-to-target-key-field-association>\n" +
"<source-to-target-key-fields>\n" +
"<field name=\"@address-ref-id\" xsi:type=\"node\"/>\n" +
"</source-to-target-key-fields>\n" +
"</attribute-mapping>\n" +
"<attribute-mapping xsi:type=\"xml-collection-reference-mapping\">\n" +
"<attribute-name>phones</attribute-name>\n" +
"<reference-class>dbws.testing.keymappings.Phone</reference-class>\n" +
"<source-to-target-key-field-association>\n" +
"<field-reference>\n" +
"<source-field name=\"phones/phone-ref/@phone-id\" xsi:type=\"node\"/>\n" +
"<target-field name=\"@phone-id\" xsi:type=\"node\"/>\n" +
"</field-reference>\n" +
"</source-to-target-key-field-association>\n" +
"<source-to-target-key-fields>\n" +
"<field name=\"phones/phone-ref/@phone-id\" xsi:type=\"node\"/>\n" +
"</source-to-target-key-fields>\n" +
"<containerpolicy xsi:type=\"list-container-policy\">\n" +
"<collection-type>java.util.ArrayList</collection-type>\n" +
"</containerpolicy>\n" +
"<uses-single-node>false</uses-single-node>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>aggregate</descriptor-type>\n" +
"<default-root-element>employee</default-root-element>\n" +
"<namespace-resolver>" +
" <default-namespace-uri>urn:keymappings</default-namespace-uri>" +
"</namespace-resolver>" +
"<schema xsi:type=\"schema-url-reference\">" +
" <resource></resource>" +
" <schema-context>/employee</schema-context>" +
" <node-type>complex-type</node-type>" +
"</schema>" +
"</class-mapping-descriptor>\n" +
"<class-mapping-descriptor xsi:type=\"xml-class-mapping-descriptor\">\n" +
"<class>org.eclipse.persistence.internal.xr.XRDynamicEntity_CollectionWrapper</class>\n" +
"<alias>XRDynamicEntity_CollectionWrapper</alias>\n" +
"<events xsi:type=\"event-policy\"/>\n" +
"<querying xsi:type=\"query-policy\"/>\n" +
"<attribute-mappings>\n" +
"<attribute-mapping xsi:type=\"xml-any-collection-mapping\">\n" +
"<attribute-name>items</attribute-name>\n" +
"<container xsi:type=\"list-container-policy\">\n" +
"<collection-type>java.util.ArrayList</collection-type>\n" +
"</container>\n" +
"<keep-as-element-policy>KEEP_NONE_AS_ELEMENT</keep-as-element-policy>\n" +
"</attribute-mapping>\n" +
"</attribute-mappings>\n" +
"<descriptor-type>aggregate</descriptor-type>\n" +
"<instantiation/>\n" +
"<copying xsi:type=\"instantiation-copy-policy\"/>\n" +
"<change-policy xsi:type=\"deferred-detection-change-policy\"/>\n" +
"<default-root-element>employee-address-phone-system</default-root-element>\n" +
"<namespace-resolver>" +
"<namespaces>\n" +
"<namespace>\n" +
"<prefix>xsd</prefix>\n" +
"<namespace-uri>http://www.w3.org/2001/XMLSchema</namespace-uri>\n" +
"</namespace>\n" +
"<namespace>\n" +
"<prefix>xsi</prefix>\n" +
"<namespace-uri>http://www.w3.org/2001/XMLSchema-instance</namespace-uri>\n" +
"</namespace>\n" +
"</namespaces>\n" +
"<default-namespace-uri>urn:keymappings</default-namespace-uri>" +
"</namespace-resolver>" +
"</class-mapping-descriptor>\n" +
"</class-mapping-descriptors>\n" +
"<login xsi:type=\"xml-login\">\n" +
"<platform-class>org.eclipse.persistence.oxm.platform.DOMPlatform</platform-class>\n" +
"</login>\n" +
"</object-persistence>";
// test fixtures
public static XMLComparer comparer = new XMLComparer();
public static XMLPlatform xmlPlatform = XMLPlatformFactory.getInstance().getXMLPlatform();
public static XMLParser xmlParser = xmlPlatform.newXMLParser();
public static XRServiceAdapter xrService = null;
static boolean ddlCreate = false;
static boolean ddlDrop = false;
static boolean ddlDebug = false;
@BeforeClass
public static void setUp() {
final String ddlCreateProp = System.getProperty(DATABASE_DDL_CREATE_KEY, DEFAULT_DATABASE_DDL_CREATE);
if ("true".equalsIgnoreCase(ddlCreateProp)) {
ddlCreate = true;
}
final String ddlDropProp = System.getProperty(DATABASE_DDL_DROP_KEY, DEFAULT_DATABASE_DDL_DROP);
if ("true".equalsIgnoreCase(ddlDropProp)) {
ddlDrop = true;
}
final String ddlDebugProp = System.getProperty(DATABASE_DDL_DEBUG_KEY, DEFAULT_DATABASE_DDL_DEBUG);
if ("true".equalsIgnoreCase(ddlDebugProp)) {
ddlDebug = true;
}
final String username = System.getProperty(DATABASE_USERNAME_KEY);
if (username == null) {
fail("error retrieving database username");
}
final String password = System.getProperty(DATABASE_PASSWORD_KEY);
if (password == null) {
fail("error retrieving database password");
}
final String url = System.getProperty(DATABASE_URL_KEY);
if (url == null) {
fail("error retrieving database url");
}
final String driver = System.getProperty(DATABASE_DRIVER_KEY);
if (driver == null) {
fail("error retrieving database driver");
}
XRServiceFactory factory = new XRServiceFactory() {
@Override
public XRServiceAdapter buildService(XRServiceModel xrServiceModel) {
parentClassLoader = this.getClass().getClassLoader();
xrSchemaStream = new ByteArrayInputStream(KEYMAPPINGS_SCHEMA.getBytes());
return super.buildService(xrServiceModel);
}
@Override
public void buildSessions() {
XRDynamicClassLoader xrdecl = new XRDynamicClassLoader(parentClassLoader);
XMLContext context = new XMLContext(
new EclipseLinkObjectPersistenceRuntimeXMLProject(),xrdecl);
XMLUnmarshaller unmarshaller = context.createUnmarshaller();
Project orProject = (Project)unmarshaller.unmarshal(
new StringReader(KEYMAPPINGS_OR_PROJECT));
DatasourceLogin login = new DatabaseLogin();
login.setUserName(username);
login.setPassword(password);
((DatabaseLogin)login).setConnectionString(url);
((DatabaseLogin)login).setDriverClassName(driver);
Platform platform = new MySQLPlatform();
ConversionManager conversionManager = platform.getConversionManager();
if (conversionManager != null) {
conversionManager.setLoader(xrdecl);
}
login.setDatasourcePlatform(platform);
((DatabaseLogin)login).bindAllParameters();
orProject.setDatasourceLogin(login);
Project oxProject = (Project)unmarshaller.unmarshal(
new StringReader(KEYMAPPINGS_OX_PROJECT));
login = (DatasourceLogin)oxProject.getDatasourceLogin();
if (login != null) {
platform = login.getDatasourcePlatform();
if (platform != null) {
conversionManager = platform.getConversionManager();
if (conversionManager != null) {
conversionManager.setLoader(xrdecl);
}
}
}
ProjectHelper.fixOROXAccessors(orProject, oxProject);
xrService.setORSession(orProject.createDatabaseSession());
xrService.getORSession().dontLogMessages();
xrService.setXMLContext(new XMLContext(oxProject));
xrService.setOXSession(xrService.getXMLContext().getSession(0));
}
};
XMLContext context = new XMLContext(new DBWSModelProject());
XMLUnmarshaller unmarshaller = context.createUnmarshaller();
DBWSModel model = (DBWSModel)unmarshaller.unmarshal(new StringReader(KEYMAPPINGS_DBWS));
xrService = factory.buildService(model);
if (ddlCreate) {
try {
AllTests.runDdl(CREATE_DDL, ddlDebug);
} catch (Exception e) {
// e.printStackTrace();
}
}
}
@AfterClass
public static void tearDown() {
if (ddlDrop) {
try {
AllTests.runDdl(DROP_DDL, ddlDebug);
} catch (Exception e) {
// e.printStackTrace();
}
}
}
@SuppressWarnings("unchecked")
@Test
public void getAllEmployees() {
Invocation invocation = new Invocation("getAllEmployees");
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Vector<DynamicEntity> resultVector = (Vector<DynamicEntity>)result;
XRDynamicEntity_CollectionWrapper xrDynEntityCol = new XRDynamicEntity_CollectionWrapper();
for (DynamicEntity employee : resultVector) {
xrDynEntityCol.add(employee);
xrDynEntityCol.add(employee.get("address"));
Vector<DynamicEntity> phones = (Vector<DynamicEntity>)employee.get("phones");
phones.size(); // trigger IndirectList
for (DynamicEntity phone : phones) {
xrDynEntityCol.add(phone);
}
}
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(xrDynEntityCol, doc);
Document controlDoc = xmlParser.parse(new StringReader(EMPLOYEE_COLLECTION_XML));
assertTrue("control document not same as XRService instance document",
comparer.isNodeEqual(controlDoc, doc));
}
@SuppressWarnings("unchecked")
@Test
public void buildEmployees() {
XMLUnmarshaller unMarshaller = xrService.getXMLContext().createUnmarshaller();
Reader reader = new StringReader(EMPLOYEE_COLLECTION_XML);
InputSource inputSource = new InputSource(reader);
Object result = unMarshaller.unmarshal(inputSource);
assertNotNull("result is null", result);
XRDynamicEntity_CollectionWrapper xrDynEntityCol = (XRDynamicEntity_CollectionWrapper)result;
DynamicEntity employee1 = (DynamicEntity)xrDynEntityCol.iterator().next();
assertNotNull("employee1 address is null", employee1.get("address"));
assertTrue("employee1 __pk incorrent", Integer.valueOf(1).equals(employee1.get("employeeId")));
assertTrue("employee1 first name incorrent", "Mike".equals(employee1.get("firstName")));
assertTrue("employee1 last name incorrent", "Norman".equals(employee1.get("lastName")));
ArrayList<DynamicEntity> phones = (ArrayList<DynamicEntity>)employee1.get("phones"); // phones
assertTrue("employee1 has wrong number of phones", phones.size() == 2);
}
public static final String EMPLOYEE_COLLECTION_XML =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<employee-address-phone-system xmlns=\"urn:keymappings\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<employee address-ref-id=\"1\" employee-id=\"1\">" +
"<first-name>Mike</first-name>" +
"<last-name>Norman</last-name>" +
"<phones>" +
"<phone-ref phone-id=\"1\"/>" +
"<phone-ref phone-id=\"2\"/>" +
"</phones>" +
"</employee>" +
"<address address-id=\"1\">" +
"<street>20 Pinetrail Cres.</street>" +
"<city>Nepean</city>" +
"<province>Ont</province>" +
"</address>" +
"<phone owner-ref-id=\"1\" phone-id=\"1\">" +
"<area-code>613</area-code>" +
"<phone-number>2281808</phone-number>" +
"<type>Home</type>" +
"</phone>" +
"<phone owner-ref-id=\"1\" phone-id=\"2\">" +
"<area-code>613</area-code>" +
"<phone-number>2884638</phone-number>" +
"<type>Work</type>" +
"</phone>" +
"<employee address-ref-id=\"2\" employee-id=\"2\">" +
"<first-name>Rick</first-name>" +
"<last-name>Barkhouse</last-name>" +
"<phones>" +
"<phone-ref phone-id=\"3\"/>" +
"<phone-ref phone-id=\"4\"/>" +
"</phones>" +
"</employee>" +
"<address address-id=\"2\">" +
"<street>Davis Side Rd.</street>" +
"<city>Carleton Place</city>" +
"<province>Ont</province>" +
"</address>" +
"<phone owner-ref-id=\"2\" phone-id=\"3\">" +
"<area-code>613</area-code>" +
"<phone-number>2832684</phone-number>" +
"<type>Home</type>" +
"</phone>" +
"<phone owner-ref-id=\"2\" phone-id=\"4\">" +
"<area-code>613</area-code>" +
"<phone-number>2884613</phone-number>" +
"<type>Work</type>" +
"</phone>" +
"</employee-address-phone-system>";
}