/*******************************************************************************
* Copyright (c) 2011, 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:
* David McCann - December 08, 2011 - 2.4 - Initial implementation
******************************************************************************/
package dbws.testing.complexplsqlsf;
//javase imports
import java.io.StringReader;
import org.w3c.dom.Document;
//java eXtension imports
import javax.wsdl.WSDLException;
//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;
//EclipseLink imports
import org.eclipse.persistence.internal.xr.Invocation;
import org.eclipse.persistence.internal.xr.Operation;
import org.eclipse.persistence.oxm.XMLMarshaller;
import org.eclipse.persistence.oxm.XMLUnmarshaller;
//test imports
import dbws.testing.DBWSTestSuite;
/**
* Tests PL/SQL stored functions with complex PL/SQL and advanced
* JDBC args.
*
*/
public class ComplexPLSQLSFTestSuite extends DBWSTestSuite {
static final String CREATE_VARCHAR2ARRAY_VARRAY =
"CREATE OR REPLACE TYPE VARCHAR2ARRAY AS VARRAY(10) OF VARCHAR2(20)";
static final String CREATE_A_PHONE2_TYPE =
"CREATE OR REPLACE TYPE A_PHONE2_TYPE AS OBJECT (" +
"\nHOME VARCHAR2(20)," +
"\nCELL VARCHAR2(20)" +
"\n)";
static final String CREATE_A_PHONE2_TYPE_TABLE =
"CREATE OR REPLACE TYPE A_PHONE2_TYPE_TABLE AS TABLE OF A_PHONE2_TYPE";
static final String CREATE_A_PHONE2_TYPE_VARRAY =
"CREATE OR REPLACE TYPE A_PHONE2_TYPE_VARRAY AS VARRAY(10) OF A_PHONE2_TYPE";
static final String CREATE_A_CONTACT2_TYPE =
"CREATE OR REPLACE TYPE A_CONTACT2_TYPE AS OBJECT (" +
"\nADDRESS VARCHAR2(40)," +
"\nPHONE A_PHONE2_TYPE" +
"\n)";
static final String CREATE_A_CUSTOMER2_TYPE =
"CREATE OR REPLACE TYPE A_CUSTOMER2_TYPE AS OBJECT (" +
"\nNAME VARCHAR2ARRAY," +
"\nAGE NUMBER(3)," +
"\nCONTACT A_CONTACT2_TYPE" +
"\n)";
static final String CREATE_COMPLEXPKG2_TAB1_TYPE =
"CREATE OR REPLACE TYPE COMPLEXPKG2_TAB1 AS TABLE OF VARCHAR2(20)";
static final String CREATE_COMPLEXPKG2_SIMPLERECORD_TYPE =
"CREATE OR REPLACE TYPE COMPLEXPKG2_SIMPLERECORD AS OBJECT (" +
"\nSR1 VARCHAR2(20)," +
"\nSR2 VARCHAR2(20)" +
"\n)";
static final String CREATE_COMPLEXPKG2_COMPLEXRECORD_TYPE =
"CREATE OR REPLACE TYPE COMPLEXPKG2_COMPLEXRECORD AS OBJECT (" +
"\nCR1 NUMBER," +
"\nCR2 A_CONTACT2_TYPE," +
"\nCR3 VARCHAR2ARRAY," +
"\nCR4 A_PHONE2_TYPE_TABLE" +
"\n)";
static final String CREATE_COMPLEXPKG2_MORECOMPLEXRECORD_TYPE =
"CREATE OR REPLACE TYPE COMPLEXPKG2_MORECOMPLEXRECORD AS OBJECT (" +
"\nMCR1 A_PHONE2_TYPE_VARRAY" +
"\n)";
static final String CREATE_COMPLEXPKG2_PACKAGE =
"CREATE OR REPLACE PACKAGE COMPLEXPKG2 AS" +
"\nTYPE TAB1 IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;" +
"\nTYPE SIMPLERECORD IS RECORD (" +
"\nSR1 VARCHAR2(20)," +
"\nSR2 VARCHAR2(20)" +
"\n);" +
"\nTYPE COMPLEXRECORD IS RECORD (" +
"\nCR1 NUMBER," +
"\nCR2 A_CONTACT2_TYPE," +
"\nCR3 VARCHAR2ARRAY," +
"\nCR4 A_PHONE2_TYPE_TABLE" +
"\n);" +
"\nTYPE MORECOMPLEXRECORD IS RECORD (" +
"\nMCR1 A_PHONE2_TYPE_VARRAY" +
"\n);" +
"\nFUNCTION TABLETOVARRAY(OLDTAB IN TAB1) RETURN VARCHAR2ARRAY;" +
"\nFUNCTION TABLESTOVARRAY(OLDTAB IN TAB1, OLDTAB2 IN TAB1) RETURN VARCHAR2ARRAY;" +
"\nFUNCTION VARRAYTOTABLE(OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1;" +
"\nFUNCTION VARRAYSTOTABLE(OLDVARRAY IN VARCHAR2ARRAY, OLDVARRAY2 IN VARCHAR2ARRAY) RETURN TAB1;" +
"\nFUNCTION PHONETOTABLE(APHONE IN A_PHONE2_TYPE) RETURN TAB1;" +
"\nFUNCTION PHONEANDVARRAYTOTABLE(APHONE IN A_PHONE2_TYPE, OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1;" +
"\nFUNCTION TABLETOPHONE(OLDTAB IN TAB1) RETURN A_PHONE2_TYPE;" +
"\nFUNCTION TABLEANDVARRAYTOPHONE(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN A_PHONE2_TYPE;" +
"\nFUNCTION TABLEANDVARRAYTOVARRAY(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN VARCHAR2ARRAY;" +
"\nFUNCTION TABLEANDVARRAYTOTABLE(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1;" +
"\nFUNCTION RECORDTOVARRAY(OLDREC IN SIMPLERECORD) RETURN VARCHAR2ARRAY;" +
"\nFUNCTION RECORDTOPHONE(OLDREC IN SIMPLERECORD) RETURN A_PHONE2_TYPE;" +
"\nFUNCTION VARRAYTORECORD(OLDVARRAY IN VARCHAR2ARRAY) RETURN SIMPLERECORD;" +
"\nFUNCTION PHONETORECORD(APHONE IN A_PHONE2_TYPE) RETURN SIMPLERECORD;" +
"\nFUNCTION PLSQLTOPHONETYPETABLE(OLDREC IN SIMPLERECORD, OLDTAB IN TAB1) RETURN A_PHONE2_TYPE_TABLE;" +
"\nFUNCTION PHONETYPETABLETOPLSQL(APHONETYPETABLE IN A_PHONE2_TYPE_TABLE) RETURN SIMPLERECORD;" +
"\nFUNCTION CREATECUSTOMER RETURN A_CUSTOMER2_TYPE;" +
"\nFUNCTION CREATE_COMPLEXRECORD(ACONTACT IN A_CONTACT2_TYPE, ANUMBER IN NUMBER, AVARRAY IN VARCHAR2ARRAY, APHONETYPETABLE IN A_PHONE2_TYPE_TABLE) RETURN COMPLEXRECORD;" +
"\nFUNCTION CREATE_PHONETYPEVARRAY(APHONETYPE1 IN A_PHONE2_TYPE, APHONETYPE2 IN A_PHONE2_TYPE) RETURN A_PHONE2_TYPE_VARRAY;" +
"\nFUNCTION CREATE_MORECOMPLEXRECORD(APHONETYPE1 IN A_PHONE2_TYPE, APHONETYPE2 IN A_PHONE2_TYPE) RETURN MORECOMPLEXRECORD;" +
"\nEND COMPLEXPKG2;";
static final String CREATE_COMPLEXPKG2_BODY =
"CREATE OR REPLACE PACKAGE BODY COMPLEXPKG2 AS" +
"\nFUNCTION TABLETOVARRAY(OLDTAB IN TAB1) RETURN VARCHAR2ARRAY AS" +
"\nNEWVARRAY VARCHAR2ARRAY;" +
"\nBEGIN" +
"\nNEWVARRAY := VARCHAR2ARRAY();" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(1) := OLDTAB(1);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(2) := OLDTAB(2);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(3) := OLDTAB(3);" +
"\nRETURN NEWVARRAY;" +
"\nEND TABLETOVARRAY;" +
"\nFUNCTION TABLESTOVARRAY(OLDTAB IN TAB1, OLDTAB2 IN TAB1) RETURN VARCHAR2ARRAY AS" +
"\nNEWVARRAY VARCHAR2ARRAY;" +
"\nBEGIN" +
"\nNEWVARRAY := VARCHAR2ARRAY();" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(1) := OLDTAB(1);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(2) := OLDTAB(2);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(3) := OLDTAB(3);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(4) := OLDTAB2(1);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(5) := OLDTAB2(2);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(6) := OLDTAB2(3);" +
"\nRETURN NEWVARRAY;" +
"\nEND TABLESTOVARRAY;" +
"\nFUNCTION VARRAYTOTABLE(OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1 AS" +
"\nNEWTAB TAB1;" +
"\nBEGIN" +
"\nNEWTAB(1) := OLDVARRAY(1);" +
"\nNEWTAB(2) := OLDVARRAY(2);" +
"\nNEWTAB(3) := OLDVARRAY(3);" +
"\nRETURN NEWTAB;" +
"\nEND VARRAYTOTABLE;" +
"\nFUNCTION VARRAYSTOTABLE(OLDVARRAY IN VARCHAR2ARRAY, OLDVARRAY2 IN VARCHAR2ARRAY) RETURN TAB1 AS" +
"\nNEWTAB TAB1;" +
"\nBEGIN" +
"\nNEWTAB(1) := OLDVARRAY(1);" +
"\nNEWTAB(2) := OLDVARRAY(2);" +
"\nNEWTAB(3) := OLDVARRAY(3);" +
"\nNEWTAB(4) := OLDVARRAY2(1);" +
"\nNEWTAB(5) := OLDVARRAY2(2);" +
"\nNEWTAB(6) := OLDVARRAY2(3);" +
"\nRETURN NEWTAB;" +
"\nEND VARRAYSTOTABLE;" +
"\nFUNCTION PHONETOTABLE(APHONE IN A_PHONE2_TYPE) RETURN TAB1 AS" +
"\nNEWTAB TAB1;" +
"\nBEGIN" +
"\nNEWTAB(1) := APHONE.HOME;" +
"\nNEWTAB(2) := APHONE.CELL;" +
"\nRETURN NEWTAB;" +
"\nEND PHONETOTABLE;" +
"\nFUNCTION PHONEANDVARRAYTOTABLE(APHONE IN A_PHONE2_TYPE, OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1 AS" +
"\nNEWTAB TAB1;" +
"\nBEGIN" +
"\nNEWTAB(1) := APHONE.HOME;" +
"\nNEWTAB(2) := APHONE.CELL;" +
"\nNEWTAB(3) := OLDVARRAY(1);" +
"\nNEWTAB(4) := OLDVARRAY(2);" +
"\nRETURN NEWTAB;" +
"\nEND PHONEANDVARRAYTOTABLE;" +
"\nFUNCTION TABLETOPHONE(OLDTAB IN TAB1) RETURN A_PHONE2_TYPE AS" +
"\nAPHONE A_PHONE2_TYPE;" +
"\nBEGIN" +
"\nAPHONE := A_PHONE2_TYPE(OLDTAB(1), OLDTAB(2));" +
"\nRETURN APHONE;" +
"\nEND TABLETOPHONE;" +
"\nFUNCTION TABLEANDVARRAYTOPHONE(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN A_PHONE2_TYPE AS" +
"\nAPHONE A_PHONE2_TYPE;" +
"\nBEGIN" +
"\nAPHONE := A_PHONE2_TYPE(OLDTAB(1), OLDVARRAY(1));" +
"\nRETURN APHONE;" +
"\nEND TABLEANDVARRAYTOPHONE;" +
"\nFUNCTION TABLEANDVARRAYTOVARRAY(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN VARCHAR2ARRAY AS" +
"\nNEWVARRAY VARCHAR2ARRAY;" +
"\nBEGIN" +
"\nNEWVARRAY := VARCHAR2ARRAY();" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(1) := OLDTAB(1);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(2) := OLDTAB(2);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(3) := OLDTAB(3);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(4) := OLDVARRAY(1);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(5) := OLDVARRAY(2);" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(6) := OLDVARRAY(3);" +
"\nRETURN NEWVARRAY;" +
"\nEND TABLEANDVARRAYTOVARRAY;" +
"\nFUNCTION TABLEANDVARRAYTOTABLE(OLDTAB IN TAB1, OLDVARRAY IN VARCHAR2ARRAY) RETURN TAB1 AS" +
"\nNEWTAB TAB1;" +
"\nBEGIN" +
"\nNEWTAB(1) := OLDTAB(1);" +
"\nNEWTAB(2) := OLDTAB(2);" +
"\nNEWTAB(3) := OLDTAB(3);" +
"\nNEWTAB(4) := OLDVARRAY(1);" +
"\nNEWTAB(5) := OLDVARRAY(2);" +
"\nNEWTAB(6) := OLDVARRAY(3);" +
"\nRETURN NEWTAB;" +
"\nEND TABLEANDVARRAYTOTABLE;" +
"\nFUNCTION RECORDTOVARRAY(OLDREC IN SIMPLERECORD) RETURN VARCHAR2ARRAY AS" +
"\nNEWVARRAY VARCHAR2ARRAY;" +
"\nBEGIN" +
"\nNEWVARRAY := VARCHAR2ARRAY();" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(1) := OLDREC.SR1;" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(2) := OLDREC.SR2;" +
"\nRETURN NEWVARRAY;" +
"\nEND RECORDTOVARRAY;" +
"\nFUNCTION RECORDTOPHONE(OLDREC IN SIMPLERECORD) RETURN A_PHONE2_TYPE AS" +
"\nAPHONE A_PHONE2_TYPE;" +
"\nBEGIN" +
"\nAPHONE := A_PHONE2_TYPE(OLDREC.SR1, OLDREC.SR2);" +
"\nRETURN APHONE;" +
"\nEND RECORDTOPHONE;" +
"\nFUNCTION VARRAYTORECORD(OLDVARRAY IN VARCHAR2ARRAY) RETURN SIMPLERECORD AS" +
"\nNEWREC SIMPLERECORD;" +
"\nBEGIN" +
"\nNEWREC.SR1 := OLDVARRAY(1);" +
"\nNEWREC.SR2 := OLDVARRAY(2);" +
"\nRETURN NEWREC;" +
"\nEND VARRAYTORECORD;" +
"\nFUNCTION PHONETORECORD(APHONE IN A_PHONE2_TYPE) RETURN SIMPLERECORD AS" +
"\nNEWREC SIMPLERECORD;" +
"\nBEGIN" +
"\nNEWREC.SR1 := APHONE.HOME;" +
"\nNEWREC.SR2 := APHONE.CELL;" +
"\nRETURN NEWREC;" +
"\nEND PHONETORECORD;" +
"\nFUNCTION PLSQLTOPHONETYPETABLE(OLDREC IN SIMPLERECORD, OLDTAB IN TAB1) RETURN A_PHONE2_TYPE_TABLE AS" +
"\nAPHONE1 A_PHONE2_TYPE;" +
"\nAPHONE2 A_PHONE2_TYPE;" +
"\nAPHONETYPETABLE A_PHONE2_TYPE_TABLE;" +
"\nBEGIN" +
"\nAPHONE1 := RECORDTOPHONE(OLDREC);" +
"\nAPHONE2 := TABLETOPHONE(OLDTAB);" +
"\nAPHONETYPETABLE := A_PHONE2_TYPE_TABLE();" +
"\nAPHONETYPETABLE.EXTEND;" +
"\nAPHONETYPETABLE(APHONETYPETABLE.COUNT) := APHONE1;" +
"\nAPHONETYPETABLE.EXTEND;" +
"\nAPHONETYPETABLE(APHONETYPETABLE.COUNT) := APHONE2;" +
"\nRETURN APHONETYPETABLE;" +
"\nEND PLSQLTOPHONETYPETABLE;" +
"\nFUNCTION PHONETYPETABLETOPLSQL(APHONETYPETABLE IN A_PHONE2_TYPE_TABLE) RETURN SIMPLERECORD AS" +
"\nAPHONE1 A_PHONE2_TYPE;" +
"\nAPHONE2 A_PHONE2_TYPE;" +
"\nNEWREC SIMPLERECORD;" +
"\nBEGIN" +
"\nAPHONE1 := APHONETYPETABLE(1);" +
"\nAPHONE2 := APHONETYPETABLE(2);" +
"\nNEWREC.SR1 := APHONE2.HOME;" +
"\nNEWREC.SR2 := APHONE1.HOME;" +
"\nRETURN NEWREC;" +
"\nEND PHONETYPETABLETOPLSQL;" +
"\nFUNCTION CREATECUSTOMER RETURN A_CUSTOMER2_TYPE AS" +
"\nACONTACT A_CONTACT2_TYPE;" +
"\nACUSTOMER A_CUSTOMER2_TYPE;" +
"\nNEWVARRAY VARCHAR2ARRAY;" +
"\nBEGIN" +
"\nNEWVARRAY := VARCHAR2ARRAY();" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(1) := 'John';" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(2) := 'Q';" +
"\nNEWVARRAY.EXTEND;" +
"\nNEWVARRAY(3) := 'Oracle';" +
"\nACONTACT := A_CONTACT2_TYPE('1234 Somewhere St, Ottawa, ON', A_PHONE2_TYPE('(613)555-1234', '(613)555-4321'));" +
"\nACUSTOMER := A_CUSTOMER2_TYPE(NEWVARRAY, 41, ACONTACT);" +
"\nRETURN ACUSTOMER;" +
"\nEND CREATECUSTOMER;" +
"\nFUNCTION CREATE_COMPLEXRECORD(ACONTACT IN A_CONTACT2_TYPE, ANUMBER IN NUMBER, AVARRAY IN VARCHAR2ARRAY, APHONETYPETABLE IN A_PHONE2_TYPE_TABLE) RETURN COMPLEXRECORD AS" +
"\nACOMPLEXREC COMPLEXRECORD;" +
"\nBEGIN" +
"\nACOMPLEXREC.CR1 := ANUMBER;" +
"\nACOMPLEXREC.CR2 := ACONTACT;" +
"\nACOMPLEXREC.CR3 := AVARRAY;" +
"\nACOMPLEXREC.CR4 := APHONETYPETABLE;" +
"\nRETURN ACOMPLEXREC;" +
"\nEND CREATE_COMPLEXRECORD;" +
"\nFUNCTION CREATE_PHONETYPEVARRAY(APHONETYPE1 IN A_PHONE2_TYPE, APHONETYPE2 IN A_PHONE2_TYPE) RETURN A_PHONE2_TYPE_VARRAY AS" +
"\nPHONETYPEARRAY A_PHONE2_TYPE_VARRAY;" +
"\nBEGIN" +
"\nPHONETYPEARRAY := A_PHONE2_TYPE_VARRAY();" +
"\nPHONETYPEARRAY.EXTEND;" +
"\nPHONETYPEARRAY(1) := APHONETYPE1;" +
"\nPHONETYPEARRAY.EXTEND;" +
"\nPHONETYPEARRAY(2) := APHONETYPE2;" +
"\nRETURN PHONETYPEARRAY;" +
"\nEND CREATE_PHONETYPEVARRAY;" +
"\nFUNCTION CREATE_MORECOMPLEXRECORD(APHONETYPE1 IN A_PHONE2_TYPE, APHONETYPE2 IN A_PHONE2_TYPE) RETURN MORECOMPLEXRECORD AS" +
"\nMORECOMPLEXREC MORECOMPLEXRECORD;" +
"\nBEGIN" +
"\nMORECOMPLEXREC.MCR1 := CREATE_PHONETYPEVARRAY(APHONETYPE1, APHONETYPE2);" +
"\nRETURN MORECOMPLEXREC;" +
"\nEND CREATE_MORECOMPLEXRECORD;" +
"\nEND COMPLEXPKG2;";
static final String DROP_COMPLEXPKG2_PACKAGE =
"DROP PACKAGE COMPLEXPKG2";
static final String DROP_COMPLEXPKG2_PACKAGE_BODY =
"DROP PACKAGE BODY COMPLEXPKG2";
static final String DROP_COMPLEXPKG2_TAB1_TYPE =
"DROP TYPE COMPLEXPKG2_TAB1";
static final String DROP_COMPLEXPKG2_SIMPLERECORD_TYPE =
"DROP TYPE COMPLEXPKG2_SIMPLERECORD";
static final String DROP_COMPLEXPKG2_COMPLEXRECORD_TYPE =
"DROP TYPE COMPLEXPKG2_COMPLEXRECORD";
static final String DROP_VARCHAR2ARRAY_TYPE =
"DROP TYPE VARCHAR2ARRAY";
static final String DROP_A_PHONE2_TYPE =
"DROP TYPE A_PHONE2_TYPE";
static final String DROP_A_CUSTOMER2_TYPE =
"DROP TYPE A_CUSTOMER2_TYPE";
static final String DROP_A_CONTACT2_TYPE =
"DROP TYPE A_CONTACT2_TYPE";
static final String DROP_A_PHONE2_TYPE_TABLE =
"DROP TYPE A_PHONE2_TYPE_TABLE";
static final String DROP_A_PHONE2_TYPE_VARRAY =
"DROP TYPE A_PHONE2_TYPE_VARRAY";
static final String DROP_COMPLEXPKG2_MORECOMPLEXRECORD_TYPE =
"DROP TYPE COMPLEXPKG2_MORECOMPLEXRECORD";
static boolean ddlCreate = false;
static boolean ddlDrop = false;
static boolean ddlDebug = false;
@BeforeClass
public static void setUp() throws WSDLException {
if (conn == null) {
try {
conn = buildConnection();
}
catch (Exception e) {
e.printStackTrace();
}
}
String ddlCreateProp = System.getProperty(DATABASE_DDL_CREATE_KEY, DEFAULT_DATABASE_DDL_CREATE);
if ("true".equalsIgnoreCase(ddlCreateProp)) {
ddlCreate = true;
}
String ddlDropProp = System.getProperty(DATABASE_DDL_DROP_KEY, DEFAULT_DATABASE_DDL_DROP);
if ("true".equalsIgnoreCase(ddlDropProp)) {
ddlDrop = true;
}
String ddlDebugProp = System.getProperty(DATABASE_DDL_DEBUG_KEY, DEFAULT_DATABASE_DDL_DEBUG);
if ("true".equalsIgnoreCase(ddlDebugProp)) {
ddlDebug = true;
}
if (ddlCreate) {
runDdl(conn, CREATE_VARCHAR2ARRAY_VARRAY, ddlDebug);
runDdl(conn, CREATE_A_PHONE2_TYPE, ddlDebug);
runDdl(conn, CREATE_A_PHONE2_TYPE_TABLE, ddlDebug);
runDdl(conn, CREATE_A_PHONE2_TYPE_VARRAY, ddlDebug);
runDdl(conn, CREATE_A_CONTACT2_TYPE, ddlDebug);
runDdl(conn, CREATE_A_CUSTOMER2_TYPE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_SIMPLERECORD_TYPE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_COMPLEXRECORD_TYPE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_MORECOMPLEXRECORD_TYPE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_TAB1_TYPE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_PACKAGE, ddlDebug);
runDdl(conn, CREATE_COMPLEXPKG2_BODY, ddlDebug);
}
DBWS_BUILDER_XML_USERNAME =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<dbws-builder xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
"<properties>" +
"<property name=\"projectName\">ComplexPLSQLSF</property>" +
"<property name=\"logLevel\">off</property>" +
"<property name=\"username\">";
DBWS_BUILDER_XML_PASSWORD =
"</property><property name=\"password\">";
DBWS_BUILDER_XML_URL =
"</property><property name=\"url\">";
DBWS_BUILDER_XML_DRIVER =
"</property><property name=\"driver\">";
DBWS_BUILDER_XML_PLATFORM =
"</property><property name=\"platformClassname\">";
DBWS_BUILDER_XML_MAIN =
"</property>" +
"</properties>" +
"<plsql-procedure " +
"name=\"TableToVArrayTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLETOVARRAY\" " +
"/>" +
"<plsql-procedure " +
"name=\"TablesToVArrayTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLESTOVARRAY\" " +
"/>" +
"<plsql-procedure " +
"name=\"VArrayToTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"VARRAYTOTABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"VArraysToTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"VARRAYSTOTABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"PhoneToTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"PHONETOTABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"PhoneAndVArrayToTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"PHONEANDVARRAYTOTABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"TableToPhoneTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLETOPHONE\" " +
"/>" +
"<plsql-procedure " +
"name=\"TableAndVArrayToPhoneTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLEANDVARRAYTOPHONE\" " +
"/>" +
"<plsql-procedure " +
"name=\"TableAndVArrayToVArrayTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLEANDVARRAYTOVARRAY\" " +
"/>" +
"<plsql-procedure " +
"name=\"TableAndVArrayToTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"TABLEANDVARRAYTOTABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"RecordToVArrayTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"RECORDTOVARRAY\" " +
"/>" +
"<plsql-procedure " +
"name=\"RecordToPhoneTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"RECORDTOPHONE\" " +
"/>" +
"<plsql-procedure " +
"name=\"VArrayToRecordTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"VARRAYTORECORD\" " +
"/>" +
"<plsql-procedure " +
"name=\"PhoneToRecordTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"PHONETORECORD\" " +
"/>" +
"<plsql-procedure " +
"name=\"PLSQLToPhoneTypeTableTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"PLSQLTOPHONETYPETABLE\" " +
"/>" +
"<plsql-procedure " +
"name=\"PhoneTypeTableToPLSQLTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"PHONETYPETABLETOPLSQL\" " +
"/>" +
"<plsql-procedure " +
"name=\"CreateCustomerTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"CREATECUSTOMER\" " +
"/>" +
"<plsql-procedure " +
"name=\"CreateComplexRecordTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"CREATE_COMPLEXRECORD\" " +
"/>" +
"<plsql-procedure " +
"name=\"CreatePhoneTypeVArrayTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"CREATE_PHONETYPEVARRAY\" " +
"/>" +
"<plsql-procedure " +
"name=\"CreateMoreComplexRecordTest\" " +
"catalogPattern=\"COMPLEXPKG2\" " +
"procedurePattern=\"CREATE_MORECOMPLEXRECORD\" " +
"/>" +
"</dbws-builder>";
builder = null;
DBWSTestSuite.setUp(".");
}
@AfterClass
public static void tearDown() {
if (ddlDrop) {
runDdl(conn, DROP_COMPLEXPKG2_PACKAGE_BODY, ddlDebug);
runDdl(conn, DROP_COMPLEXPKG2_PACKAGE, ddlDebug);
runDdl(conn, DROP_COMPLEXPKG2_SIMPLERECORD_TYPE, ddlDebug);
runDdl(conn, DROP_COMPLEXPKG2_COMPLEXRECORD_TYPE, ddlDebug);
runDdl(conn, DROP_COMPLEXPKG2_MORECOMPLEXRECORD_TYPE, ddlDebug);
runDdl(conn, DROP_A_CUSTOMER2_TYPE, ddlDebug);
runDdl(conn, DROP_A_CONTACT2_TYPE, ddlDebug);
runDdl(conn, DROP_A_PHONE2_TYPE_VARRAY, ddlDebug);
runDdl(conn, DROP_A_PHONE2_TYPE_TABLE, ddlDebug);
runDdl(conn, DROP_A_PHONE2_TYPE, ddlDebug);
runDdl(conn, DROP_COMPLEXPKG2_TAB1_TYPE, ddlDebug);
runDdl(conn, DROP_VARCHAR2ARRAY_TYPE, ddlDebug);
}
}
@Test
public void tableToVArrayTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTab1 = unmarshaller.unmarshal(new StringReader(TABLE_XML));
Invocation invocation = new Invocation("TableToVArrayTest");
invocation.setParameter("OLDTAB", inputTab1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(VARRAY_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void tablesToVArrayTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTab1 = unmarshaller.unmarshal(new StringReader(TABLE_XML));
Object inputTab2 = unmarshaller.unmarshal(new StringReader(TABLE2_XML));
Invocation invocation = new Invocation("TablesToVArrayTest");
invocation.setParameter("OLDTAB", inputTab1);
invocation.setParameter("OLDTAB2", inputTab2);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(VARRAY3_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void vArrayToTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputArray1 = unmarshaller.unmarshal(new StringReader(VARRAY_XML));
Invocation invocation = new Invocation("VArrayToTableTest");
invocation.setParameter("OLDVARRAY", inputArray1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(TABLE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void vArraysToTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputArray1 = unmarshaller.unmarshal(new StringReader(VARRAY_XML));
Object inputArray2 = unmarshaller.unmarshal(new StringReader(VARRAY2_XML));
Invocation invocation = new Invocation("VArraysToTableTest");
invocation.setParameter("OLDVARRAY", inputArray1);
invocation.setParameter("OLDVARRAY2", inputArray2);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(TABLE3_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void objectTypeToTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPhone1 = unmarshaller.unmarshal(new StringReader(APHONE_XML));
Invocation invocation = new Invocation("PhoneToTableTest");
invocation.setParameter("APHONE", inputPhone1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(PHONE_TABLE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void objectTypeAndVArrayToTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPhone = unmarshaller.unmarshal(new StringReader(APHONE_XML));
Object inputVArray = unmarshaller.unmarshal(new StringReader(PHONE_VARRAY_XML));
Invocation invocation = new Invocation("PhoneAndVArrayToTableTest");
invocation.setParameter("APHONE", inputPhone);
invocation.setParameter("OLDVARRAY", inputVArray);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(PHONE_AND_VARRAY_TABLE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void tableToObjectTypeTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTable1 = unmarshaller.unmarshal(new StringReader(PHONE_TABLE_XML));
Invocation invocation = new Invocation("TableToPhoneTest");
invocation.setParameter("OLDTAB", inputTable1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(APHONE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void tableAndVArrayToObjectTypeTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTab = unmarshaller.unmarshal(new StringReader(PHONE_TABLE_XML));
Object inputVArray = unmarshaller.unmarshal(new StringReader(PHONE_VARRAY_XML));
Invocation invocation = new Invocation("TableAndVArrayToPhoneTest");
invocation.setParameter("OLDTAB", inputTab);
invocation.setParameter("OLDVARRAY", inputVArray);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(APHONE2_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void tableAndVArrayToVArrayTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTab = unmarshaller.unmarshal(new StringReader(TABLE_XML));
Object inputVArray = unmarshaller.unmarshal(new StringReader(VARRAY2_XML));
Invocation invocation = new Invocation("TableAndVArrayToVArrayTest");
invocation.setParameter("OLDTAB", inputTab);
invocation.setParameter("OLDVARRAY", inputVArray);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(VARRAY3_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void tableAndVArrayToTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputTab = unmarshaller.unmarshal(new StringReader(TABLE_XML));
Object inputVArray = unmarshaller.unmarshal(new StringReader(VARRAY2_XML));
Invocation invocation = new Invocation("TableAndVArrayToTableTest");
invocation.setParameter("OLDTAB", inputTab);
invocation.setParameter("OLDVARRAY", inputVArray);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(TABLE3_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void recordToVArrayTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputRec1 = unmarshaller.unmarshal(new StringReader(SIMPLE_RECORD_XML));
Invocation invocation = new Invocation("RecordToVArrayTest");
invocation.setParameter("OLDREC", inputRec1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(PHONE_VARRAY_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void recordToPhoneTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputRec1 = unmarshaller.unmarshal(new StringReader(SIMPLE_RECORD2_XML));
Invocation invocation = new Invocation("RecordToPhoneTest");
invocation.setParameter("OLDREC", inputRec1);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(APHONE2_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void varrayToRecordTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputVArray = unmarshaller.unmarshal(new StringReader(PHONE_VARRAY_XML));
Invocation invocation = new Invocation("VArrayToRecordTest");
invocation.setParameter("OLDVARRAY", inputVArray);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(SIMPLE_RECORD_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void phoneToRecordTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPhone = unmarshaller.unmarshal(new StringReader(APHONE2_XML));
Invocation invocation = new Invocation("PhoneToRecordTest");
invocation.setParameter("APHONE", inputPhone);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(SIMPLE_RECORD2_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void plsqlToPhoneTypeTableTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputRec = unmarshaller.unmarshal(new StringReader(SIMPLE_RECORD_XML));
Object inputTab = unmarshaller.unmarshal(new StringReader(PHONE_TABLE_XML));
Invocation invocation = new Invocation("PLSQLToPhoneTypeTableTest");
invocation.setParameter("OLDREC", inputRec);
invocation.setParameter("OLDTAB", inputTab);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(PHONE_TYPE_TABLE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void phoneTypeTableToPLSQLTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPTypeTable = unmarshaller.unmarshal(new StringReader(PHONE_TYPE_TABLE_XML));
Invocation invocation = new Invocation("PhoneTypeTableToPLSQLTest");
invocation.setParameter("APHONETYPETABLE", inputPTypeTable);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(SIMPLE_RECORD2_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void createContactTest() {
Invocation invocation = new Invocation("CreateCustomerTest");
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(CUSTOMER_TYPE_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void createComplexRecordTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputContact= unmarshaller.unmarshal(new StringReader(CONTACT_TYPE_XML));
Object inputVArray = unmarshaller.unmarshal(new StringReader(VARRAY_XML));
Object inputPhoneTable = unmarshaller.unmarshal(new StringReader(PHONE_TYPE_TABLE_XML));
Invocation invocation = new Invocation("CreateComplexRecordTest");
invocation.setParameter("ACONTACT", inputContact);
invocation.setParameter("ANUMBER", 66);
invocation.setParameter("AVARRAY", inputVArray);
invocation.setParameter("APHONETYPETABLE", inputPhoneTable);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(COMPLEX_RECORD_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void createPhoneTypeVArrayTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPhone1 = unmarshaller.unmarshal(new StringReader(APHONE_XML));
Object inputPhone2 = unmarshaller.unmarshal(new StringReader(APHONE2_XML));
Invocation invocation = new Invocation("CreatePhoneTypeVArrayTest");
invocation.setParameter("APHONETYPE1", inputPhone1);
invocation.setParameter("APHONETYPE2", inputPhone2);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(APHONETYPEARRAY_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
@Test
public void createMoreComplexRecordTest() {
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller();
Object inputPhone1 = unmarshaller.unmarshal(new StringReader(APHONE_XML));
Object inputPhone2 = unmarshaller.unmarshal(new StringReader(APHONE2_XML));
Invocation invocation = new Invocation("CreateMoreComplexRecordTest");
invocation.setParameter("APHONETYPE1", inputPhone1);
invocation.setParameter("APHONETYPE2", inputPhone2);
Operation op = xrService.getOperation(invocation.getName());
Object result = op.invoke(xrService, invocation);
assertNotNull("result is null", result);
Document doc = xmlPlatform.createDocument();
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller();
marshaller.marshal(result, doc);
Document controlDoc = xmlParser.parse(new StringReader(MORECOMPLEX_RECORD_XML));
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc));
}
public static final String TABLE_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_tab1Type xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foo</item>" +
"<item>bar</item>" +
"<item>blah</item>" +
"</complexpkg2_tab1Type>";
public static final String TABLE2_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_tab1Type xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foobar</item>" +
"<item>barfoo</item>" +
"<item>blahblah</item>" +
"</complexpkg2_tab1Type>";
public static final String TABLE3_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_tab1Type xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foo</item>" +
"<item>bar</item>" +
"<item>blah</item>" +
"<item>foobar</item>" +
"<item>barfoo</item>" +
"<item>blahblah</item>" +
"</complexpkg2_tab1Type>";
public static final String PHONE_TABLE_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_tab1Type xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>(613)111-2222</item>" +
"<item>(613)222-3333</item>" +
"</complexpkg2_tab1Type>";
public static final String PHONE_VARRAY_XML =
STANDALONE_XML_HEADER +
"<varchar2arrayType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>(613)333-4444</item>" +
"<item>(613)444-5555</item>" +
"</varchar2arrayType>";
public static final String PHONE_AND_VARRAY_TABLE_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_tab1Type xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>(613)111-2222</item>" +
"<item>(613)222-3333</item>" +
"<item>(613)333-4444</item>" +
"<item>(613)444-5555</item>" +
"</complexpkg2_tab1Type>";
public static final String VARRAY_XML =
STANDALONE_XML_HEADER +
"<varchar2arrayType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foo</item>" +
"<item>bar</item>" +
"<item>blah</item>" +
"</varchar2arrayType>";
public static final String VARRAY2_XML =
STANDALONE_XML_HEADER +
"<varchar2arrayType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foobar</item>" +
"<item>barfoo</item>" +
"<item>blahblah</item>" +
"</varchar2arrayType>";
public static final String VARRAY3_XML =
STANDALONE_XML_HEADER +
"<varchar2arrayType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>foo</item>" +
"<item>bar</item>" +
"<item>blah</item>" +
"<item>foobar</item>" +
"<item>barfoo</item>" +
"<item>blahblah</item>" +
"</varchar2arrayType>";
public static final String APHONE_XML =
STANDALONE_XML_HEADER +
"<a_phone2_typeType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<home>(613)111-2222</home>" +
"<cell>(613)222-3333</cell>" +
"</a_phone2_typeType>";
public static final String APHONE2_XML =
STANDALONE_XML_HEADER +
"<a_phone2_typeType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<home>(613)111-2222</home>" +
"<cell>(613)333-4444</cell>" +
"</a_phone2_typeType>";
public static final String APHONETYPEARRAY_XML =
STANDALONE_XML_HEADER +
"<a_phone2_type_varrayType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)222-3333</cell>" +
"</item>" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)333-4444</cell>" +
"</item>" +
"</a_phone2_type_varrayType>";
public static final String SIMPLE_RECORD_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_simplerecordType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<sr1>(613)333-4444</sr1>" +
"<sr2>(613)444-5555</sr2>" +
"</complexpkg2_simplerecordType>";
public static final String SIMPLE_RECORD2_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_simplerecordType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<sr1>(613)111-2222</sr1>" +
"<sr2>(613)333-4444</sr2>" +
"</complexpkg2_simplerecordType>";
public static final String PHONE_TYPE_TABLE_XML =
STANDALONE_XML_HEADER +
"<a_phone2_type_tableType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<item>" +
"<home>(613)333-4444</home>" +
"<cell>(613)444-5555</cell>" +
"</item>" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)222-3333</cell>" +
"</item>" +
"</a_phone2_type_tableType>";
public static final String CUSTOMER_TYPE_XML =
STANDALONE_XML_HEADER +
"<a_customer2_typeType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<name>John</name>" +
"<name>Q</name>" +
"<name>Oracle</name>" +
"<age>41</age>" +
"<contact>" +
"<address>1234 Somewhere St, Ottawa, ON</address>" +
"<phone>" +
"<home>(613)555-1234</home>" +
"<cell>(613)555-4321</cell>" +
"</phone>" +
"</contact>" +
"</a_customer2_typeType>";
public static final String CONTACT_TYPE_XML =
STANDALONE_XML_HEADER +
"<a_contact2_typeType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<address>1234 Somewhere St, Ottawa, ON</address>" +
"<phone>" +
"<home>(613)555-1234</home>" +
"<cell>(613)555-4321</cell>" +
"</phone>" +
"</a_contact2_typeType>";
public static final String COMPLEX_RECORD_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_complexrecordType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<cr1>66</cr1>" +
"<cr2>" +
"<address>1234 Somewhere St, Ottawa, ON</address>" +
"<phone>" +
"<home>(613)555-1234</home>" +
"<cell>(613)555-4321</cell>" +
"</phone>" +
"</cr2>" +
"<cr3>" +
"<item>foo</item>" +
"<item>bar</item>" +
"<item>blah</item>" +
"</cr3>" +
"<cr4>" +
"<item>" +
"<home>(613)333-4444</home>" +
"<cell>(613)444-5555</cell>" +
"</item>" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)222-3333</cell>" +
"</item>" +
"</cr4>" +
"</complexpkg2_complexrecordType>";
public static final String MORECOMPLEX_RECORD_XML =
STANDALONE_XML_HEADER +
"<complexpkg2_morecomplexrecordType xmlns=\"urn:ComplexPLSQLSF\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<mcr1>" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)222-3333</cell>" +
"</item>" +
"<item>" +
"<home>(613)111-2222</home>" +
"<cell>(613)333-4444</cell>" +
"</item>" +
"</mcr1>" +
"</complexpkg2_morecomplexrecordType>";
}