No row with the given identifier exists:

[Zaw Aung]

I would like to avoid "No row with the given identifier exists:" exception.

I have two tables . MainTransaction and SubTransaction

MainTransaction Table has four fields

1.Transaction ID (Primary Key)
2.BranchID
3.BranchName
4.BranchAddress

BranchID and BranchName are foreinkey to link to SubTransaction Table..

SubTransaction Table has five fields

1.BranchID
2.BranchName
3.Location
4.Activity

BranchID and BranchName are composite id to link to MainTransaction Table.

Here are the Java Class Declarations....

public class MainTransaction {
	
	private String TransactionID;
	private String BranchID;
	private String BranchName; 
	private String BranchAddress;
	private SubTransaction subTran;
	
               //getter and setter method for properties.
	/**
	 * @return the subTran
	 */
	public SubTransaction getSubTran() {
		return subTran;
	}
	/**
	 * @param subTran the subTran to set
	 */
	public void setSubTran(SubTransaction subTran) {
		this.subTran = subTran;
	}
	
	
	

}

__________________________________________________________________________________--

public class SubTransaction {
	
	private SubTransactionPK subTransactionPK;
	private String Location;
	private String Activity;

	//getter and setter method for properties.	
	

}

____________________________________________________________________________________________________

public class SubTransactionPK  implements Serializable{
	
                private static final long serialVersionUID = 1L;

                private String BranchID;
	private String BranchName;

	//getter and setter method for properties.	
	

}

<many-to-one
        	name="subTran"
	    	class="SubTransaction"
	    	insert="false"
	    	update="false"
		>
    		<column name="BranchID" />
    		<column name="BranchName" />	
                               </many-to-one>

Here is relationship in the mapping file (MainTransaction.hbm.xml).. Mapping is okay. The problem is that I get the exception(No row with the given identifier exists
When I execute the "mainTransaction.getSubTran" getter method with no related record in subTransaction table. I do not want the exeception. I just want to check whether null or not and want to continue the program execution..

Here is codes that raise the exception

    

      Object objmainTransaction = session.get(MainTransaction .class,TransactionID);

       if (objmainTransaction != null){

           MainTransaction mainTransaction = (MainTransaction) objmainTransaction ;

            mainTransaction.getSubTran() ;     //// raise the exeception ( No row with the given identifier exists:)

     }

Please tell me if you have any idea......



With Regards......

[Balagopal Kannampallil]

Hi,

Please wrap your code inside the [code] tag to make it more readable so that we can save our time and help you better.

[Zaw Aung]

Ok..

[Amit Ghorpade]

"Raining Sky " please see your private messages for an important administrative matter.

[Javid Jamae]

Can you show us the mapping for SubTransaction?

[Zaw Aung]

Here is the mapping file for SubTransaction Table.. Just mapping to Table.. I want only unidirectional mapping.

  <?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="SubTransaction" 
    		table="SubTransaction"
    		dynamic-update="true"
    		dynamic-insert="true"
    		optimistic-lock="version"
	>

    	<composite-id name="subTransactionPK" class="SubTransactionPK">
        	<key-property 
            		name="BranchID" 
            		column="BranchID" 
            		type="java.lang.String"
            		length="11"
        	/>
        	
        	<key-property 
            		name="BranchName" 
            		column="BranchName" 
            		type="java.lang.String"
            		length="11"
        	/>
       		
       	</composite-id>    
  
    	<property
        	name="Location"
        	type="java.lang.String"
        	column="Location"
        	length="30"
    	/>
    	<property
        	name="Activity"
        	type="java.lang.String"
        	column="Activity"
        	length="20"
    	/>

  </class>
</hibernate-mapping>  

[Javid Jamae]

Can you show us the data in the two DB tables. Do all the FK's match up consistently between the tables?

Also, can you show me the entire error message. In particular, what comes after the colon?

[Zaw Aung]

Here is the error messages.. I know that there is no related record in SubTransaction table.. But I want to return null. I do not want to throw the exception.

org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [SubTransaction#SubTransactionPK@aa233f]
at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:79)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:68)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:150)

Note : There is no physical relationship between two tables.

[Javid Jamae]

When you define the <many-to-one> and point the <column> attributes to another table, you are defining a FK relationship. If that foreign key doesn't exist, then you can't have the values populated in the MainTransaction object. If they have no physical relationship, then don't map a Hibernate relationship between the two. You'll just have to load the data you need and manage the object relationship yourself.

[Zaw Aung]

Thanks a lot....

What you mean is that if there is physical relationship, the exeception can't throw even. Is it?