Hibernate Blog: Use of dynamic-insert and dynamic update

Dynamic-insert and Dynamic-update in XML mapping metadata

There are two attribute for disabling CRUD SQL generation on startup which are available for <class> mapping.

....

</class>

Note : default values of these attributes are false.

If you set dynamic-insert="true" in your class mapping metadata than null property values will not include in your INSERT SQL statement.

If you set dynamic-update="true" in your class mapping metadata than it includes only modified property values in UPDATE SQL statement.

Example :

I have an Item entity which have some property as follows,

I am trying to store item object into database. i run following code. default setting is dynamic-insert = "false" in class mapping metadata.

See the following comments on console.

14:59:10,286 INFO HibernateTest:19 - starting of main method

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Environment <clinit>

INFO: Hibernate 3.0rc1

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Environment <clinit>

INFO: hibernate.properties not found

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Environment <clinit>

INFO: using CGLIB reflection optimizer

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Environment <clinit>

INFO: using JDK 1.4 java.sql.Timestamp handling

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration configure

INFO: configuring from resource: /hibernate.cfg.xml

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration getConfigurationInputStream

INFO: Configuration resource: /hibernate.cfg.xml

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration addResource

INFO: Mapping resource: com/Item.hbm.xml

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: com.Item -> ITEM

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration doConfigure

INFO: Configured SessionFactory: null

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration secondPassCompile

INFO: processing extends queue

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration secondPassCompile

INFO: processing collection mappings

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration secondPassCompile

INFO: processing association property references

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.Configuration secondPassCompile

INFO: processing foreign key constraints

Oct 10, 2012 2:59:10 PM org.hibernate.dialect.Dialect <init>

INFO: Using dialect: org.hibernate.dialect.MySQLDialect

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory buildSettings

INFO: Maximum outer join fetch depth: 2

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory buildSettings

INFO: Default batch fetch size: 1

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory buildSettings

INFO: Generate SQL with comments: enabled

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory buildSettings

INFO: Order SQL updates by primary key: disabled

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory

INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

Oct 10, 2012 2:59:10 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>

INFO: Using ASTQueryTranslatorFactory

Oct 10, 2012 2:59:10 PM org.hibernate.cfg.SettingsFactory buildSettings

INFO: Query language substitutions: {}

Oct 10, 2012 2:59:10 PM org.hibernate.connection.C3P0ConnectionProvider configure

INFO: C3P0 using driver: null at URL: jdbc:mysql://localhost:3306/HibernateTest

Oct 10, 2012 2:59:10 PM org.hibernate.connection.C3P0ConnectionProvider configure

INFO: Connection properties: {autocommit=true, password=****, user=root}

Oct 10, 2012 2:59:10 PM org.hibernate.connection.C3P0ConnectionProvider configure

INFO: autocommit mode: true

Oct 10, 2012 2:59:10 PM org.hibernate.connection.C3P0ConnectionProvider configure

WARNING: No JDBC Driver class was specified by property hibernate.connection.driver_class

14:59:10,538 INFO MLog:80 - MLog clients using log4j logging.

14:59:10,773 INFO C3P0Registry:204 - Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]

14:59:10,830 INFO AbstractPoolBackedDataSource:462 - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@3c719ea5 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@39948757 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bs1yqt8qkj87tz1bbb5y0|cdd17f, idleConnectionTestPeriod -> 3000, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@888ae846 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1bs1yqt8qkj87tz1bbb5y0|693a5, jdbcUrl -> jdbc:mysql://localhost:3306/HibernateTest, properties -> {autocommit=true, password=******, user=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1bs1yqt8qkj87tz1bbb5y0|c0c9d0, numHelperThreads -> 3 ]