Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- String expectedQuery = DataDelta.queryReplace(queryTemplate, expectedVariables, dsn.toLowerCase().startsWith("jdbc:vertica"));
- String testQuery = DataDelta.queryReplace(queryTemplate, testVariables, dsn.toLowerCase().startsWith("jdbc:vertica"));
- Class.forName("com.mysql.jdbc.Driver");
- Class.forName("com.vertica.Driver");
- Connection c1 = DriverManager.getConnection(dsn);
- Connection c2 = DriverManager.getConnection(dsn);
- Statement statement1 = c1.createStatement();
- Statement statement2 = c2.createStatement();
- DataDelta dd = new DataDelta();
- dd.computeDataDelta(statement1.executeQuery(expectedQuery),
- statement2.executeQuery(testQuery), keys,
- expectedVariables, testVariables);
- dd.setPrintStyle(DataDelta.PRINT_HTML);
- printPage(response, prop, null);
- response.getOutputStream().println("\n<b>Results</b><br><br>");
- dd.printResults(new PrintStream(response.getOutputStream()));
- printBottomPage(response);
- statement1.close();
- statement2.close();
- c1.close();
- c2.close();
- } catch (Exception e) {
- printPage(response, prop, null);
- response.getOutputStream().println("<b>Error!</b><br><blockquote><code>" + e.getMessage().toString() + "</code></blockquote>");
- printBottomPage(response);
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement