Nika Gudge
asked on
how to insert a record in database using hiberante
After the update on UI im able to update the table with the changes. But before update I want to insert the original record into some other table. But this gives me error.
My code:
public void updateSubscription( SubscriptionDTO subscription) throws EJBException {
SubscriptionDAO subscriptionDAO = new HibernateSubscriptionDAO() ;
transferOriginalTxn( subscription);
// im able to update the subscription table
try{
subscriptionDAO.update( subscription);
}catch(Exception e){
log.debug(e);
}
}
public void transferOriginalTxn ( SubscriptionDTO subscription) throws EJBException {
log.debug("Inside transferOriginalTxn");
SubscriptionDAO subscriptionDAO = new HibernateSubscriptionDAO() ;
SubscriptionDTO dto = subscriptionDAO.findByMerc hantRef(su bscription .getMercha ntref());
SubscriptionHistoryDTO subsHistory = new SubscriptionHistoryDTO();
subsHistory.setSubscriptio nid(dto.ge tId());
subsHistory.setName(dto.ge tName());
subsHistory.setStartDate(d to.getStar tDate());
subsHistory.setEndDate(dto .getEndDat e());
SubscriptionHistoryDAO subscriptionHistoryDAO = new HibernateSubscriptionHisto ryDAO();
try{
subscriptionHistoryDAO.cre ate( subsHistory);
}catch(Exception e){
log.debug(e);
}
}
// HibernateSubscriptionHisto ryDAO code
//im not able to save the record in subscriptionHistory table
public void create(SubscriptionHistory DTO dto) {
Session session = ServiceLocator.getHibernat eSession( HIBERNATE_SESSION_FACTORY) ;
session.save(dto);
}
error:
2012-04-04 09:44:55,729 DEBUG [http-127.0.0.1-8080-1] [com.merchant.ejb.Subscrip tionBean] - org.hibernate.exception.SQ LGrammarEx ception: could not insert: [com.merchant.dto.Subscrip tionHistor yDTO]
My code:
public void updateSubscription( SubscriptionDTO subscription) throws EJBException {
SubscriptionDAO subscriptionDAO = new HibernateSubscriptionDAO()
transferOriginalTxn( subscription);
// im able to update the subscription table
try{
subscriptionDAO.update( subscription);
}catch(Exception e){
log.debug(e);
}
}
public void transferOriginalTxn ( SubscriptionDTO subscription) throws EJBException {
log.debug("Inside transferOriginalTxn");
SubscriptionDAO subscriptionDAO = new HibernateSubscriptionDAO()
SubscriptionDTO dto = subscriptionDAO.findByMerc
SubscriptionHistoryDTO subsHistory = new SubscriptionHistoryDTO();
subsHistory.setSubscriptio
subsHistory.setName(dto.ge
subsHistory.setStartDate(d
subsHistory.setEndDate(dto
SubscriptionHistoryDAO subscriptionHistoryDAO = new HibernateSubscriptionHisto
try{
subscriptionHistoryDAO.cre
}catch(Exception e){
log.debug(e);
}
}
// HibernateSubscriptionHisto
//im not able to save the record in subscriptionHistory table
public void create(SubscriptionHistory
Session session = ServiceLocator.getHibernat
session.save(dto);
}
error:
2012-04-04 09:44:55,729 DEBUG [http-127.0.0.1-8080-1] [com.merchant.ejb.Subscrip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
provide some more details,share your mappings with stack trace