tenwit wrote:
Without dynamic-insert, each class' insert SQL statement is generated when the mapping file is parsed. This is efficient, as all that work is done only once. However, every column is always inserted.
With dynamic-insert, the SQL is generated only when you're about to insert a row. The smallest possible insert statement is generated, omitting columns that aren't needed (null values, or values that are equal to the default). This takes longer on the java side, but can be slightly quicker on the DB side. Use this for tables with many columns, most of which are usually null, or use it if your DB server is much slower than the machine your JVM is on.
Hi.....tenwit
Thnx a lot for Quick Replay. Now I got how to use 'dynamic-insert', As Really i got a Table with around 20 columns , where 7 columns are stays with default values , now i can use this. once again .....thnx......
have a gr8 day
Sreedhar P