/******************************************************************************* | |
* Copyright (c) 2011, 2013 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 - Nov.9, 2011 - 2.4: test use of Advanced JDBC types from | |
* within a PL/SQL Package | |
******************************************************************************/ | |
package dbws.testing.advancedjdbcpackage; | |
//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.Ignore; | |
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; | |
//testing imports | |
import dbws.testing.DBWSTestSuite; | |
public class AdvancedJDBCPackageTestSuite extends DBWSTestSuite { | |
static final String CREATE_REGION_TYPE = | |
"CREATE OR REPLACE TYPE DBWS_REGION AS OBJECT (" + | |
"\nREG_ID NUMBER(5)," + | |
"\nREG_NAME VARCHAR2(50)" + | |
"\n)"; | |
static final String CREATE_EMP_ADDRESS_TYPE = | |
"CREATE OR REPLACE TYPE DBWS_EMP_ADDRESS AS OBJECT (" + | |
"\nSTREET VARCHAR2(100)," + | |
"\nSUBURB VARCHAR2(100)," + | |
"\nADDR_REGION DBWS_REGION," + | |
"\nPOSTCODE INTEGER" + | |
"\n)"; | |
static final String CREATE_EMP_OBJECT_TYPE = | |
"CREATE OR REPLACE TYPE DBWS_EMP_OBJECT AS OBJECT (" + | |
"\nEMPLOYEE_ID NUMBER(8)," + | |
"\nADDRESS DBWS_EMP_ADDRESS," + | |
"\nEMPLOYEE_NAME VARCHAR2(80)," + | |
"\nDATE_OF_HIRE DATE" + | |
"\n)"; | |
static final String CREATE_EMP_INFO_TYPE = | |
"CREATE OR REPLACE TYPE DBWS_EMP_INFO AS OBJECT (" + | |
"\nID NUMBER(5)," + | |
"\nNAME VARCHAR2(50)" + | |
"\n)"; | |
static final String CREATE_EMP_INFO_ARRAY_TYPE = | |
"CREATE OR REPLACE TYPE DBWS_EMP_INFO_ARRAY AS VARRAY(3) OF DBWS_EMP_INFO"; | |
static final String CREATE_ADVANCED_OBJECT_DEMO_PACKAGE = | |
"CREATE OR REPLACE PACKAGE DBWS_ADVANCED_OBJECT_DEMO AS" + | |
"\nFUNCTION ECHOREGION(AREGION IN DBWS_REGION) RETURN DBWS_REGION;" + | |
"\nFUNCTION ECHOEMPADDRESS(ANEMPADDRESS IN DBWS_EMP_ADDRESS) RETURN DBWS_EMP_ADDRESS;" + | |
"\nFUNCTION ECHOEMPOBJECT(ANEMPOBJECT IN DBWS_EMP_OBJECT) RETURN DBWS_EMP_OBJECT;" + | |
"\nFUNCTION BUILDEMPARRAY(NUM IN INTEGER) RETURN DBWS_EMP_INFO_ARRAY;" + | |
"\nEND DBWS_ADVANCED_OBJECT_DEMO;"; | |
static final String CREATE_ADVANCED_OBJECT_DEMO_BODY = | |
"CREATE OR REPLACE PACKAGE BODY DBWS_ADVANCED_OBJECT_DEMO AS" + | |
"\nFUNCTION ECHOREGION(AREGION IN DBWS_REGION) RETURN DBWS_REGION AS" + | |
"\nBEGIN" + | |
"\nRETURN AREGION;" + | |
"\nEND ECHOREGION;" + | |
"\nFUNCTION ECHOEMPADDRESS(ANEMPADDRESS IN DBWS_EMP_ADDRESS) RETURN DBWS_EMP_ADDRESS AS" + | |
"\nBEGIN" + | |
"\nRETURN ANEMPADDRESS;" + | |
"\nEND ECHOEMPADDRESS;" + | |
"\nFUNCTION ECHOEMPOBJECT(ANEMPOBJECT IN DBWS_EMP_OBJECT) RETURN DBWS_EMP_OBJECT AS" + | |
"\nBEGIN" + | |
"\nRETURN ANEMPOBJECT;" + | |
"\nEND ECHOEMPOBJECT;" + | |
"\nFUNCTION BUILDEMPARRAY(NUM IN INTEGER) RETURN DBWS_EMP_INFO_ARRAY AS" + | |
"\nL_DATA DBWS_EMP_INFO_ARRAY := DBWS_EMP_INFO_ARRAY();" + | |
"\nBEGIN" + | |
"\nFOR I IN 1 .. NUM LOOP" + | |
"\nL_DATA.EXTEND;" + | |
"\nL_DATA(I) := DBWS_EMP_INFO(I, 'entry ' || i);" + | |
"\nEND LOOP;" + | |
"\nRETURN L_DATA;" + | |
"\nEND BUILDEMPARRAY;" + | |
"\nEND DBWS_ADVANCED_OBJECT_DEMO;"; | |
static final String DROP_REGION_TYPE = | |
"DROP TYPE DBWS_REGION"; | |
static final String DROP_EMP_ADDRESS_TYPE = | |
"DROP TYPE DBWS_EMP_ADDRESS"; | |
static final String DROP_EMP_OBJECT_TYPE = | |
"DROP TYPE DBWS_EMP_OBJECT"; | |
static final String DROP_EMP_INFO_ARRAY_TYPE = | |
"DROP TYPE DBWS_EMP_INFO_ARRAY"; | |
static final String DROP_EMP_INFO_TYPE = | |
"DROP TYPE DBWS_EMP_INFO"; | |
static final String DROP_ADVANCED_OBJECT_DEMO_PACKAGE = | |
"DROP PACKAGE DBWS_ADVANCED_OBJECT_DEMO"; | |
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_REGION_TYPE, ddlDebug); | |
runDdl(conn, CREATE_EMP_ADDRESS_TYPE, ddlDebug); | |
runDdl(conn, CREATE_EMP_OBJECT_TYPE, ddlDebug); | |
runDdl(conn, CREATE_EMP_INFO_TYPE, ddlDebug); | |
runDdl(conn, CREATE_EMP_INFO_ARRAY_TYPE, ddlDebug); | |
runDdl(conn, CREATE_ADVANCED_OBJECT_DEMO_PACKAGE, ddlDebug); | |
runDdl(conn, CREATE_ADVANCED_OBJECT_DEMO_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\">advancedjdbcpackage</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>" + | |
"<procedure " + | |
"name=\"echoRegion\" " + | |
"catalogPattern=\"DBWS_ADVANCED_OBJECT_DEMO\" " + | |
"procedurePattern=\"ECHOREGION\" " + | |
"isAdvancedJDBC=\"true\" " + | |
"returnType=\"dbws_regionType\" " + | |
"/>" + | |
"<procedure " + | |
"name=\"echoEmpAddress\" " + | |
"catalogPattern=\"DBWS_ADVANCED_OBJECT_DEMO\" " + | |
"procedurePattern=\"ECHOEMPADDRESS\" " + | |
"isAdvancedJDBC=\"true\" " + | |
"returnType=\"dbws_emp_addressType\" " + | |
"/>" + | |
"<procedure " + | |
"name=\"echoEmpObject\" " + | |
"catalogPattern=\"DBWS_ADVANCED_OBJECT_DEMO\" " + | |
"procedurePattern=\"ECHOEMPOBJECT\" " + | |
"isAdvancedJDBC=\"true\" " + | |
"returnType=\"dbws_emp_objectType\" " + | |
"/>" + | |
"<procedure " + | |
"name=\"buildEmpArray\" " + | |
"catalogPattern=\"DBWS_ADVANCED_OBJECT_DEMO\" " + | |
"procedurePattern=\"BUILDEMPARRAY\" " + | |
"isAdvancedJDBC=\"true\" " + | |
"returnType=\"dbws_emp_info_arrayType\" " + | |
"/>" + | |
"</dbws-builder>"; | |
builder = null; | |
DBWSTestSuite.setUp("."); | |
} | |
@AfterClass | |
public static void tearDown() { | |
if (ddlDrop) { | |
runDdl(conn, DROP_ADVANCED_OBJECT_DEMO_PACKAGE, ddlDebug); | |
runDdl(conn, DROP_EMP_INFO_ARRAY_TYPE, ddlDebug); | |
runDdl(conn, DROP_EMP_INFO_TYPE, ddlDebug); | |
runDdl(conn, DROP_EMP_OBJECT_TYPE, ddlDebug); | |
runDdl(conn, DROP_EMP_ADDRESS_TYPE, ddlDebug); | |
runDdl(conn, DROP_REGION_TYPE, ddlDebug); | |
} | |
} | |
@Test | |
public void struct1LevelDeep() { | |
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller(); | |
Object region = unmarshaller.unmarshal(new StringReader(REGION_XML)); | |
Invocation invocation = new Invocation("echoRegion"); | |
invocation.setParameter("AREGION", region); | |
Operation op = xrService.getOperation(invocation.getName()); | |
Object result = op.invoke(xrService, invocation); | |
assertNotNull("result is null", result); | |
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller(); | |
Document doc = xmlPlatform.createDocument(); | |
marshaller.marshal(result, doc); | |
Document controlDoc = xmlParser.parse(new StringReader(REGION_XML)); | |
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc)); | |
} | |
static final String REGION_XML = | |
REGULAR_XML_HEADER + | |
"<dbws_regionType xmlns=\"urn:advancedjdbcpackage\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" + | |
"<reg_id>5</reg_id>" + | |
"<reg_name>this is a test</reg_name>" + | |
"</dbws_regionType>"; | |
@Test | |
public void struct2LevelDeep() { | |
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller(); | |
Object empAddress = unmarshaller.unmarshal(new StringReader(EMP_ADDRESS_XML)); | |
Invocation invocation = new Invocation("echoEmpAddress"); | |
invocation.setParameter("ANEMPADDRESS", empAddress); | |
Operation op = xrService.getOperation(invocation.getName()); | |
Object result = op.invoke(xrService, invocation); | |
assertNotNull("result is null", result); | |
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller(); | |
Document doc = xmlPlatform.createDocument(); | |
marshaller.marshal(result, doc); | |
Document controlDoc = xmlParser.parse(new StringReader(EMP_ADDRESS_XML)); | |
assertTrue("Expected:\n" + documentToString(controlDoc) + "\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc)); | |
} | |
static final String EMP_ADDRESS_XML = | |
REGULAR_XML_HEADER + | |
"<dbws_emp_addressType xmlns=\"urn:advancedjdbcpackage\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" + | |
"<street>20 Pinetrail Cres.</street>" + | |
"<suburb>Centrepointe</suburb>" + | |
"<addr_region>" + | |
"<reg_id>5</reg_id>" + | |
"<reg_name>this is a test</reg_name>" + | |
"</addr_region>" + | |
"<postcode>12</postcode>" + | |
"</dbws_emp_addressType>"; | |
@Test | |
public void struct3LevelDeep() { | |
XMLUnmarshaller unmarshaller = xrService.getXMLContext().createUnmarshaller(); | |
Object empObject = unmarshaller.unmarshal(new StringReader(EMP_OBJECT_XML)); | |
Invocation invocation = new Invocation("echoEmpObject"); | |
invocation.setParameter("ANEMPOBJECT", empObject); | |
Operation op = xrService.getOperation(invocation.getName()); | |
Object result = op.invoke(xrService, invocation); | |
assertNotNull("result is null", result); | |
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller(); | |
Document doc = xmlPlatform.createDocument(); | |
marshaller.marshal(result, doc); | |
Document controlDoc = xmlParser.parse(new StringReader(EMP_OBJECT_XML)); | |
assertTrue("Expected:\n" + documentToString(controlDoc) + | |
"\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc)); | |
} | |
static final String EMP_OBJECT_XML = | |
REGULAR_XML_HEADER + | |
"<dbws_emp_objectType xmlns=\"urn:advancedjdbcpackage\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" + | |
"<employee_id>55</employee_id>" + | |
"<address>" + | |
"<street>20 Pinetrail Cres.</street>" + | |
"<suburb>Centrepointe</suburb>" + | |
"<addr_region>" + | |
"<reg_id>5</reg_id>" + | |
"<reg_name>this is a test</reg_name>" + | |
"</addr_region>" + | |
"<postcode>12</postcode>" + | |
"</address>" + | |
"<employee_name>Mike Norman</employee_name>" + | |
"<date_of_hire>2011-11-11</date_of_hire>" + | |
"</dbws_emp_objectType>"; | |
@Test | |
public void buildEmpArray() { | |
Invocation invocation = new Invocation("buildEmpArray"); | |
invocation.setParameter("NUM", Integer.valueOf(3)); | |
Operation op = xrService.getOperation(invocation.getName()); | |
Object result = op.invoke(xrService, invocation); | |
assertNotNull("result is null", result); | |
XMLMarshaller marshaller = xrService.getXMLContext().createMarshaller(); | |
Document doc = xmlPlatform.createDocument(); | |
marshaller.marshal(result, doc); | |
Document controlDoc = xmlParser.parse(new StringReader(EMP_INFO_ARRAY_XML)); | |
assertTrue("Expected:\n" + documentToString(controlDoc) + | |
"\nActual:\n" + documentToString(doc), comparer.isNodeEqual(controlDoc, doc)); | |
} | |
static final String EMP_INFO_ARRAY_XML = | |
REGULAR_XML_HEADER + | |
"<dbws_emp_info_arrayType xmlns=\"urn:advancedjdbcpackage\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" + | |
"<item>" + | |
"<id>1</id>" + | |
"<name>entry 1</name>" + | |
"</item>" + | |
"<item>" + | |
"<id>2</id>" + | |
"<name>entry 2</name>" + | |
"</item>" + | |
"<item>" + | |
"<id>3</id>" + | |
"<name>entry 3</name>" + | |
"</item>" + | |
"</dbws_emp_info_arrayType>"; | |
} |