Not able to find the added record in table.

[Mike Thomson]

I am developing a web application with Struts, Spring and Hibernate with JBoss 4.4.2 GA app server and MySQL.
I have a strange issue. I am just filling up the form and submitted for storing in DB and I can able to see the insert query (hibenate) in console and success message.
When I quering at table, that record is not found. I am again tried to fill up the form with different data and submitted and wehn I queried the table, I can able to see the old record which I have filled previously , but the new one is not found.
Like wise, whenever I am filling up the form and submitted, I can able to see the old record and but the newly added one is NOT found.
any parameter/configuration setting needs to be done for this

For Example:

adding emp id: 1

emp table:
=========
No data

adding emp id: 2

emp table:
=========
1


adding emp id: 3

emp table:
=========
1
2

    
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
	<property name="connection.username">root</property>
	<property name="connection.url">
		jdbc:mysql://localhost/mysql
	</property>
	<property name="dialect">
		org.hibernate.dialect.MySQLDialect
	</property>
	<property name="myeclipse.connection.profile">
		MySQL Connector for MDD
	</property>
	<property name="connection.password">example</property>
	<property name="connection.driver_class">
		com.mysql.jdbc.Driver
	</property>
	<property name="show_sql">true</property>
	<property name="format_sql">true</property>
	<property name="use_sql_comments">true</property>
	<mapping resource="com/mdd/web/dataservices/hbm/Bank.hbm.xml" />
	<mapping resource="com/mdd/web/dataservices/hbm/User.hbm.xml" />
</session-factory>

</hibernate-configuration>

    

	<bean id="orderService1" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">	
		<property name="transactionManager"><ref local="myTransactionManager"/></property>
		<property name="target"><ref local="userService"/></property>
		<property name="transactionAttributes">
			<props>
				<prop key="find*">PROPAGATION_REQUIRED,readOnly,-OrderException</prop>
				<prop key="save*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
			</props>
		</property>
	</bean>	

	<bean id="userDao" class="com.mdd.web.dataservices.UserDAOImpl">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>

	<bean id="userHelper" class="com.mdd.web.helper.UserHelper"/>

	<bean id="userService" class="com.mdd.web.bizservices.UserServiceImpl">
		<property name="userDao">
			<ref bean="userDao"/>
		</property>
		<property name="userHelper">
			<ref bean="userHelper"/>
		</property>
	</bean>

[Mark Spritzler]

Has the insert been commited? Looks like you are querying the table from outside the transaction before it has been commited. And since the Transaction is isolated, only inside the transaction would you see the record, until after it has been commited.

Mark

[Mike Thomson]

Mark,

Actually the insertion is happening inside the transaction and also commit it. I am checking the DB directly using MySQL Client to check whether it has been inserted or not. I am not checking(select query) it in hibernate txn.
I will send the coding shortly. thanks.

[Mark Spritzler]

That's kind of what I meant, since you are checking outside the code, you are looking before the transaction has been committed, and therefore isolated to inside the transaction, and outside it is isolated from seeing it.

Mark

[Mike Thomson]

HI Mark,

Below is the coding I am using for DAO. In that, I am staring the transaction, save it to DB and also commiting the txn and the control return backs to struts action and forward it to jsp. How to know whether the transaction is completed or not? I have attached the log from the console. Please advice.
Now, whatever I am saving is not storing in DB. I could able to see the hibernate insert query, but it's not storing in DB.

public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {
    public UserPojo saveDbUser(UserPojo user) {
	Transaction tx = getSession().beginTransaction();
	getHibernateTemplate().save(user);
	tx.commit();
	return user;
    }
}

22:55:40,781 INFO  [STDOUT] Hibernate: 
    /* insert com.mdd.web.pojo.UserPojo
        */ insert 
        into
            mdd.mdd_user
            (MDD_USER_LOGIN_ID, MDD_USER_PASSWORD, MDD_USER_FIRST_NAME, MDD_USER_LAST_NAME) 
        values
            (?, ?, ?, ?)
22:55:44,917 INFO  [STDOUT] Hibernate: 
    /* 
from
    UserPojo as userPojo 
where
    userPojo.mddUserLoginId= ? */ select
        userpojo0_.MDD_USER_ID as MDD1_1_,
        userpojo0_.MDD_USER_LOGIN_ID as MDD2_1_,
        userpojo0_.MDD_USER_PASSWORD as MDD3_1_,
        userpojo0_.MDD_USER_FIRST_NAME as MDD4_1_,
        userpojo0_.MDD_USER_LAST_NAME as MDD5_1_,
    from
        mdd.mdd_user userpojo0_ 
    where
        userpojo0_.MDD_USER_LOGIN_ID=?
22:55:44,957 INFO  [STDOUT] list ::[]
22:55:45,104 INFO  [STDOUT] 22:55:45,104 INFO  [PropertyMessageResources] Operating in Default mode [null]

[Mark Spritzler]

What version of Hibernate are you using? Are you using 2.x? If so, then what I say here you can ignore, but if you are using Hibernate 3.x...

"HibernateDaoSupport" was created for older versions of Hibernate to help with a few things and to work with the HibernateTemplate. In Hibernate 3.x, these classes should not be used.
1) They tie your code (tightly coupled) to Spring specific classes because you are extending one of their classes.
2) You no longer have to manage transactions yourself.
3) Hibernate SessionFactory now has getCurrentSession(), which returns a Session that is tied to your ThreadLocal, so now Transactional boundaries can be placed in their best corresponding location, at your service level.

code can now look like

  
@Service
public class MyServiceClass implements MyService {

    @Autowired
    MyRepository myRepository;

    @Transactional
    public UserPojo saveUserPojo(UserPojo pojo) {
        UserPojo recentlySaved = myRepository.saveUserPojo(pojo);
    }
}

public MyRepositoryImpl implements MyRepository {
    @Autowired SessionFactory sessionFactory;

    public UserPojo saveUserPojo(UserPojo pojo) {
        Session session = sessionFactory.getCurrentSession();
         session.saveOrUpdate(pojo);
        return pojo;
    }
}
  

Now I wouldn't have the saveUserPojo method return a UserPojo, because all you are doing is returning the parameter. which you already have a reference to in your calling code.

Mark

[Mike Thomson]

Mark,

Yes, I am using hibernate 3.0. I will try to do as per your suggestion though I am new to annotations. thanks for your help. I will come back if I have any doubts,

[Mark Spritzler]

Mike Thomson wrote:Mark,

Yes, I am using hibernate 3.0. I will try to do as per your suggestion though I am new to annotations. thanks for your help. I will come back if I have any doubts,

The code wouldn't change, but you can do everything I did with Annotations with xml, it is just more typing and to get something posted quickly I used annotations.

Mark

[Mike Thomson]

Mark,

I will try to use the Annotations as suggested by you and thanks for your help. Can you please help to suggest what went wrong in the below procedure ?
or can you please advice me some of the url/tutorial on how to use the annotations with the example?
I am struggling with the below insertion into db using Struts 1.3 - Spring 2 - Hibernate 3.0.
I can able to see the hibernate insert log in console, but while querying the db no record id found.
Please help to advice what is the issue in my below codings. I am suspecting the issuew is with the configuration.

UserAction
==========

   
public class UserAction extends BaseAction{

    @Override
    public ActionForward prepare(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest servletRequest,
	    HttpServletResponse servletResponse) throws Exception {
	
	return actionMapping.findForward(UserConstant.USER_PREPARE_FORWARD);
    }

    @Override
    public ActionForward process(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest servletRequest,
	    HttpServletResponse servletResponse) throws Exception {
	
	try{
        	UserForm userForm = (UserForm)actionForm;	
        	UserService userService = (UserService)ServiceFinder.getContext(servletRequest).getBean("userService");
        	UserHelper userHelper = userService.getUserHelper();
        	UserPojo userPojo = userHelper.setFormToPojo(userForm);
        	userService.saveBizUser(userPojo);	
        	
        	List list = userService.findByBizUserId(userPojo);
        	System.out.println("list ::"+list);
        	Iterator it = list.iterator();
        	while(it.hasNext()){
        	    UserPojo up = (UserPojo)it.next();
        	    System.out.println(up.getMddUserAddress1());
        	}
        	
        	return actionMapping.findForward(UserConstant.USER_SUCSESS);
	}catch(Exception e){
	    e.printStackTrace();
	    return actionMapping.findForward(UserConstant.USER_FAILURE);
	}	
    }

}
 

UserService:
=============

public class UserServiceImpl implements UserService{
    
    private UserDAO userDao;
    private UserHelper userHelper;
    
    public UserDAO getUserDao() {
	// TODO Auto-generated method stub
	return userDao;
    }

    public void setUserDao(UserDAO userDao) {
	// TODO Auto-generated method stub
	this.userDao = userDao;
    }

    public UserHelper getUserHelper() {
	// TODO Auto-generated method stub
	return userHelper;
    }

    public void setUserHelper(UserHelper userHelper) {
	// TODO Auto-generated method stub
	this.userHelper = userHelper;
    }
    
    public UserPojo saveBizUser(UserPojo user){
	// TODO Auto-generated method stub
	return userDao.saveDbUser(user);
    }
    
    public List findByBizUserId(UserPojo user){	
	return userDao.findByUserId("mddUserLoginId", "hello");
    }
    

}
[code]

UserDAO:
========
[code]
public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {
    public UserPojo saveDbUser(UserPojo user) {
	Transaction tx = getSession().beginTransaction();
	getHibernateTemplate().save(user);
	tx.commit();
	return user;
    }

    public List findByUserId(String propertyName, Object value) {
	try {
	    String queryString = "from UserPojo as userPojo where userPojo." + propertyName + "= ?";
	    Query queryObject = getSession().createQuery(queryString);
	    queryObject.setParameter(0, value);
	    return queryObject.list();
	} catch (RuntimeException re) {	    
	    throw re;
	}
	//return null;
    }

}

UserHelper:
===========

public class UserHelper {
  public UserPojo setFormToPojo(ActionForm form){
      UserForm userForm = (UserForm)form;
      UserPojo userPojo = new UserPojo();      
      
      userForm.setMddUserCreatedTmpsmp(new Timestamp(System.currentTimeMillis())+"");
      userForm.setMddUserModifiedTmpsmp(new Timestamp(System.currentTimeMillis())+"");     
      
      // copying the properties from Struts Form to POJO
      BeanUtils.copyProperties(userForm, userPojo);       
     // userPojo.setMddUserId(null);
      System.out.println("aaa"+userPojo.getMddUserMotherName());
      
      return userPojo;
  }
}

applicationContext:
===================

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">


	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<!--<property name="configLocation"
			value="classpath:hibernate.cfg.xml">
		-->
		
		<property name="configLocation"
			value="/WEB-INF/hibernate.cfg.xml">			
		</property>
	</bean>
	
	<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
	<bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory"><ref local="sessionFactory"/></property>
	</bean>
	
    <!-- ************  USER SERVICES - STARTS HERE ************ -->

	<bean id="orderService1" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">	
		<property name="transactionManager"><ref local="myTransactionManager"/></property>
		<property name="target"><ref local="userService"/></property>
		<property name="transactionAttributes">	
			<props>
				<prop key="find*">PROPAGATION_REQUIRED</prop>
				<prop key="save*">PROPAGATION_REQUIRED</prop>
			</props>			
		</property>	
	</bean>	

	<bean id="userDao" class="com.mdd.web.dataservices.UserDAOImpl">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>

	<bean id="userHelper" class="com.mdd.web.helper.UserHelper"/>

	<bean id="userService" class="com.mdd.web.bizservices.UserServiceImpl">
		<property name="userDao">
			<ref bean="userDao"/>
		</property>
		<property name="userHelper">
			<ref bean="userHelper"/>
		</property>
	</bean>


    <!-- ************  USER SERVICES - ENDS HERE ************ -->

	
</beans>

hibernate.cfg.xml:
===================

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
	<property name="connection.username">root</property>
	<property name="connection.url">jdbc:mysql://localhost/mysql</property>
	<property name="dialect">
		org.hibernate.dialect.MySQLDialect
	</property>
	<property name="myeclipse.connection.profile">
		MySQL Connector for MDD
	</property>
	<property name="connection.password">test</property>
	<property name="connection.driver_class">
		com.mysql.jdbc.Driver
	</property>
	<property name="show_sql">true</property>
	<property name="format_sql">true</property>
	<property name="use_sql_comments">true</property>
	<mapping resource="com/mdd/web/dataservices/hbm/Bank.hbm.xml" />
	<mapping resource="com/mdd/web/dataservices/hbm/User.hbm.xml" />
</session-factory>

</hibernate-configuration>

User.hbm.xml:
==============

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.mdd.web.pojo.UserPojo" table="mdd_user" catalog="mdd">
        <id name="mddUserId" type="java.lang.Integer">
            <column name="MDD_USER_ID" />
             <generator class="identity"/>
        </id>
        <property name="mddUserLoginId" type="java.lang.String">
            <column name="MDD_USER_LOGIN_ID" length="25" not-null="true" unique="true" />
        </property>
        <property name="mddUserPassword" type="java.lang.String">
            <column name="MDD_USER_PASSWORD" length="50" not-null="true" />
        </property>
        <property name="mddUserFirstName" type="java.lang.String">
            <column name="MDD_USER_FIRST_NAME" length="75" not-null="true" />
        </property>
        <property name="mddUserLastName" type="java.lang.String">
            <column name="MDD_USER_LAST_NAME" length="75" not-null="true" />
        </property>
        <property name="mddUserGender" type="java.lang.String">
            <column name="MDD_USER_GENDER" length="1" not-null="true" />
        </property>
        <property name="mddUserAddress1" type="java.lang.String">
            <column name="MDD_USER_ADDRESS1" length="250" not-null="true" />
        </property>
        <property name="mddUserAddress2" type="java.lang.String">
            <column name="MDD_USER_ADDRESS2" length="250" not-null="true" />
        </property>
        <property name="mddUserAddress3" type="java.lang.String">
            <column name="MDD_USER_ADDRESS3" length="250" not-null="true" />
        </property>
        <property name="mddUserCity" type="java.lang.String">
            <column name="MDD_USER_CITY" length="100" not-null="true" />
        </property>
        <property name="mddUserState" type="java.lang.String">
            <column name="MDD_USER_STATE" length="100" not-null="true" />
        </property>
        <property name="mddUserCountry" type="java.lang.String">
            <column name="MDD_USER_COUNTRY" length="100" not-null="true" />
        </property>
        <property name="mddUserPostalCode" type="java.lang.String">
            <column name="MDD_USER_POSTAL_CODE" length="100" not-null="true" />
        </property>
        <property name="mddUserEmailid" type="java.lang.String">
            <column name="MDD_USER_EMAILID" length="100" />
        </property>
        <property name="mddUserPhone" type="java.lang.String">
            <column name="MDD_USER_PHONE" length="45" />
        </property>
        <property name="mddUserMobile" type="java.lang.String">
            <column name="MDD_USER_MOBILE" length="45" />
        </property>
        <property name="mddUserUrl" type="java.lang.String">
            <column name="MDD_USER_URL" length="250" />
        </property>
        <property name="mddUserDob" type="java.lang.String">
            <column name="MDD_USER_DOB" length="10" not-null="true" />
        </property>
        <property name="mddUserMotherName" type="java.lang.String">
            <column name="MDD_USER_MOTHER_NAME" length="75" not-null="true" />
        </property>
        <property name="mddUserSecretQue" type="java.lang.String">
            <column name="MDD_USER_SECRET_QUE" length="250" not-null="true" />
        </property>
        <property name="mddUserSecretAns" type="java.lang.String">
            <column name="MDD_USER_SECRET_ANS" length="250" not-null="true" />
        </property>
        <property name="mddUserStatus" type="java.lang.String">
            <column name="MDD_USER_STATUS" length="1" not-null="true" />
        </property>
        <property name="mddUserPhoto" type="java.lang.String">
            <column name="MDD_USER_PHOTO" />
        </property>
        <property name="mddUserRemarks" type="java.lang.String">
            <column name="MDD_USER_REMARKS" length="250" />
        </property>
        <property name="mddUserCreatedTmpsmp" type="java.lang.String">
            <column name="MDD_USER_CREATED_TMPSMP" length="19" not-null="true" />
        </property>
        <property name="mddUserModifiedTmpsmp" type="java.lang.String">
            <column name="MDD_USER_MODIFIED_TMPSMP" length="19" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

Table:
=======

CREATE TABLE  `mdd`.`mdd_user` (
  `MDD_USER_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `MDD_USER_LOGIN_ID` varchar(25) NOT NULL,
  `MDD_USER_PASSWORD` varchar(50) NOT NULL,
  `MDD_USER_FIRST_NAME` varchar(75) NOT NULL,
  `MDD_USER_LAST_NAME` varchar(75) NOT NULL,
  `MDD_USER_GENDER` varchar(1) NOT NULL,
  `MDD_USER_ADDRESS1` varchar(250) NOT NULL,
  `MDD_USER_ADDRESS2` varchar(250) NOT NULL,
  `MDD_USER_ADDRESS3` varchar(250) NOT NULL,
  `MDD_USER_CITY` varchar(100) NOT NULL,
  `MDD_USER_STATE` varchar(100) NOT NULL,
  `MDD_USER_COUNTRY` varchar(100) NOT NULL,
  `MDD_USER_POSTAL_CODE` varchar(100) NOT NULL,
  `MDD_USER_EMAILID` varchar(100) DEFAULT NULL,
  `MDD_USER_PHONE` varchar(45) DEFAULT NULL,
  `MDD_USER_MOBILE` varchar(45) DEFAULT NULL,
  `MDD_USER_URL` varchar(250) DEFAULT NULL,
  `MDD_USER_DOB` varchar(10) NOT NULL,
  `MDD_USER_MOTHER_NAME` varchar(75) NOT NULL,
  `MDD_USER_SECRET_QUE` varchar(250) NOT NULL,
  `MDD_USER_SECRET_ANS` varchar(250) NOT NULL,
  `MDD_USER_STATUS` varchar(1) NOT NULL,
  `MDD_USER_PHOTO` varchar(100) DEFAULT NULL,
  `MDD_USER_REMARKS` varchar(250) DEFAULT NULL,
  `MDD_USER_CREATED_TMPSMP` varchar(30) NOT NULL,
  `MDD_USER_MODIFIED_TMPSMP` varchar(30) NOT NULL,
  PRIMARY KEY (`MDD_USER_ID`),
  UNIQUE KEY `MDD_USER_LOGIN_ID` (`MDD_USER_LOGIN_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

Log:
====

22:52:40,374 INFO  [STDOUT] Hibernate: 
    /* insert com.mdd.web.pojo.UserPojo
        */ insert 
        into
            mdd.mdd_user
            (MDD_USER_LOGIN_ID, MDD_USER_PASSWORD, MDD_USER_FIRST_NAME, MDD_USER_LAST_NAME, MDD_USER_GENDER, MDD_USER_ADDRESS1, MDD_USER_ADDRESS2, MDD_USER_ADDRESS3, MDD_USER_CITY, MDD_USER_STATE, MDD_USER_COUNTRY, MDD_USER_POSTAL_CODE, MDD_USER_EMAILID, MDD_USER_PHONE, MDD_USER_MOBILE, MDD_USER_URL, MDD_USER_DOB, MDD_USER_MOTHER_NAME, MDD_USER_SECRET_QUE, MDD_USER_SECRET_ANS, MDD_USER_STATUS, MDD_USER_PHOTO, MDD_USER_REMARKS, MDD_USER_CREATED_TMPSMP, MDD_USER_MODIFIED_TMPSMP) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
22:52:42,964 INFO  [STDOUT] Hibernate: 
    /* 
from
    UserPojo as userPojo 
where
    userPojo.mddUserLoginId= ? */ select
        userpojo0_.MDD_USER_ID as MDD1_1_,
        userpojo0_.MDD_USER_LOGIN_ID as MDD2_1_,
        userpojo0_.MDD_USER_PASSWORD as MDD3_1_,
        userpojo0_.MDD_USER_FIRST_NAME as MDD4_1_,
        userpojo0_.MDD_USER_LAST_NAME as MDD5_1_,
        userpojo0_.MDD_USER_GENDER as MDD6_1_,
        userpojo0_.MDD_USER_ADDRESS1 as MDD7_1_,
        userpojo0_.MDD_USER_ADDRESS2 as MDD8_1_,
        userpojo0_.MDD_USER_ADDRESS3 as MDD9_1_,
        userpojo0_.MDD_USER_CITY as MDD10_1_,
        userpojo0_.MDD_USER_STATE as MDD11_1_,
        userpojo0_.MDD_USER_COUNTRY as MDD12_1_,
        userpojo0_.MDD_USER_POSTAL_CODE as MDD13_1_,
        userpojo0_.MDD_USER_EMAILID as MDD14_1_,
        userpojo0_.MDD_USER_PHONE as MDD15_1_,
        userpojo0_.MDD_USER_MOBILE as MDD16_1_,
        userpojo0_.MDD_USER_URL as MDD17_1_,
        userpojo0_.MDD_USER_DOB as MDD18_1_,
        userpojo0_.MDD_USER_MOTHER_NAME as MDD19_1_,
        userpojo0_.MDD_USER_SECRET_QUE as MDD20_1_,
        userpojo0_.MDD_USER_SECRET_ANS as MDD21_1_,
        userpojo0_.MDD_USER_STATUS as MDD22_1_,
        userpojo0_.MDD_USER_PHOTO as MDD23_1_,
        userpojo0_.MDD_USER_REMARKS as MDD24_1_,
        userpojo0_.MDD_USER_CREATED_TMPSMP as MDD25_1_,
        userpojo0_.MDD_USER_MODIFIED_TMPSMP as MDD26_1_ 
    from
        mdd.mdd_user userpojo0_ 
    where
        userpojo0_.MDD_USER_LOGIN_ID=?
22:52:43,012 INFO  [STDOUT] list ::[]

[Mike Thomson]

Can anyone help on this? Is there any issue with applicationContext/hibernate.cfg.xml or in some where else?
My issue is, it's not getting stored in DB but I am not getting any error/exception. PLease help to advice. thanks.

[Mark Spritzler]

Is that the console log, or the actual
Tomcat" log, which has more detail?

There must be some rollback happening in your code, maybe an exception that is in the server's log file and not the console.



Are you stuck with using Hibernate 3.0 instead of a newer version?

Also, you are using the HibernateTemplate and HibernateDaoSupport, which I would use for Hibernate 2.x but not for Hibernate 3.x

With 3.x I just inject the SessionFactory into the Repository/DAO and call getCurrentSession(). and call methods on Session. You no longer have to do sessio.beginTransation() commit() or rollback() the transaction manager handles that for you. But that isn't something you should change to right now, just so that you can see it save.

Mark

[Mike Thomson]

I am using JBoss 4.2.2GA and I couldn't able to see any exception/error in server.log/jboss console. Only for the runtime exception the txn will rollback and how could any exception/error log found?

    
2009-11-04 22:20:26,782 DEBUG [org.jboss.web.tomcat.service.TomcatDeployer] Using session cookies default setting
2009-11-04 22:20:28,296 DEBUG [org.jboss.web.tomcat.filters.ReplyHeaderFilter] Adding header name: X-Powered-By='Servlet 2.4; JBoss-4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)/Tomcat-5.5'
2009-11-04 22:20:28,959 INFO  [org.apache.struts.action.ActionServlet] Loading chain catalog from jar:file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/tmp/deploy/tmp41551struts-examples-1.3.10-exp.war/WEB-INF/lib/struts-core-1.3.10.jar!/org/apache/struts/chain/chain-config.xml
2009-11-04 22:20:34,117 WARN  [org.apache.struts.config.impl.ModuleConfigImpl] Overriding ActionForm of name localeForm
2009-11-04 22:20:34,257 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/org/apache/struts/validator/validator-rules-compressed.xml'
2009-11-04 22:20:34,272 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator/validation.xml'
2009-11-04 22:20:34,332 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator/validation-bundles.xml'
2009-11-04 22:20:34,384 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator/validation-i18nVariables.xml'
2009-11-04 22:20:34,464 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator/validation-type.xml'
2009-11-04 22:20:34,477 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator/validation-validwhen.xml'
2009-11-04 22:20:40,307 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/org/apache/struts/validator/validator-rules.xml'
2009-11-04 22:20:40,316 INFO  [org.apache.struts.validator.ValidatorPlugIn] Loading validation rules file from '/WEB-INF/upload/validation.xml'
2009-11-04 22:20:41,404 DEBUG [org.jboss.web.tomcat.service.TomcatDeployer] Initialized: {WebApplication: /C:/Mike/Server/jboss-4.2.2.GA/server/default/tmp/deploy/tmp41551struts-examples-1.3.10-exp.war/, URL: file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/tmp/deploy/tmp41551struts-examples-1.3.10-exp.war/, classLoader: java.net.FactoryURLClassLoader@8a1c9d:9051293} jboss.web:j2eeType=WebModule,name=//localhost/struts-examples-1.3.10,J2EEApplication=none,J2EEServer=none
2009-11-04 22:20:41,409 DEBUG [org.jboss.web.WebModule] Started jboss.web.deployment:war=struts-examples-1.3.10.war,id=-1361445987
2009-11-04 22:20:41,409 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.web.deployment:war=struts-examples-1.3.10.war,id=-1361445987 dependent components: []
2009-11-04 22:20:41,528 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: struts-examples-1.3.10.war
2009-11-04 22:20:41,528 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/deploy/struts-examples-1.3.10.war
2009-11-04 22:20:41,529 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/deploy/struts-examples-1.3.10.war -> file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/deploy/struts-examples-1.3.10.war
2009-11-04 22:20:41,577 DEBUG [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Notified that enabled: true
2009-11-04 22:20:41,577 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
2009-11-04 22:20:41,636 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.deployment:type=DeploymentScanner,flavor=URL dependent components: []
2009-11-04 22:20:42,444 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: jboss-service.xml
2009-11-04 22:20:42,444 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Mike/Server/jboss-4.2.2.GA/server/default/conf/jboss-service.xml
2009-11-04 22:20:42,555 DEBUG [org.jboss.web.tomcat.service.JBossWeb] Saw org.jboss.system.server.started notification, starting connectors
2009-11-04 22:20:42,717 INFO  [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
2009-11-04 22:20:43,033 INFO  [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
2009-11-04 22:20:43,269 INFO  [org.jboss.system.server.Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 4m:14s:838ms
2009-11-04 22:20:43,354 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] Periodic recovery - first pass <Wed, 4 Nov 2009 22:20:43>
2009-11-04 22:20:43,354 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] StatusModule: first pass 
2009-11-04 22:20:43,355 DEBUG [com.arjuna.ats.txoj.logging.txojLoggerI18N] [com.arjuna.ats.internal.txoj.recovery.TORecoveryModule_3] - TORecoveryModule - first pass
2009-11-04 22:20:43,360 DEBUG [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.recovery.info.firstpass] Local XARecoveryModule - first pass
2009-11-04 22:20:53,379 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] Periodic recovery - second pass <Wed, 4 Nov 2009 22:20:53>
2009-11-04 22:20:53,379 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] AtomicActionRecoveryModule: Second pass 
2009-11-04 22:20:53,380 DEBUG [com.arjuna.ats.txoj.logging.txojLoggerI18N] [com.arjuna.ats.internal.txoj.recovery.TORecoveryModule_6] - TORecoveryModule - second pass
2009-11-04 22:20:53,380 DEBUG [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.recovery.info.secondpass] Local XARecoveryModule - second pass
2009-11-04 22:21:02,788 INFO  [STDOUT] 22:21:02,788 INFO  [ComposableRequestProcessor] Initializing composable request processor for module prefix ''
2009-11-04 22:21:03,560 INFO  [STDOUT] 22:21:03,560 INFO  [CreateAction] Initialize action of type: com.mdd.web.action.UserAction
2009-11-04 22:21:05,329 INFO  [STDOUT] 22:21:05,327 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,373 INFO  [STDOUT] 22:21:05,373 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,494 INFO  [STDOUT] 22:21:05,494 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,494 INFO  [STDOUT] 22:21:05,494 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,530 INFO  [STDOUT] 22:21:05,530 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,546 INFO  [STDOUT] 22:21:05,546 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,610 INFO  [STDOUT] 22:21:05,610 WARN  [PropertyMessageResources]   Resource com/mdd/web/resources/mddResources_en_en_US.properties Not Found.
2009-11-04 22:21:05,652 INFO  [STDOUT] 22:21:05,652 WARN  [PropertyMessageResources]   Resource com/mdd/web/resources/mddResources_en_en.properties Not Found.
2009-11-04 22:21:05,870 INFO  [STDOUT] 22:21:05,870 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,881 INFO  [STDOUT] 22:21:05,881 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,902 INFO  [STDOUT] 22:21:05,902 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:05,985 INFO  [STDOUT] 22:21:05,984 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:06,015 INFO  [STDOUT] 22:21:06,014 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:06,085 INFO  [STDOUT] 22:21:06,084 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:21:06,129 INFO  [STDOUT] 22:21:06,129 INFO  [PropertyMessageResources] Operating in Default mode [null]
2009-11-04 22:22:03,941 INFO  [STDOUT] aaasdfsf
2009-11-04 22:22:05,684 INFO  [STDOUT] Hibernate: 
    /* insert com.mdd.web.pojo.UserPojo
        */ insert 
        into
            mdd.mdd_user
            (MDD_USER_LOGIN_ID, MDD_USER_PASSWORD, MDD_USER_FIRST_NAME, MDD_USER_LAST_NAME, MDD_USER_GENDER, MDD_USER_ADDRESS1, MDD_USER_ADDRESS2, MDD_USER_ADDRESS3, MDD_USER_CITY, MDD_USER_STATE, MDD_USER_COUNTRY, MDD_USER_POSTAL_CODE, MDD_USER_EMAILID, MDD_USER_PHONE, MDD_USER_MOBILE, MDD_USER_URL, MDD_USER_DOB, MDD_USER_MOTHER_NAME, MDD_USER_SECRET_QUE, MDD_USER_SECRET_ANS, MDD_USER_STATUS, MDD_USER_PHOTO, MDD_USER_REMARKS, MDD_USER_CREATED_TMPSMP, MDD_USER_MODIFIED_TMPSMP) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-11-04 22:22:09,295 INFO  [STDOUT] Hibernate: 
    /* 
from
    UserPojo as userPojo 
where
    userPojo.mddUserLoginId= ? */ select
        userpojo0_.MDD_USER_ID as MDD1_1_,
        userpojo0_.MDD_USER_LOGIN_ID as MDD2_1_,
        userpojo0_.MDD_USER_PASSWORD as MDD3_1_,
        userpojo0_.MDD_USER_FIRST_NAME as MDD4_1_,
        userpojo0_.MDD_USER_LAST_NAME as MDD5_1_,
        userpojo0_.MDD_USER_GENDER as MDD6_1_,
        userpojo0_.MDD_USER_ADDRESS1 as MDD7_1_,
        userpojo0_.MDD_USER_ADDRESS2 as MDD8_1_,
        userpojo0_.MDD_USER_ADDRESS3 as MDD9_1_,
        userpojo0_.MDD_USER_CITY as MDD10_1_,
        userpojo0_.MDD_USER_STATE as MDD11_1_,
        userpojo0_.MDD_USER_COUNTRY as MDD12_1_,
        userpojo0_.MDD_USER_POSTAL_CODE as MDD13_1_,
        userpojo0_.MDD_USER_EMAILID as MDD14_1_,
        userpojo0_.MDD_USER_PHONE as MDD15_1_,
        userpojo0_.MDD_USER_MOBILE as MDD16_1_,
        userpojo0_.MDD_USER_URL as MDD17_1_,
        userpojo0_.MDD_USER_DOB as MDD18_1_,
        userpojo0_.MDD_USER_MOTHER_NAME as MDD19_1_,
        userpojo0_.MDD_USER_SECRET_QUE as MDD20_1_,
        userpojo0_.MDD_USER_SECRET_ANS as MDD21_1_,
        userpojo0_.MDD_USER_STATUS as MDD22_1_,
        userpojo0_.MDD_USER_PHOTO as MDD23_1_,
        userpojo0_.MDD_USER_REMARKS as MDD24_1_,
        userpojo0_.MDD_USER_CREATED_TMPSMP as MDD25_1_,
        userpojo0_.MDD_USER_MODIFIED_TMPSMP as MDD26_1_ 
    from
        mdd.mdd_user userpojo0_ 
    where
        userpojo0_.MDD_USER_LOGIN_ID=?
2009-11-04 22:22:09,340 INFO  [STDOUT] list ::[]
2009-11-04 22:22:10,023 INFO  [STDOUT] 22:22:10,023 INFO  [PropertyMessageResources] Operating in Default mode [null]