Getting same record in query.

[pankaj semwal]

Hi List,
When i run the query in oracle prompt its show two different record.But when i try to get the records in the view page its show same records i.e
same rows more than one.

My HBM file:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="hmil.com.setup.model.Menu" table="CCSMNMST_TB">
		<composite-id>		 
			<key-property name="MNMST_CMPN_NO"    type="java.lang.String" ></key-property>	
			<key-property name="MNMST_CORP_NO"  type="java.lang.String" ></key-property>	     
		</composite-id>
		<property name="MNMST_IS_MENU" type="java.lang.String"
				  not-null="true" />
		<property name="MNMST_MS_NAME" type="java.lang.String"
				  length="20" not-null="true" />	
		<property name="MNMST_MENU_DESCP" type="java.lang.String"
				  length="20"   />		 
		<property name="MNMST_PARENT_NAME" type="java.lang.String" />
		<property name="MNMST_CRTE_USR_NO" type="java.lang.String"
				  not-null="true" />
		<property name="MNMST_UPDT_USR_NO" type="java.lang.String"
				  not-null="true" />
		<property name="MNMST_CRTE_TIME" type="java.sql.Timestamp"
				  not-null="true" />
		<property name="MNMST_UPDT_TIME" type="java.sql.Timestamp"
				  not-null="true" />

	</class>

 

</hibernate-mapping>

My POJO Class is

public class Menu implements Serializable
{

	/**
	 * 
	 */
	private static final long serialVersionUID = -5784860460129642450L;
	
	private String MNMST_CMPN_NO;
	private String MNMST_CORP_NO;
	private String MNMST_IS_MENU;
	private String MNMST_MS_NAME;
	private String MNMST_MENU_DESCP;
	private String MNMST_PARENT_NAME;
	private String MNMST_CRTE_USR_NO;
	private String MNMST_UPDT_USR_NO;
	private Timestamp MNMST_CRTE_TIME;
	private Timestamp MNMST_UPDT_TIME;
	public Menu() {
		super();
		// TODO Auto-generated constructor stub
	}
	 
	public String getMNMST_IS_MENU()
	{
		return MNMST_IS_MENU;
	}
	public void setMNMST_IS_MENU(String mnmst_is_menu)
	{
		MNMST_IS_MENU = mnmst_is_menu;
	}
	public String getMNMST_MS_NAME()
	{
		return MNMST_MS_NAME;
	}
	public void setMNMST_MS_NAME(String mnmst_ms_name)
	{
		MNMST_MS_NAME = mnmst_ms_name;
	}
	 
	public String getMNMST_MENU_DESCP()
	{
		return MNMST_MENU_DESCP;
	}
	public void setMNMST_MENU_DESCP(String mnmst_menu_descp)
	{
		MNMST_MENU_DESCP = mnmst_menu_descp;
	}
	public String getMNMST_PARENT_NAME()
	{
		return MNMST_PARENT_NAME;
	}
	public void setMNMST_PARENT_NAME(String mnmst_parent_name)
	{
		MNMST_PARENT_NAME = mnmst_parent_name;
	}
	public String getMNMST_CRTE_USR_NO()
	{
		return MNMST_CRTE_USR_NO;
	}
	public void setMNMST_CRTE_USR_NO(String mnmst_crte_usr_no)
	{
		MNMST_CRTE_USR_NO = mnmst_crte_usr_no;
	}
	public String getMNMST_UPDT_USR_NO()
	{
		return MNMST_UPDT_USR_NO;
	}
	public void setMNMST_UPDT_USR_NO(String mnmst_updt_usr_no)
	{
		MNMST_UPDT_USR_NO = mnmst_updt_usr_no;
	}
	public Timestamp getMNMST_CRTE_TIME()
	{
		return MNMST_CRTE_TIME;
	}
	public void setMNMST_CRTE_TIME(Timestamp mnmst_crte_time)
	{
		MNMST_CRTE_TIME = mnmst_crte_time;
	}
	public Timestamp getMNMST_UPDT_TIME()
	{
		return MNMST_UPDT_TIME;
	}
	public void setMNMST_UPDT_TIME(Timestamp mnmst_updt_time)
	{
		MNMST_UPDT_TIME = mnmst_updt_time;
	}
	public static long getSerialVersionUID()
	{
		return serialVersionUID;
	}

	public String getMNMST_CMPN_NO() {
		return MNMST_CMPN_NO;
	}

	public void setMNMST_CMPN_NO(String mnmst_cmpn_no) {
		MNMST_CMPN_NO = mnmst_cmpn_no;
	}

	public String getMNMST_CORP_NO() {
		return MNMST_CORP_NO;
	}

	public void setMNMST_CORP_NO(String mnmst_corp_no) {
		MNMST_CORP_NO = mnmst_corp_no;
	}


}

I am calling like this

public List<Menu> findByName(String menuName, String isMenu) throws SystemException
	{

 

		List result = null;
		try
		{

			Criteria criteria = getSession().createCriteria(Menu.class);
			if (menuName != null && menuName.trim().length() > 0)
			{
				criteria.add(Restrictions.ilike("MNMST_MS_NAME", menuName + "%"));
			}
		

				criteria.add(Restrictions.eq("MNMST_IS_MENU", isMenu));

			result = criteria.list();
			
			System.out.println(((Menu)result.get(0)).getMNMST_MENU_DESCP());
			System.out.println(((Menu)result.get(1)).getMNMST_MENU_DESCP());
			 
			System.out.println(result.size());
			
			 

		} catch (Exception e)
		{
			logException(this, e);
			throw new SystemException(e, "Error Occured While Fetching Data");
		} finally
		{

			clear();

		}
		return result;
	}

Pl help me where is the mistake.

[Waswani Naresh]

The number of records that you are getting from the Query execution via Hibernate and from console are same, the only difference is the values of the row ? Is that correct ?

I did not find definition of clear(); what is the role of this method in the finally block ?

Have you tried wrapping your query execution with in transaction limits ? I know it does not make much sense here because you are getting some records fetched, but please try that once.

Also, could you paste the outcome of the System.out.println statements and the one that you are getting from the console.


Regards,
Naresh Waswani

[pankaj semwal]

Hi,
Records count is coming same.But rows value repeating.

Hibernate generate the sql like this:

SELECT this_.mnmst_cmpn_no AS mnmst1_9_0_, this_.mnmst_corp_no AS mnmst2_9_0_,
       this_.mnmst_is_menu AS mnmst3_9_0_, this_.mnmst_ms_name AS mnmst4_9_0_,
       this_.mnmst_menu_descp AS mnmst5_9_0_,
       this_.mnmst_parent_name AS mnmst6_9_0_,
       this_.mnmst_crte_usr_no AS mnmst7_9_0_,
       this_.mnmst_updt_usr_no AS mnmst8_9_0_,
       this_.mnmst_crte_time AS mnmst9_9_0_,
       this_.mnmst_updt_time AS mnmst10_9_0_
  FROM ccsmnmst_tb this_
 WHERE this_.mnmst_is_menu = 'Y'

And in sql console the output coming like this

MNMST1_9_0_	MNMST2_9_0_	MNMST3_9_0_	MNMST4_9_0_	MNMST5_9_0_	MNMST6_9_0_	MNMST7_9_0_	MNMST8_9_0_	MNMST9_9_0_	MNMST10_9_0_

H	A10AA	Y	S	Setup		kannan	kannan	6/27/2011 1:00:00 AM	6/27/2011 1:00:00 AM
H	A10AA	Y	B	Barcode		kannan	kannan	5/20/2011 11:00:00 PM	5/20/2011 11:00:00 PM

But when i put

System.out.println(((Menu)result.get(0)).getMNMST_MENU_DESCP());  
            System.out.println(((Menu)result.get(1)).getMNMST_MENU_DESCP());  

Its prints two value Setup and Setup in java console.It should print Setup and Barcode.

I used clear(); to clear the hibernate session.