| /* |
| * Copyright (c) 2011, 2020 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 v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // Contributors: |
| // David McCann - Aug.15, 2012 - 2.4.1 - Initial implementation |
| package dbws.testing.simpleplsql; |
| |
| import java.io.StringReader; |
| |
| import javax.xml.namespace.QName; |
| |
| import jakarta.xml.soap.SOAPBody; |
| import jakarta.xml.soap.SOAPMessage; |
| import jakarta.xml.ws.Dispatch; |
| import jakarta.xml.ws.Service; |
| import jakarta.xml.ws.soap.SOAPBinding; |
| |
| import org.junit.AfterClass; |
| import org.junit.BeforeClass; |
| import org.junit.Test; |
| import org.w3c.dom.Document; |
| import org.w3c.dom.Node; |
| import org.w3c.dom.NodeList; |
| |
| import dbws.testing.DBWSTestSuite; |
| import static dbws.testing.simpleplsql.SimplePLSQLBuilderTestSuite.CREATE_PACKAGE; |
| import static dbws.testing.simpleplsql.SimplePLSQLBuilderTestSuite.CREATE_PACKAGE_BODY; |
| import static dbws.testing.simpleplsql.SimplePLSQLBuilderTestSuite.DROP_PACKAGE; |
| import static dbws.testing.simpleplsql.SimplePLSQLBuilderTestSuite.DROP_PACKAGE_BODY; |
| |
| import static org.junit.Assert.fail; |
| import static org.junit.Assert.assertNotNull; |
| import static org.junit.Assert.assertTrue; |
| |
| /** |
| * Tests a simple PL/SQL stored procedure. |
| * |
| */ |
| public class SimplePLSQLServiceTestSuite extends DBWSTestSuite { |
| public static final String TEST = "simpleplsql"; |
| public static final String TEST_NAMESPACE = "urn:simpleplsql"; |
| public static final String SERVICE = "simpleplsqlService"; |
| public static final String SERVICE_NAMESPACE = "urn:simpleplsqlService"; |
| public static final String SERVICE_PORT = "simpleplsqlServicePort"; |
| |
| static final String REQUEST_MSG = |
| "<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" + |
| "<env:Header/>" + |
| "<env:Body>" + |
| "<"+TEST+ " xmlns="+ "\"" + SERVICE_NAMESPACE + "\"" + ">" + |
| "<ARG1>blah</ARG1>" + |
| "</simpleplsql>" + |
| "</env:Body>" + |
| "</env:Envelope>"; |
| |
| static final String RESPONSE_MSG = |
| "<srvc:" + TEST + "Response xmlns:srvc="+ "\"" + SERVICE_NAMESPACE + "\">" + |
| "<srvc:result>" + |
| "<simple-xml-format>" + |
| "<simple-xml>" + |
| "<ARG2>blah</ARG2>" + |
| "</simple-xml>" + |
| "</simple-xml-format>" + |
| "</srvc:result>" + |
| "</srvc:simpleplsqlResponse>"; |
| |
| @BeforeClass |
| public static void setUp() { |
| if (conn == null) { |
| try { |
| conn = buildConnection(); |
| } catch (Exception e) { |
| e.printStackTrace(); |
| } |
| } |
| if (ddlCreate) { |
| runDdl(conn, CREATE_PACKAGE, ddlDebug); |
| runDdl(conn, CREATE_PACKAGE_BODY, ddlDebug); |
| } |
| } |
| |
| @AfterClass |
| public static void tearDown() { |
| if (ddlDrop) { |
| runDdl(conn, DROP_PACKAGE_BODY, ddlDebug); |
| runDdl(conn, DROP_PACKAGE, ddlDebug); |
| } |
| } |
| |
| @Test |
| public void testService() { |
| try { |
| QName qname = new QName(SERVICE_NAMESPACE, SERVICE_PORT); |
| Service service = Service.create(new QName(TEST_NAMESPACE, SERVICE)); |
| service.addPort(qname, SOAPBinding.SOAP11HTTP_BINDING, "http://" + host + ":" + port + "/simpleplsql/simpleplsql"); |
| Dispatch<SOAPMessage> sourceDispatch = service.createDispatch(qname, SOAPMessage.class, Service.Mode.MESSAGE); |
| |
| // Test plsql proc |
| SOAPMessage request = createSOAPMessage(REQUEST_MSG); |
| SOAPMessage response = sourceDispatch.invoke(request); |
| assertNotNull("Test failed: response is null.", response); |
| |
| SOAPBody responseBody = response.getSOAPPart().getEnvelope().getBody(); |
| Document resultDoc = responseBody.extractContentAsDocument(); |
| |
| NodeList elts = resultDoc.getDocumentElement().getElementsByTagNameNS(SERVICE_NAMESPACE, "result"); |
| assertTrue("The wrong number of elements were returned.", ((elts != null && elts.getLength() > 0) && elts.getLength() == 1)); |
| Node testNode = elts.item(0); |
| assertTrue("Didn't find [<srvc:result>] element", testNode.getLocalName().equalsIgnoreCase("result")); |
| |
| Document controlDoc = xmlParser.parse(new StringReader(RESPONSE_MSG)); |
| elts = controlDoc.getDocumentElement().getElementsByTagNameNS(SERVICE_NAMESPACE, "result"); |
| Node ctrlNode = elts.item(0); |
| |
| assertTrue("\nDocument comparison failed. Expected:\n" + documentToString(ctrlNode) + "\nbut was:\n" + documentToString(testNode), comparer.isNodeEqual(ctrlNode, testNode)); |
| } catch (Exception x) { |
| fail("Service test failed: " + x.getMessage()); |
| } |
| } |
| } |