Advertisement
Guest User

Untitled

a guest
Jul 5th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. try {
  2. String expectedQuery = DataDelta.queryReplace(queryTemplate, expectedVariables, dsn.toLowerCase().startsWith("jdbc:vertica"));
  3. String testQuery = DataDelta.queryReplace(queryTemplate, testVariables, dsn.toLowerCase().startsWith("jdbc:vertica"));
  4.  
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Class.forName("com.vertica.Driver");
  7.  
  8. Connection c1 = DriverManager.getConnection(dsn);
  9. Connection c2 = DriverManager.getConnection(dsn);
  10.  
  11. Statement statement1 = c1.createStatement();
  12. Statement statement2 = c2.createStatement();
  13.  
  14. DataDelta dd = new DataDelta();
  15. dd.computeDataDelta(statement1.executeQuery(expectedQuery),
  16. statement2.executeQuery(testQuery), keys,
  17. expectedVariables, testVariables);
  18. dd.setPrintStyle(DataDelta.PRINT_HTML);
  19. printPage(response, prop, null);
  20. response.getOutputStream().println("\n<b>Results</b><br><br>");
  21. dd.printResults(new PrintStream(response.getOutputStream()));
  22. printBottomPage(response);
  23. statement1.close();
  24. statement2.close();
  25. c1.close();
  26. c2.close();
  27. } catch (Exception e) {
  28. printPage(response, prop, null);
  29. response.getOutputStream().println("<b>Error!</b><br><blockquote><code>" + e.getMessage().toString() + "</code></blockquote>");
  30. printBottomPage(response);
  31. e.printStackTrace();
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement