Index: src/main/java/com/napa/pulse/dao/impl/HubSpokeNetworkDAOImpl.java =================================================================== diff -u -r97cf21c6460bdd57fe64f792b7e8fe9e95f6bc96 -rdefd456540f18f2d9b2cd5617ea3166871c7dbbf --- src/main/java/com/napa/pulse/dao/impl/HubSpokeNetworkDAOImpl.java (.../HubSpokeNetworkDAOImpl.java) (revision 97cf21c6460bdd57fe64f792b7e8fe9e95f6bc96) +++ src/main/java/com/napa/pulse/dao/impl/HubSpokeNetworkDAOImpl.java (.../HubSpokeNetworkDAOImpl.java) (revision defd456540f18f2d9b2cd5617ea3166871c7dbbf) @@ -1439,7 +1439,7 @@ public List getSpokeSiteIds ( Integer hubSiteId ) { List list = new ArrayList<> ( ); try { - String sql = "SELECT HS_NETWORK_SPOKE FROM HS_NETWORK_SPOKE WHERE NETWORK_HUB_ID = "+hubSiteId+" "; + String sql = "SELECT SPOKE_SITE_ID FROM HS_NETWORK_SPOKE WHERE NETWORK_HUB_ID = "+hubSiteId+" "; SqlRowSet rs = jdbcTemplate.queryForRowSet ( sql ); while (rs.next ( )) { list.add ( rs.getInt ( 1 ) );