{"id":513,"date":"2014-08-06T15:03:06","date_gmt":"2014-08-06T15:03:06","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=513"},"modified":"2014-08-06T16:16:55","modified_gmt":"2014-08-06T16:16:55","slug":"hibernate-config-file-for-mysql-dialect","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/hibernate-config-file-for-mysql-dialect\/","title":{"rendered":"Hibernate Config File for MySQL Dialect"},"content":{"rendered":"

Defining Dialect in Hibernate<\/p>\n

\n\t\t\t\t\"MySQL<\/a>\n\t\t\t\t
MySQL Dialect<\/figcaption>\n\t\t\t<\/figure>\n
\r\n\r\n<!DOCTYPE hibernate-configuration PUBLIC\r\n        "-\/\/Hibernate\/Hibernate Configuration DTD 3.0\/\/EN"\r\n        "http:\/\/www.hibernate.org\/dtd\/hibernate-configuration-3.0.dtd">\r\n<hibernate-configuration>  \r\n    <session-factory>\r\n        <property name="connection.driver_class">com.mysql.jdbc.Driver<\/property>\r\n        <property name="connection.url">jdbc:mysql:\/\/localhost:3306\/hibernate<\/property>\r\n        <property name="connection.username">root<\/property>\r\n        <property name="connection.password">pass<\/property>\r\n        \r\n        <!-- JDBC connection pool (use the built-in) -->\r\n        <property name="connection.pool_size">1<\/property>\r\n\r\n        <!-- SQL dialect -->\r\n        <property name="dialect">org.hibernate.dialect.MySQLDialect<\/property>\r\n\r\n        <!-- Disable the second-level cache  -->\r\n        <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider<\/property>\r\n\r\n        <!-- Echo all executed SQL to stdout -->\r\n        <property name="show_sql">true<\/property>\r\n\r\n        <!-- Drop and re-create the database schema on startup -->\r\n        <property name="hbm2ddl.auto">update<\/property>\r\n        \r\n        <!-- Name of the Annotated Entity class -->\r\n        <mapping class="com.mugil.dto.UserDetails"\/>\r\n    <\/session-factory>\r\n<\/hibernate-configuration>\r\n<\/pre>\n
If hbm2ddl.auto<\/strong> is set to create the table will be created every time when java class is Run.The old records will be deleted.<\/p>\n
\r\n<property name="hbm2ddl.auto">create<\/property>\r\n<\/pre>\n
When set to update the records will be added without new table creation <\/p>\n
\r\n<property name="hbm2ddl.auto">update<\/property>\r\n<\/pre>\n
More Annotations<\/strong><\/p>\n
\"3\"<\/a><\/p>\n
@Transient tells not to create Column
\n@Column tells the Hibernate the Name under which column need to be
\ncreated in Db table.<\/p>\n
\r\n@Transient \r\n@Column (name="User_Name") \r\nprivate String userName; \r\n<\/pre>\n
@Temporal tells the option of selective addition.Below I am adding Date rather than
\nDate & time as Timestamp<\/p>\n
\r\n @Temporal (TemporalType.DATE) \r\n private Date DOJ;\r\n<\/pre>\n
@Lob – Large Object, Telling Hibernate to create Large Object Datatype fro Column
\n@Lob over String creates CLOB
\n@Lob over Byte creates BLOB<\/p>\n
\r\n @Lob\r\n private String userDescription;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Defining Dialect in Hibernate <!DOCTYPE hibernate-configuration PUBLIC "-\/\/Hibernate\/Hibernate Configuration DTD 3.0\/\/EN" "http:\/\/www.hibernate.org\/dtd\/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="connection.driver_class">com.mysql.jdbc.Driver<\/property> <property name="connection.url">jdbc:mysql:\/\/localhost:3306\/hibernate<\/property> <property name="connection.username">root<\/property> <property name="connection.password">pass<\/property> <!– JDBC connection pool (use the built-in) –> <property name="connection.pool_size">1<\/property> <!– SQL dialect –> <property name="dialect">org.hibernate.dialect.MySQLDialect<\/property> <!– Disable the second-level cache –> <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider<\/property> <!– Echo all executed SQL to stdout –> <property… Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[74],"tags":[],"class_list":["post-513","post","type-post","status-publish","format-standard","hentry","category-hibernate"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":6,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":517,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/513\/revisions\/517"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}