/** * @throws Exception * @tests java.sql.rowset.joinRowSet#getWhereClause() */ public void testGetWhereClause_MultipleCachedRowSet() throws Exception { String whereClause; // Creates another cached rowset. CachedRowSet crset2; crset2 = newNoInitialInstance(); crset2.setCommand("SELECT * FROM BOOKS"); crset2.setUrl(DERBY_URL); crset2.execute(); // Tests when there are on jdbcRowSet and one CachedRowSet. jrs.addRowSet(crset2, 1); jrs.addRowSet(crset, 1); if (System.getProperty("Testing Harmony") == "true") { whereClause = jrs.getWhereClause(); assertNotNull(whereClause); } else { try { whereClause = jrs.getWhereClause(); fail("Should throw NullPointerException."); } catch (NullPointerException e) { // Expected. } } crset.setTableName("Table1"); crset2.setTableName("Table2"); if (System.getProperty("Testing Harmony") == "true") { whereClause = jrs.getWhereClause(); assertNotNull(whereClause); } else { try { whereClause = jrs.getWhereClause(); fail("Should throw SQLException."); } catch (SQLException e) { // Expected. } } crset.setMatchColumn("ID"); crset2.setMatchColumn("AUTHORID"); whereClause = jrs.getWhereClause(); assertNotNull(whereClause); jrs = newJoinRowSet(); jrs.addRowSet(crset2, "AUTHORID"); jrs.addRowSet(crset, "ID"); whereClause = jrs.getWhereClause(); assertNotNull(whereClause); crset2.close(); }
/** * @throws Exception * @tests java.sql.rowset.joinRowSet#getWhereClause() */ public void testGetWhereClause_MoreRowSets() throws Exception { crset.setTableName("Table1"); jrs.addRowSet(crset, "ID"); // Creates another cached rowset. CachedRowSet crset2; crset2 = newNoInitialInstance(); crset2.setCommand("SELECT * FROM BOOKS"); crset2.setUrl(DERBY_URL); crset2.execute(); crset2.setTableName("Table2"); jrs.addRowSet(crset2, "AUTHORID"); crset2 = newNoInitialInstance(); crset2.setCommand("SELECT * FROM BOOKS"); crset2.setUrl(DERBY_URL); crset2.execute(); crset2.setTableName("Table3"); jrs.addRowSet(crset2, "AUTHORID"); String whereClause = jrs.getWhereClause(); assertNotNull(whereClause); }