[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5566) Clob column are not getting updated, even if there is real updated in the Clob data, when we do merge operation

[Srinivasa Rao Yedluri (JIRA)]

Clob column are not getting updated, even if there is real updated in the Clob data, when we do merge operation
---------------------------------------------------------------------------------------------------------------

                 Key: HHH-5566
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5566
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.2
         Environment: Spring2.5.6, Hibernate3.3.2, Weblogic10.3.1, Red Hat Linux, Oracle10G
            Reporter: Srinivasa Rao Yedluri


Below is the hbm file snippet

<hibernate-mapping>
	<class name="......OrderLineDTO"
		table="ORDER_LINES" dynamic-update="true">
		<id name="lineId" type="long" column="LINE_ID" length="15">
			<generator class="sequence">
				<param name="sequence">xyz</param>
			</generator>
		</id>
..................................
..................................
..................
		<property name="installationDetailClob" type="clob" column="ORDER_LINE_ATTRIBUTES_MAP"
			not-null="false" lazy="true" />
		<property name="attathmentMetadataClob" type="clob" column="ORDER_ATTACHMENT_METADATA"
			not-null="false" lazy="true"/>	
			
		<!-- Associations -->
		<!-- bi-directional many-to-one association to OrderHeader -->

		<many-to-one name="orderHeader"
			class="......"
			fetch="select">
			<column name="HEADER_ID" not-null="true" length="15" />
		</many-to-one>

		<!--
			bi-directional many-to-one association to SmartHand 
		-->
		<set name="smartHands" inverse="true" lazy="false"
			cascade="all,delete-orphan">
			<key>
				<column name="LINE_ID" /><!--  a foreign key in SMART_HANDS referencing the primary key of this table. 
				-->
			</key>
			<one-to-many
				class="...................SmartHandDTO" />
		</set>
	</class>
</hibernate-mapping>


DAO Code snippet:

public void update(OrderHeaderDTO orderHeaderDTO)
			throws DataAccessException {
		getOrdersHibernateTemplate().merge(orderHeaderDTO);
	}


1. Create a table with clob column and have some other columns. Have one column with timestamp.
2. Insert a record in to it.
3. Now create detached object with new operator and populate all the information programatically including pk. Populate clob column and timestamp with different data than already persisted data.
3. Now do merg operation on this object, we find only timestamp column is part of update query but not clob column.

Please let me know if you need any more details.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira