// add a provider to databse
public boolean addProvider(Provider sp) {
logger.debug("addProvider start");
Session session = HibernateUtil.getSessionFactory().openSession();
ProviderDAO khDAO = new ProviderDAOImpl();
Transaction transaction = null;
try {
transaction = session.beginTransaction();
session.save(sp);