@BeforeClass
 public static void setUp() throws WSDLException {
   DBWS_BUILDER_XML_USERNAME =
       "******"1.0\" encoding=\"UTF-8\"?>"
           + "<dbws-builder xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">"
           + "<properties>"
           + "<property name=\"projectName\">inlinebinary</property>"
           + "<property name=\"logLevel\">off</property>"
           + "<property name=\"username\">";
   DBWS_BUILDER_XML_PASSWORD = "******"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>"
           + "<table "
           + "schemaPattern=\"%\" "
           + "tableNamePattern=\"inlinebinary\" "
           + "/>"
           + "</dbws-builder>";
   DBWSTestSuite.setUp();
 }
예제 #2
0
  @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_PACKAGE_TEST_TYPES, ddlDebug);
      runDdl(conn, CREATE_PACKAGE_BODY_TEST_TYPES, ddlDebug);

      runDdl(conn, CREATE_XMLTYPEDATA_TABLE, ddlDebug);
      try {
        Statement stmt = conn.createStatement();
        for (int i = 0; i < POPULATE_XMLTYPEDATA_TABLE.length; i++) {
          stmt.addBatch(POPULATE_XMLTYPEDATA_TABLE[i]);
        }
        stmt.executeBatch();
      } catch (SQLException e) {
        // e.printStackTrace();
      }
    }
    DBWS_BUILDER_XML_USERNAME =
        "******"1.0\" encoding=\"UTF-8\"?>"
            + "<dbws-builder xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">"
            + "<properties>"
            + "<property name=\"projectName\">Types</property>"
            + "<property name=\"logLevel\">off</property>"
            + "<property name=\"username\">";
    DBWS_BUILDER_XML_PASSWORD = "******"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=\"echoInteger\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_INTEGER\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoSmallint\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_SMALLINT\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoNumeric\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_NUMERIC\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoDec\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_DEC\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoDecimal\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_DECIMAL\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoNumber\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_NUMBER\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoVarchar\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_VARCHAR\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoVarchar2\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_VARCHAR2\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoNVarchar2\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_NVARCHAR2\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"pEchoNchar\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"pEchoNchar\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"fEchoNchar\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"fEchoNchar\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"pEchoNvarchar2\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"pEchoNvarchar2\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoChar\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_CHAR\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoReal\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_REAL\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoFloat\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_FLOAT\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoDouble\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_DOUBLE\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoDate\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_DATE\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoTimestamp\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_TIMESTAMP\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoClob\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_CLOB\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoBlob\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_BLOB\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoLong\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_LONG\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoLongRaw\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_LONG_RAW\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoRaw\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_RAW\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoRowId\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_ROWID\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoBoolean\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_BOOLEAN\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<procedure "
            + "name=\"echoBoolean2\" "
            + "catalogPattern=\"TEST_TYPES\" "
            + "procedurePattern=\"ECHO_BOOLEAN2\" "
            + "isSimpleXMLFormat=\"true\" "
            + "/>"
            + "<sql "
            + "name=\"selectXMLData\" "
            + "isSimpleXMLFormat=\"true\" "
            + ">"
            + "<text><![CDATA[select * from XMLTYPEDATA]]></text>"
            + "</sql>"
            + "</dbws-builder>";
    builder = new DBWSBuilder();
    DBWSTestSuite.setUp(".");
  }