Spring-Batch-CustomReader.png' alt='Spring Batch Read Multiple Xml Files' title='Spring Batch Read Multiple Xml Files' />Spring 4 MVCHibernate 4My. SQLMaven integration example using annotations. In this tutorial, we will integrate Spring with Hibernate using annotation based configuration. We will develop a simple CRUD oriented web application containing a form asking user input, saving that input in My. SQL database using Hibernate, retrieving the records from database and updating or deleting them within transaction, all using annotation configuration. Testing part of this post is covered in detail in Next Post where we perform unitintegration test using Test. NG, mockito, spring test, DBUnit H2 database. Top 50 Tricky Hibernate Interview Questions with answers, java interview question,java tutorials. This article briefs about Configuring Multiple Databases in Hibernate. Spring Batch Read Multiple Xml Files' title='Spring Batch Read Multiple Xml Files' />Open source Java projects Spring Batch Reading and writing CSV files with Spring Batch and MySQL. MultiResourceItemReader in Spring Batch Example, Spring Batch MultiResourceItemReader. Class MultiResourceItemReader Reads items from multiple resources. In this tutorial, we will show you how to configure a Spring Batch job to read data from a CSV file into a database. Tools and libraries used. Property Name Type Description Affects lineContinuationCharacter Character If this character is the last character before a new line or carriage return is read. Youve got problems, Ive got advice. This advice isnt sugarcoatedin fact, its sugarfree, and may even be a little bitter. Welcome to Tough Love. Spring JDBC Handling CLOB Learn Spring JDBC in simple and easy steps starting from basic to advanced concepts with examples including Overview, Environment Setup. Spring 4 MVC with Hibernate 4 MySQL Integration Example annotation based to create a CRUD oriented web application, making use of AOP based transactions. There is no need to use the classpath protocol in your schemaLocation URL if the namespace is configured correctly and the XSD file is on your classpath. To know more about testing with Test. NG in general, please refer our Test. NG Tutorials. Lets get going. Following technologies being used Spring 4. RELEASEHibernate Core 4. Finalvalidation api 1. Finalhibernate validator 5. Final. My. SQL Server 5. Maven 3. JDK 1. 7. Tomcat 8. 0. 2. 1Eclipse JUNO Service Release 2. Test. NG 6. 9. 4. Mockito 1. 1. 0. 1. DBUnit 2. 2. H2 Database 1. Lets begin. Step 1 Create the directory structure. Following will be the final project structure Lets now add the content mentioned in above structure explaining each in detail. Step 2 Update pom. Locationhttp maven. POM4. 0. 0 http maven. POM4. 0. 0 xmlns xsihttp www. XMLSchema instance. Version 4. 0. Version. Id com. websystique. Id. lt artifact. Id Spring. Hibernate. Examplelt artifact. Id. lt packaging warlt packaging. Spring. Hibernate. Examplelt name. RELEASElt springframework. Finallt hibernate. Spring. lt dependency. Id org. springframeworklt group. Id. lt artifact. Id spring corelt artifact. Id. lt version springframework. Id org. springframeworklt group. Id. lt artifact. Id spring weblt artifact. Id. lt version springframework. Id org. springframeworklt group. Id. lt artifact. Id spring webmvclt artifact. Id. lt version springframework. Id org. springframeworklt group. Sprint Layout 6 0. Id. lt artifact. Id spring txlt artifact. Id. lt version springframework. Id org. springframeworklt group. Id. lt artifact. Id spring ormlt artifact. Id. lt version springframework. Hibernate. Id org. Id. lt artifact. Id hibernate corelt artifact. Id. lt version hibernate. Id javax. validationlt group. Id. lt artifact. Id validation apilt artifact. Id. lt version 1. Finallt version. Id org. Id. lt artifact. Id hibernate validatorlt artifact. Id. lt version 5. Finallt version. My. SQL. lt dependency. Id mysqllt group. Id. lt artifact. Id mysql connector javalt artifact. Id. lt version mysql. Joda Time. Id joda timelt group. Id. lt artifact. Id joda timelt artifact. Id. lt version joda time. To map Joda. Time with database type. Id org. jadira. Id. Id usertype. corelt artifact. Id. lt version 3. CR1lt version. ServletJSPJSTL. Id javax. servletlt group. Id. lt artifact. Id javax. Id. lt version 3. Id javax. servlet. Id. lt artifact. Id javax. Id. lt version 2. Id javax. servletlt group. Id. lt artifact. Id jstllt artifact. Id. lt version 1. Testing dependencies. Id org. springframeworklt group. Id. lt artifact. Id spring testlt artifact. Id. lt version springframework. Id org. testnglt group. Id. lt artifact. Id testnglt artifact. Id. lt version testng. Id org. mockitolt group. Id. lt artifact. Id mockito alllt artifact. Id. lt version mockito. Id com. h. 2databaselt group. Id. lt artifact. Id h. Id. lt version h. Id dbunitlt group. Id. lt artifact. Id dbunitlt artifact. Id. lt version dbunit. Management. lt plugins. Id org. apache. Id. Id maven compiler pluginlt artifact. Id. lt version 3. Id org. apache. Id. Id maven war pluginlt artifact. Id. lt version 2. Source. Directory srcmainwebapplt war. Source. Directory. Name Spring. Hibernate. Examplelt war. Name. On. Missing. Web. Xml falselt fail. On. Missing. Web. Xml. lt configuration. Management. lt final. Name Spring. Hibernate. Examplelt final. Name. First thing to notice here is the maven war plugin declaration. As we are using full annotation configuration, we dont even include web. Since in this example we will use a form to accept input from user, we need also to validate the user input. We will choose JSR3. Validation here, so we have included validation api which represents the specification, and hibernate validator which represents an implementation of this specification. Email, Not. Empty, etc. Along with that, we have also included JSPServletJstl dependencies which we will be needing as we are going to use servlet apis and jstl view in our code. In general, containers might already contains these libraries, so we can set the scope as provided for them in pom. We also have added testing dependencies. Testing part of this post is described in detail in Next post. Rest of the dependencies are for Spring, Hibernate and Joda Time. Step 3 Configure Hibernatecom. Hibernate. Configuration. Properties. import javax. Data. Source. import org. Session. Factory. Autowired. import org. Bean. import org. Component. Scan. import org. Configuration. import org. Property. Source. Environment. import org. Driver. Manager. Data. Source. import org. Hibernate. Transaction. Manager. import org. Local. Session. Factory. Bean. import org. Enable. Transaction. Management. Enable. Transaction. Management. Component. Scan com. Property. Sourcevalue classpath application. Hibernate. Configuration. Environment environment. Local. Session. Factory. Bean session. Factory. Local. Session. Factory. Bean session. Factory new Local. Session. Factory. Bean. session. Factory. Data. Sourcedata. Source. session. Factory. Packages. To. Scannew String com. Factory. set. Hibernate. Propertieshibernate. Properties. return session. Factory. public Data. Source data. Source. Driver. Manager. Data. Source data. Source new Driver. Manager. Data. Source. Source. set. Driver. Class. Nameenvironment. Required. Propertyjdbc. Class. Name. data. Source. set. Urlenvironment. Required. Propertyjdbc. Source. set. Usernameenvironment. Required. Propertyjdbc. Source. set. Passwordenvironment. Required. Propertyjdbc. Source. private Properties hibernate. Properties. Properties properties new Properties. Required. Propertyhibernate. Required. Propertyhibernate. Required. Propertyhibernate. Hibernate. Transaction. Manager transaction. ManagerSession. Factory s. Hibernate. Transaction. Manager tx. Manager new Hibernate. Transaction. Manager. Manager. set. Session. Factorys. return tx. Manager. Configuration indicates that this class contains one or more bean methods annotated with Bean producing beans manageable by spring container. In our case, this class represent hibernate configuration. Component. Top 5. Tricky Hibernate Interview Questions Java. Tech. Info. Com. 31. Explain about the dirty checking feature of Hibernate Ans. Dirty checking feature of the Hibernate allows users or developers to. This feature makes. Explain the steps involved in creating database applications with Java using Hibernate Ans. Creating Database applications with Java is made simpler with. Hibernate. First Plain old java object needs to be written, XML mapping. Hibernate APIs can be used to store persistent. Explain about hibernate. Ans. Hibernate can be configured with two types of files out of which. Hibernate consults. These files are searched. Explain about mapping description file Ans. Mapping description file is the second file which Hibernate uses to. This mapping file has an extension. Java class and database tables. The usage of. mapping description file rests entirely upon the business entity. Explain about transaction file Ans. Transactions denote a work file which can save changes made or revert. A transaction can be started by. Transaction and it uses JDBC connection, CORBA or JTA. When this session starts several transactions may occur. Explain about mapping files in Hibernate Ans. Mapping files forms the core of any database mapping tools. These files. contain field to field mapping, usually this mapping occurs between. After mapping files they can be persist to the. Tags can be used to indicate the presence of a primary key. What is the effect when a transient mapped object is passed onto a Sessions saveAns. When a session. Garbage collection and termination. Java virtual machine stays as long as it is deleted explicitly. It may head back to its transient state. Explain about version field Ans. Application level data integrity constants are important if you are. Higher level locking or versioning protocol is required to support. Version field usage comes at this stage but the design and. Explain State some advantages of hibernate Ans Some of the advantages which a developer can get from Hibernate are as follows Mapping of one POJO table to one table is not required in hibernate. It. supports inheritance relationships and is generally a fast tool. Portability is necessary the greater benefit from hibernate. POJOs can. be used in other applications where they are applicable. Explain about add. Class function Ans. This function translates a Java class name into file name. This. translated file name is then loaded as an input stream from the Java. This addclass function is important if you want efficient. Explain about addjar and add. Directory methods Ans. These methods are the most convenient to use in hibernate. These. methods allow you to load all your Hibernate documents at a time. These. methods simplify code configuration, refactoring, layout, etc. These. functions help you to add your hibernate mapping to Hibernate. Explain about the id field Ans. This id field corresponds to the surrogate key which is generated by. These fields are handled by the id field. Name attribute. is used to specify the names of the field and it should correspond to. This also should correspond to long type and. I the database in the long column. What are the most common methods of Hibernate configuration Ans The most common methods of Hibernate configuration are.