update only modified columns

venkatprakash · **Joined:** Thu Sep 30, 2004 5:35 pm **Posts:** 7

HI

I am fairly new to hibernate and this forum.
I have read about dynamic-update and used in one of my hbm.cfg file. But unfortunately the I am getting the full update SQL generated for all the columns. Part of config file is here:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class
name="com.rhi.extsites.shared.entity.cr.CandtEmpmtExper"
table="CANDT_EMPMT_EXPER"
dynamic-update="true"
dynamic-insert="true"
>

<id
name="candtEmpmtExperId"
type="java.lang.Long"
column="CANDT_EMPMT_EXPER_ID"
>
<generator class="assigned" />
</id>

<property
name="startDt"
type="java.util.Date"
column="START_DT"
length="10"
/>

2. Is there any way to show the SQL with parameter value on it. For eg, I used TopLink and I see the SQLs there with value being embedded, like "update table set field="Test""

Thanks for your help

venkatprakash · **Joined:** Thu Sep 30, 2004 5:35 pm **Posts:** 7

I got the answer myself for the first one after reading more posts here. I issued a select-before-update and it worked. (though its not suggested because of performance reason.

Any help on question 2?

jtsampson · **Joined:** Sun May 02, 2004 2:52 pm **Posts:** 5

venkatprakash wrote:

Any help on question 2?

Define a category(logger) in your log4j.xml:

Code:

<!--===================================-->
<!--### log JDBC bind parameters    ###-->
<category name="net.sf.hibernate.type">
    <priority value="DEBUG>
</category>

venkatprakash · **Joined:** Thu Sep 30, 2004 5:35 pm **Posts:** 7

Well. Yes I did mention in my log4j.proeprties file like below
log4j.logger.net.sf.hibernate.type=DEBUG

and I do get bind values. My question is: is that possible to get the SQL with those values.

What currently showing is:
update table set field=?
binding "Y" to parameter 1

I would like to see :
update table set field="Y"

This is how TOPLink shows. Its very useful when we have table with large number of columns.

Thanks for your reply.

ernst_pluess · **Posted:** Fri Oct 01, 2004 2:42 pm

You can use http://www.p6spy.org/. It acts as a JDBC driver and logs exactyl what you are looking for.

HTH
Ernst

jtsampson · **Joined:** Sun May 02, 2004 2:52 pm **Posts:** 5

ernst_pluess wrote:

You can use http://www.p6spy.org/. It acts as a JDBC driver and logs exactyl what you are looking for.

Ernst is right. I've used IronEyesSql (whici is a GUI wrapped around the p6spy drver) with good results. http://www.irongrid.com/catalog/license_agreement2.php

venkatprakash · **Joined:** Thu Sep 30, 2004 5:35 pm **Posts:** 7

jtsampson wrote:

ernst_pluess wrote:

You can use http://www.p6spy.org/. It acts as a JDBC driver and logs exactyl what you are looking for.

Ernst is right. I've used IronEyesSql (whici is a GUI wrapped around the p6spy drver) with good results. http://www.irongrid.com/catalog/license_agreement2.php

Thanks for your responses. Unfortunately I am not using any Application servers in this case. I am using Hibernate in our interfaces between 2 systems (databases). This has no front end tools. All are done through the back end interfaces.