private Object assertQueryGeneratesSql(String query, String sql) { Sales sales = getSales(); Connection oldConnection = sales.getConnection(); StringWriter sw = new StringWriter(); PrintWriter pw = new PrintWriter(sw); Connection newConnection = createTracingConnection(oldConnection, pw); sales.setConnection(newConnection); Object o; try { o = runQuery(query); pw.flush(); String s = sw.toString(); assertTrue(s, s.indexOf(sql) >= 0); } finally { sales.setConnection(oldConnection); } return o; }