@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();
}
@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(".");
}