Why a duplicate column being created for a foriegn key

[Kumar Raja]

Hi All,

I have a below class file and hbm file defined

            
       public class StockDailyRecord implements Serializable{
	  private Integer recordId;
	  private Stock stock;
	  private Float priceOpen;
	  private Float priceClose;
	  private Float priceChange;
	  private Long volume;
	  private Date date;
      

As you see, it has an association with Stock class, which I'm omitting for now in this post.

           <hibernate-mapping>
    <class name="StockDailyRecord" table="STOCKDAILYRECORD">
        <id name="recordId" type="java.lang.Integer">
            <column name="RECORDID" />
            <generator class="native" />
        </id>
        <many-to-one name="stock" class="Stock" fetch="join">
            <column name="STOCK" not-null = "true" />
        </many-to-one>
        <property name="priceOpen" type="java.lang.Float">
            <column name="PRICEOPEN" />
        </property>
        <property name="priceClose" type="java.lang.Float">
            <column name="PRICECLOSE" />
        </property>
        <property name="priceChange" type="java.lang.Float">
            <column name="PRICECHANGE" />
        </property>
        <property name="volume" type="java.lang.Long">
            <column name="VOLUME" />
        </property>
        <property name="date" type="java.util.Date">
            <column name="DATE" />
        </property>
    </class>
</hibernate-mapping>
     

When I looked into logs for org.hibernate.tool.hbm2ddl.SchemaExport, I see the create DDL statement for StockDailyRecord as follows

create table LEARN.STOCKDAILYRECORD (
        RECORDID integer generated by default as identity,
        STOCK integer not null,
        PRICEOPEN float,
        PRICECLOSE float,
        PRICECHANGE float,
        VOLUME bigint,
        DATE timestamp,
        STOCKID integer,
        primary key (RECORDID)
    )

alter table LEARN.STOCKDAILYRECORD 
        add constraint FKA4B752D4C473F1DF 
        foreign key (STOCKID) 
        references LEARN.STOCK>

As you see, it has STOCK and STOCKID. Which are actually one and the same. and when you persist, the value is being duplicated in both the columns. This is not necessary. How can this be fixed?

Please advise.