private static final String ASSIGN_IP_SQL_STATEMENT =
"INSERT INTO IPAM_IP_ASSIGNEMENT (service_instance_id, vf_module_id, prefix_id, ip_address_id, ip_address, ip_status, ip_response_json, external_key) \n"
- + "VALUES (?, ?, ?, ?, ?, ?, ?)";
+ + "VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
private static final String UNASSIGN_IP_SQL_STATEMENT =
"UPDATE IPAM_IP_ASSIGNEMENT SET ip_status = ? WHERE service_instance_id = ? AND external_key = ?";
private static final String GET_IP_ADDRESS_ID_SQL_STATEMENT =
serviceInstanceId,
externalKey);
try (CachedRowSet row = dbLibService.getData(GET_IP_ADDRESS_ID_SQL_STATEMENT, args, null)) {
- ipAddressId = row.getString("ip_address_id");
+ if (row.next()) {
+ ipAddressId = row.getString("ip_address_id");
+ } else {
+ throw new SQLException("Data not found.");
+ }
} catch (SQLException e) {
LOG.error(SQL_EXCEPTION_MESSAGE, e);
return QueryStatus.FAILURE;
CachedRowSet crs = mock(CachedRowSet.class);
doReturn("3").when(crs).getString(eq("ip_address_id"));
+ doReturn(true).when(crs).next();
doReturn(crs).when(dbLib).getData(anyString(), any(ArrayList.class), eq(null));
QueryStatus status = netboxClientMock
CachedRowSet crs = mock(CachedRowSet.class);
doReturn("3").when(crs).getString(eq("ip_address_id"));
+ doReturn(true).when(crs).next();
doReturn(crs).when(dbLib).getData(anyString(), any(ArrayList.class), eq(null));
QueryStatus status = netboxClient.unassignIpAddress(params, svcLogicContext);
givenThat(delete(urlEqualTo(expectedUrl)).willReturn(created().withBody(response)));
CachedRowSet crs = mock(CachedRowSet.class);
+ doReturn(true).when(crs).next();
doReturn("3").when(crs).getString(eq("ip_address_id"));
doReturn(crs).when(dbLib).getData(anyString(), any(ArrayList.class), eq(null));
CachedRowSet crs = mock(CachedRowSet.class);
doReturn("3").when(crs).getString(eq("ip_address_id"));
+ doReturn(true).when(crs).next();
doReturn(crs).when(dbLib).getData(anyString(), any(ArrayList.class), eq(null));
QueryStatus status = netboxClient.unassignIpAddress(params, svcLogicContext);