Enforcing Forign Key constraints via Hibernate

[Ally Cavs]

Hi guys,

My main aim is to persist the web service objects. So changing the web service classes is not allowed. My hibernate mapping are configured to generate the DB.
So what I have is

public class Invoice {
    private int id;
    
    //foreign key against id field on purchaseOrder table
    private int purchaseOrderID;
    
   // more variables,setters and getters below

My hbm file is
<hibernate-mapping> <class name="ie.test.Invoice" table="INVOICE"> <id name="id" type="java.lang.Integer"> <column name="id" /> <generator class="native" /> </id> <property name="purchaseOrderID" type="java.lang.Integer"> <column name="purchaseOrderID" /> </property> ...more mappings...

So since I cant have my purchase order varibale as object in invoice and declare my one-to-one relationship, can i add something else that will enforce a foreign key behind property name="purchaseOrderID".
I cant change this property to a purchase order object and this is not open to negotiation. Any pointers here would be much appreciated. I bet its simple but i cant figure it out

Thanks
Alan

[Ally Cavs]

Any ideas?

[Ally Cavs]

Guy i really need a hand here. Quite simply if i have

  <property name="purchaseOrderID" type="java.lang.Integer">  
             <column name="purchaseOrderID" />  
         </property>    

Can i designate this as a foreign key constraint against another column on anotehr table