if (service == null) throw new ResourceNotFoundException();
String serviceName = service.getServiceName();
// if exists, remove from widget default table
IPersistenceManager persistenceManager = PersistenceManagerFactory.getPersistenceManager();
IWidgetDefault[] widgetDefaults = persistenceManager.findByValue(IWidgetDefault.class, "widgetContext", serviceName);
persistenceManager.delete(widgetDefaults);
// delete from the widget service table
persistenceManager.delete(service);
// remove any widgetTypes for each widget that match