[hibernate-issues] [Hibernate-JIRA] Commented: (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)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39127#action_39127 ] 

Srinivasa Rao Yedluri commented on HHH-5566:
--------------------------------------------

This issue is happening even when the data present for insert record which is in a batch with some update records.

> 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