Trying to read data from DB using spring batch and hibernate reader getting org.hibernate.hql.internal.ast.QuerySyntaxException: Result is not mapped [from Result].
Developer(s) | Pivotal Software |
---|---|
Initial release | 1 October 2002; 16 years ago |
Stable release | |
Preview release | 5.2.0-RC1 / August 5, 2019; 36 days ago[2] |
Repository | Spring Repository |
Written in | Java |
Platform | Java EE |
Type | Application framework |
License | Apache License 2.0 |
Website | spring.io |
The Spring Framework is an application framework and inversion of controlcontainer for the Java platform. The framework's core features can be used by any Java application, but there are extensions for building web applications on top of the Java EE (Enterprise Edition) platform. Although the framework does not impose any specific programming model, it has become popular in the Java community as an addition to, or even replacement for the Enterprise JavaBeans (EJB) model. The Spring Framework is open source.
- 2Modules
- 2.7Convention-over-configuration rapid application development
Version history[edit]
Version | Date | Notes |
---|---|---|
0.9 | 2002 | |
1.0 | 2003 | |
2.0 | 2006 | |
3.0 | 2009 | |
4.0 | 2013 | |
5.0 | 2017 |
The first version was written by Rod Johnson, who released the framework with the publication of his book Expert One-on-One J2EE Design and Development in October 2002. The framework was first released under the Apache 2.0 license in June 2003. The first milestone release, 1.0, was released in March 2004 with further milestone releases in September 2004 and March 2005. The Spring 1.2.6 framework won a Jolt productivity award and a JAX (Java API for XML) Innovation Award in 2006.[3][4] Spring 2.0 was released in October 2006, Spring 2.5 in November 2007, Spring 3.0 in December 2009, Spring 3.1 in December 2011, and Spring 3.2.5 in November 2013.[5] Spring Framework 4.0 was released in December 2013.[6] Notable improvements in Spring 4.0 included support for Java SE (Standard Edition) 8, Groovy 2, some aspects of Java EE 7, and WebSocket.
Spring Framework 4.2.0 was released on 31 July 2015 and was immediately upgraded to version 4.2.1, which was released on 01 Sept 2015.[7] It is 'compatible with Java 6, 7 and 8, with a focus on core refinements and modern web capabilities'.[8]
Spring Framework 4.3 has been released on 10 June 2016 and will be supported until 2020.[9] It 'will be the final generation within the general Spring 4 system requirements (Java 6+, Servlet 2.5+), [...]'.[10]
Spring 5 is announced to be built upon Reactive Streams compatible Reactor Core.[11]
Modules[edit]
The Spring Framework includes several modules that provide a range of services:
- Spring Core Container: this is the base module of Spring and provides spring containers (BeanFactory and ApplicationContext).[12]
- Aspect-oriented programming: enables implementing cross-cutting concerns.
- Authentication and authorization: configurable security processes that support a range of standards, protocols, tools and practices via the Spring Security sub-project (formerly Acegi Security System for Spring).
- Convention over configuration: a rapid application development solution for Spring-based enterprise applications is offered in the Spring Roo module
- Data access: working with relational database management systems on the Java platform using Java Database Connectivity (JDBC) and object-relational mapping tools and with NoSQL databases
- Inversion of control container: configuration of application components and lifecycle management of Java objects, done mainly via dependency injection
- Messaging: configurative registration of message listener objects for transparent message-consumption from message queues via Java Message Service (JMS), improvement of message sending over standard JMS APIs
- Model–view–controller: an HTTP- and servlet-based framework providing hooks for extension and customization for web applications and RESTful (representational state transfer) Web services.
- Remote access framework: configurative remote procedure call (RPC)-style marshalling of Java objects over networks supporting Java remote method invocation (RMI), CORBA (Common Object Request Broker Architecture) and HTTP-based protocols including Web services (SOAP (Simple Object Access Protocol))
- Transaction management: unifies several transaction management APIs and coordinates transactions for Java objects
- Remote management: configurative exposure and management of Java objects for local or remote configuration via Java Management Extensions (JMX)
- Testing: support classes for writing unit tests and integration tests
Inversion of control container (dependency injection)[edit]
Central to the Spring Framework is its inversion of control (IoC) container, which provides a consistent means of configuring and managing Java objects using reflection. The container is responsible for managing object lifecycles of specific objects: creating these objects, calling their initialization methods, and configuring these objects by wiring them together.
Objects created by the container are also called managed objects or beans. The container can be configured by loading XML (Extensible Markup Language) files or detecting specific Java annotations on configuration classes. These data sources contain the bean definitions that provide the information required to create the beans.
Objects can be obtained by means of either dependency lookup or dependency injection.[13] Dependency lookup is a pattern where a caller asks the container object for an object with a specific name or of a specific type. Dependency injection is a pattern where the container passes objects by name to other objects, via either constructors, properties, or factory methods.
In many cases one need not use the container when using other parts of the Spring Framework, although using it will likely make an application easier to configure and customize. The Spring container provides a consistent mechanism to configure applications and integrates with almost all Java environments, from small-scale applications to large enterprise applications.
The container can be turned into a partially compliant EJB (Enterprise JavaBeans) 3.0 container by means of the Pitchfork project. Some[who?] criticize the Spring Framework for not complying with standards.[14] However, SpringSource doesn't see EJB 3 compliance as a major goal, and claims that the Spring Framework and the container allow for more powerful programming models.[15]The programmer does not directly create an object, but describe how they should be created, by defining it in the Spring configuration file. Similarly services and components are not called directly; instead a Spring configuration file defines which services and components must be called. This IoC is intended to increase the ease of maintenance and testing.
Aspect-oriented programming framework[edit]
The Spring Framework has its own Aspect-oriented programming (AOP) framework that modularizes cross-cutting concerns in aspects. The motivation for creating a separate AOP framework comes from the belief that it should be possible to provide basic AOP features without too much complexity in either design, implementation, or configuration. The Spring AOP framework also takes full advantage of the Spring container.
The Spring AOP framework is proxy pattern-based, and is configured at run time. This removes the need for a compilation step or load-time weaving. On the other hand, interception only allows for public method-execution on existing objects at a join point.
Compared to the AspectJ framework, Spring AOP is less powerful, but also less complicated. Spring 1.2 includes support to configure AspectJ aspects in the container. Spring 2.0 added more integration with AspectJ; for example, the pointcut language is reused and can be mixed with Spring AOP-based aspects. Further, Spring 2.0 added a Spring Aspects library that uses AspectJ to offer common Spring features such as declarative transaction management and dependency injection via AspectJ compile-time or load-time weaving. SpringSource also uses AspectJ AOP in other Spring projects such as Spring Roo and Spring Insight, with Spring Security also offering an AspectJ-based aspect library.
Spring AOP has been designed to make it able to work with cross-cutting concerns inside the Spring Framework. Any object which is created and configured by the container can be enriched using Spring AOP.
The Spring Framework uses Spring AOP internally for transaction management, security, remote access, and JMX.
Since version 2.0 of the framework, Spring provides two approaches to the AOP configuration:
- schema-based approach[16] and
- @AspectJ-based annotation style.[17]
The Spring team decided not to introduce new AOP-related terminology; therefore, in the Spring reference documentation and API, terms such as aspect, join point, advice, pointcut, introduction, target object (advised object), AOP proxy, and weaving all have the same meanings as in most other AOP frameworks (particularly AspectJ).
Data access framework[edit]
Spring's data access framework addresses common difficulties developers face when working with databases in applications. Support is provided for all popular data access frameworks in Java: JDBC, iBatis/MyBatis, Hibernate, Java Data Objects (JDO), Java Persistence API (JPA), Oracle TopLink, Apache OJB, and Apache Cayenne, among others.
For all of these supported frameworks, Spring provides these features
- Resource management - automatically acquiring and releasing database resources
- Exception handling - translating data access related exception to a Spring data access hierarchy
- Transaction participation - transparent participation in ongoing transactions
- Resource unwrapping - retrieving database objects from connection pool wrappers
- Abstraction for binary large object (BLOB) and character large object (CLOB) handling
All these features become available when using template classes provided by Spring for each supported framework. Critics have said these template classes are intrusive and offer no advantage over using (for example) the Hibernate API directly.[18][failed verification] In response, the Spring developers have made it possible to use the Hibernate and JPA APIs directly. This however requires transparent transaction management, as application code no longer assumes the responsibility to obtain and close database resources, and does not support exception translation.
Together with Spring's transaction management, its data access framework offers a flexible abstraction for working with data access frameworks. The Spring Framework doesn't offer a common data access API; instead, the full power of the supported APIs is kept intact. The Spring Framework is the only framework available in Java that offers managed data access environments outside of an application server or container.[19]
While using Spring for transaction management with Hibernate, the following beans may have to be configured:
- A Data Source like
com.mchange.v2.c3p0.ComboPooledDataSource
ororg.apache.commons.dbcp.BasicDataSource
- A SessionFactory like
org.springframework.orm.hibernate3.LocalSessionFactoryBean
with a DataSource attribute - A HibernateProperties like
org.springframework.beans.factory.config.PropertiesFactoryBean
- A TransactionManager like
org.springframework.orm.hibernate3.HibernateTransactionManager
with a SessionFactory attribute
Other points of configuration include:
- An AOP configuration of cutting points.
- Transaction semantics of AOP advice[clarify].
Transaction management[edit]
Spring's transaction management framework brings an abstraction mechanism to the Java platform. Its abstraction is capable of:
- working with local and global transactions (local transaction does not require an application server)
- working with nested transactions
- working with savepoints
- working in almost all environments of the Java platform
In comparison, Java Transaction API (JTA) only supports nested transactions and global transactions, and requires an application server (and in some cases also deployment of applications in an application server).
The Spring Framework ships a PlatformTransactionManager for a number of transaction management strategies:
- Transactions managed on a JDBC Connection
- Transactions managed on Object-relational mapping Units of Work
- Transactions managed via the JTA TransactionManager and UserTransaction
- Transactions managed on other resources, like object databases
Next to this abstraction mechanism the framework also provides two ways of adding transaction management to applications:
- Programmatically, by using Spring's TransactionTemplate
- Configuratively, by using metadata like XML or Java annotations (@Transactional, etc.)
Together with Spring's data access framework — which integrates the transaction management framework — it is possible to set up a transactional system through configuration without having to rely on JTA or EJB. The transactional framework also integrates with messaging and caching engines.
Model–view–controller framework[edit]
Spring MVC/Web Reactive presentation given by Juergen Hoeller
The Spring Framework features its own model–view–controller (MVC) web application framework, which wasn't originally planned. The Spring developers decided to write their own Web framework as a reaction to what they perceived as the poor design of the (then) popular Jakarta Struts Web framework,[20] as well as deficiencies in other available frameworks. In particular, they felt there was insufficient separation between the presentation and request handling layers, and between the request handling layer and the model.[21]
Like Struts, Spring MVC is a request-based framework. The framework defines strategy interfaces for all of the responsibilities that must be handled by a modern request-based framework. The goal of each interface is to be simple and clear so that it's easy for Spring MVC users to write their own implementations, if they so choose. MVC paves the way for cleaner front end code. All interfaces are tightly coupled to the Servlet API. This tight coupling to the Servlet API is seen by some as a failure on the part of the Spring developers to offer a high-level abstraction for Web-based applications[citation needed]. However, this coupling makes sure that the features of the Servlet API remain available to developers while offering a high abstraction framework to ease working with said API.
The DispatcherServlet class is the front controller[22] of the framework and is responsible for delegating control to the various interfaces during the execution phases of an HTTP request.
The most important interfaces defined by Spring MVC, and their responsibilities, are listed below:
- Controller: comes between Model and View to manage incoming requests and redirect to proper response. Controller will map the http request to corresponding methods. It acts as a gate that directs the incoming information. It switches between going into model or view.
- HandlerAdapter: execution of objects that handle incoming requests
- HandlerInterceptor: interception of incoming requests comparable, but not equal to Servlet filters (use is optional and not controlled by DispatcherServlet).
- HandlerMapping: selecting objects that handle incoming requests (handlers) based on any attribute or condition internal or external to those requests
- LocaleResolver: resolving and optionally saving of the locale of an individual user
- MultipartResolver: facilitate working with file uploads by wrapping incoming requests
- View: responsible for returning a response to the client. Some requests may go straight to view without going to the model part; others may go through all three.
- ViewResolver: selecting a View based on a logical name for the view (use is not strictly required)
Each strategy interface above has an important responsibility in the overall framework. The abstractions offered by these interfaces are powerful, so to allow for a set of variations in their implementations, Spring MVC ships with implementations of all these interfaces and together offers a feature set on top of the Servlet API. However, developers and vendors are free to write other implementations. Spring MVC uses the Java
java.util.Map
interface as a.[23] It is preconfigured with the Spring team's 'opinionated view' of the best configuration and use of the Spring platform and third-party libraries so you can get started with minimum fuss. Most Spring Boot applications need very little Spring configuration. Features:- Create stand-alone Spring applications
- Embed Tomcat or Jetty directly (no need to deploy WAR files)
- Provide opinionated 'starter' Project Object Models (POMs) to simplify your Maven configuration
- Automatically configure Spring whenever possible
- Provide production-ready features such as metrics, health checks and externalized configuration
- Absolutely no code generation and no requirement for XML configuration
Spring Roo[edit]
Spring Roo is a community project which provides an alternative, code-generation based approach at using convention-over-configuration to rapidly build applications in Java. It currently supports Spring Framework, Spring Security and Spring Web Flow. Roo differs from other rapid application development frameworks by focusing on:
- Extensibility (via add-ons)
- Java platform productivity (as opposed to other languages)
- Lock-in avoidance (Roo can be removed within a few minutes from any application)
- Runtime avoidance (with associated deployment advantages)
- Usability (particularly via the shell features and usage patterns)
Batch framework[edit]
Spring Batch is a framework for batch processing that provides reusable functions that are essential in processing large volumes of records, including:
- logging/tracing
- transaction management
- job processing statistics
- job restart
It also provides more advanced technical services and features that will enable extremely high-volume and high performance batch jobs through optimizations and partitioning techniques.Spring Batch executes a series of jobs; a job consists of many steps and each step consists of a READ-PROCESS-WRITE task or single operation task (tasklet).
The 'READ-PROCESS-WRITE' process consists of these steps: 'read' data from a resource (comma-separated values (CSV), XML, or database), 'process' it, then 'write' it to other resources (CSV, XML, or database). For example, a step may read data from a CSV file, process it, and write it into the database. Spring Batch provides many classes to read/write CSV, XML, and database.
For a 'single' operation task (tasklet), it means doing a single task only, like clean up the resources before or after a step is started or completed.
The steps can be chained together to run as a job.
Integration framework[edit]
Spring Integration is a framework for Enterprise application integration that provides reusable functions essential to messaging or event-driven architectures.
- routers - routes a message to a message channel based on conditions
- transformers - converts/transforms/changes the message payload and creates a new message with transformed payload
- adapters - to integrate with other technologies and systems (HTTP, AMQP (Advanced Message Queuing Protocol), JMS (Java Message Service), XMPP (Extensible Messaging and Presence Protocol), SMTP (Simple Mail Transfer Protocol), IMAP (Internet Message Access Protocol), FTP (File Transfer Protocol) as well as FTPS/SFTP, file systems, etc.)
- filters - filters a message based on criteria. If the criteria are not met, the message is dropped
- service activators - invoke an operation on a service object
- management and auditing
Spring Integration supports pipe-and-filter based architectures.
See also[edit]
References[edit]
- ^'Spring Framework 5.1.9, 5.0.15 and 4.3.25 available now'. Retrieved 28 August 2019.
- ^'Spring Framework 5.2 goes RC1'. Retrieved 28 August 2019.
- ^Jolt winners 2006
- ^JAX Innovation Award Gewinner 2006
- ^'Spring Framework 3.2.5 Released'. Official Spring website. 7 Nov 2013. Retrieved 16 October 2016.
- ^SpringSource.org
- ^Spring Official Blog
- ^Spring Official Blog
- ^Spring release blog
- ^Spring Official Blog
- ^Reactive Spring
- ^Spring Framework documentation for the Core Container
- ^What is the difference between the depencylookup and dependency injection - Spring Forum. Forum.springsource.org (2009-10-28). Retrieved on 2013-11-24.
- ^Spring VS EJB3
- ^'Pitchfork FAQ'. Retrieved 2006-06-06.
- ^Spring AOP XML Configuration
- ^AspectJ Annotation Configuration
- ^Hibernate VS Spring
- ^'Spring Data JPA for Abstraction of Queries'. Retrieved 2018-02-06.
- ^Introduction to the Spring Framework
- ^Johnson, Expert One-on-One J2EE Design and Development, Ch. 12. et al.
- ^Patterns of Enterprise Application Architecture: Front Controller
- ^Spring Boot
Bibliography[edit]
- Mak, Gary (September 1, 2010). Spring Recipes: A Problem-Solution Approach (Second ed.). Apress. p. 1104. ISBN1-4302-2499-1.
- Walls, Craig (November 28, 2010). Spring in Action (Third ed.). Manning. p. 700. ISBN1-935182-35-8.
- Walls, Craig; Breidenbach, Ryan (August 16, 2007). Spring in Action (Second ed.). Manning. p. 650. ISBN1-933988-13-4.
- Johnson, Rod; Höller, Jürgen; Arendsen, Alef; Risberg, Thomas; Sampaleanu, Colin (July 8, 2005). Professional Java Development with the Spring Framework (First ed.). Wrox Press. p. 672. ISBN0-7645-7483-3.
- Harrop, Rob; Machacek, Jan (January 31, 2005). Pro Spring (First ed.). Apress. p. 832. ISBN1-59059-461-4.
- Johnson, Rod; Jürgen, Höller (October 23, 2002). J2EE Development without EJB (First ed.). Wrox Press. p. 768. ISBN0-7645-5831-5.
- Johnson, Rod (October 2002). Expert One-on-one J2EE Design and Development (First ed.). Wrox Press. p. 750. ISBN0-7645-4385-7.
- Pollack, Mark; Gierke, Oliver; Risberg, Thomas; Brisbin, Jon; Hunger, Michael (October 31, 2012). Spring Data (First ed.). O'Reilly. p. 316. ISBN978-1449323950.
- Sarin, Ashish (June 27, 2016). Getting started with Spring Framework (Third ed.). Self-published. p. 626. ISBN978-1534985087.
- Long, Josh (August 27, 2013). Spring Framework LiveLessons (First ed.). Addison-Wesley Professional. pp. 4+ Hours. ISBN978-0-13-346307-1.
External links[edit]
The Wikibook Java Programming has a page on the topic of: Spring framework |
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Spring_Framework&oldid=914766371'
- Hibernate Tutorial
- Hibernate Useful Resources
- Selected Reading
Consider a situation when you need to upload a large number of records into your database using Hibernate. Following is the code snippet to achieve this using Hibernate −
By default, Hibernate will cache all the persisted objects in the session-level cache and ultimately your application would fall over with an OutOfMemoryException somewhere around the 50,000th row. You can resolve this problem, if you are using batch processing with Hibernate.
To use the batch processing feature, first set hibernate.jdbc.batch_size as batch size to a number either at 20 or 50 depending on object size. This will tell the hibernate container that every X rows to be inserted as batch. To implement this in your code, we would need to do little modification as follows −
Above code will work fine for the INSERT operation, but if you are willing to make UPDATE operation, then you can achieve using the following code −
Batch Processing Example
Let us modify the configuration file to add hibernate.jdbc.batch_size property −
Consider the following POJO Employee class −
Let us create the following EMPLOYEE table to store the Employee objects −
Following will be the mapping file to map the Employee objects with EMPLOYEE table −
Finally, we will create our application class with the main() method to run the application where we will use flush() and clear() methods available with Session object so that Hibernate keeps writing these records into the database instead of caching them in the memory.
Compilation and Execution
Here are the steps to compile and run the above mentioned application. Make sure, you have set PATH and CLASSPATH appropriately before proceeding for the compilation and execution.
- Create hibernate.cfg.xml configuration file as explained above.
- Create Employee.hbm.xml mapping file as shown above.
- Create Employee.java source file as shown above and compile it.
- Create ManageEmployee.java source file as shown above and compile it.
- Execute ManageEmployee binary to run the program, which will create 100000 records in EMPLOYEE table.