@Test
public void testCreatePropertyProviders() {

  SQLProviderModule providerModule = new SQLProviderModule();
  providerModule.createPropertyProviders(Resource.Type.Component);
  List<PropertyProvider> providers = providerModule.getPropertyProviders(Resource.Type.Component);
  Assert.assertTrue(providers.get(0) instanceof JMXPropertyProvider);
  Assert.assertTrue(providers.get(1) instanceof SQLPropertyProvider);
  providerModule.createPropertyProviders(Resource.Type.HostComponent);
  providers = providerModule.getPropertyProviders(Resource.Type.HostComponent);
  Assert.assertTrue(providers.get(0) instanceof JMXPropertyProvider);
  Assert.assertTrue(providers.get(1) instanceof SQLPropertyProvider);
}