how to setup/configure hibernate ORM in your spring project

-
This article is for how to setup/configure hibernate ORM in your spring project.

Add below maven dependency in pom.xml
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>4.0.1.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>4.2.0.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate.common</groupId>
<artifactId>hibernate-commons-annotations</artifactId>
<version>4.0.1.Final</version>
<classifier>tests</classifier>
</dependency>
<dependency>
<groupId>org.hibernate.javax.persistence</groupId>
<artifactId>hibernate-jpa-2.0-api</artifactId>
<version>1.0.1.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>4.0.1.Final</version>
</dependency>
<dependency>
<groupId>javax.validation</groupId>
<artifactId>validation-api</artifactId>
<version>1.0.0.GA</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.6.4</version>
</dependency>
<dependency>
<groupId>org.jboss.logging</groupId>
<artifactId>jboss-logging</artifactId>
<version>3.1.0.CR2</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.6.4</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>



Create a database.properties file in your resources folder.
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/test
database.user=root
database.password=
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update


In the spring config file, write below tag for loading properties file.
<context:property-placeholder location="classpath:resources/database.properties"></context:property-placeholder>

Write below tags in  spring config file for database connection:
<bean class="org.springframework.jdbc.datasource.DriverManagerDataSource"
id="dataSource">
<property name="driverClassName" value="${database.driver}"></property>
<property name="url" value="${database.url}"></property>
<property name="username" value="${database.user}"></property>
<property name="password" value="${database.password}"></property>
</bean>
<bean
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"
id="sessionFactory">
<property name="dataSource" ref="dataSource"></property>
<property name="packagesToScan">
<list>
<value><<write Database model package name>></value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}  </prop>
<prop key="hibernate.enable_lazy_load_no_trans">true</prop>
</props>
</property>
</bean>
<bean class="org.springframework.orm.hibernate4.HibernateTransactionManager"
id="hibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>
<mvc:annotation-driven />

Comments

Post a Comment

Recent Post

Recent Posts Widget

Popular posts from this blog

Capture image from webcam java code, examples

-
import java.applet.Applet; import java.awt.BorderLayout; import java.awt.Component; import java.awt.Dimension; import java.awt.Frame; import java.awt.Graphics; import java.awt.Graphics2D; import java.awt.Image; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.awt.image.BufferedImage; import java.io.FileOutputStream; import java.net.MalformedURLException; import java.net.URL; import javax.media.Buffer; import javax.media.CaptureDeviceInfo; import javax.media.CaptureDeviceManager; import javax.media.Manager; import javax.media.MediaLocator; import javax.media.Player; import javax.media.control.FrameGrabbingControl; import javax.media.format.VideoFormat; import javax.media.util.BufferToImage; import javax.swing.JButton; import javax.swing.JComponent; import com.sun.image.codec.jpeg.JPEGCodec; import com.sun.image.codec.jpeg.JPEGE
Read more

Use of req.query, req.params and req.body in NODE JS

-
Image
I am writing this article for beginners. Because, at the time of learning node js, this is very confusing where and how we need to use req.query, req.params and req.body . I am going to explain these three req method below. 1.        Req.query 2.        Req.params 3.        Req.body Req.query: When request is coming in key and value pair, for example, if your URL looks like below URL http://localhost:3000/search?name=xyz&age=16 In the above URL, you can see that request is coming in key and value pair . First key is name and value is xyz, second key is age and value is 16. In the node js programing, if you want to parse this url then use req.query. Below is the code snippet to parse this URL. router.get('/search', function(req, res, next) {   var name = req.query.name;   console.log(`Name :  ${name}`)   var age = req.query.age;   console.log(`Age :  ${age}`)   res.send('Request has parsed see console');   }); Req.param
Read more

How to capture finger prints in java

-
Java code for capture finger prints. NBioBSPJNI.FIR_HANDLE hSavedFIR; hSavedFIR = bsp.new FIR_HANDLE(); bsp.Enroll(hSavedFIR, null); // Enroll bsp.Capture(hSavedFIR); // Capture // Get Text FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR_TEXTENCODE textSavedFIR; textSavedFIR = bsp.new FIR_TEXTENCODE(); bsp.GetTextFIRFromHandle(hSavedFIR, textSavedFIR); } // Get Binary FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR fullSavedFIR; fullSavedFIR = bsp.new FIR(); bsp.GetFIRFromHandle(hSavedFIR, fullSavedFIR); } You can capture both type in your database and file. 1)textFIR 2)BinaryFIR
Read more