Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isolated work

[swapniltake1]

Error :
`org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isolated work
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause

org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isolated work
org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:231)
org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:388)
org.springframework.orm.hibernate5.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:351)
org.springframework.orm.hibernate5.HibernateTemplate.save(HibernateTemplate.java:638)
com.spring.mvc.dao.UserDao.saveUser(UserDao.java:19)
com.spring.mvc.dao.UserDao$$FastClassBySpringCGLIB$$93bc7663.invoke()
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
com.spring.mvc.dao.UserDao$$EnhancerBySpringCGLIB$$5a45b7fb.saveUser()
com.spring.mvc.service.UserService.createUser(UserService.java:17)
com.spring.mvc.ContactController.processForm(ContactController.java:39)
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
java.base/java.lang.reflect.Method.invoke(Method.java:577)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)`

my Code :

`package com.spring.mvc.model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@entity
public class User {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;

public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
private String userEmail;
private String userName;
private String UserPassword;

public String getUserEmail() {
	return userEmail;
}
public void setUserEmail(String userEmail) {
	this.userEmail = userEmail;
}
public String getUserName() {
	return userName;
}
public void setUserName(String userName) {
	this.userName = userName;
}
public String getUserPassword() {
	return UserPassword;
}
public void setUserPassword(String userPassword) {
	UserPassword = userPassword;
}

}
`

`package com.spring.mvc.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.spring.mvc.model.User;

@repository
public class UserDao {

@Autowired
private HibernateTemplate hibernateTemplate;

@Transactional
public int saveUser(User user) {
	
int id=	(Integer) this.hibernateTemplate.save(user);
	return id;
	
}

}
`

`package com.spring.mvc.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.spring.mvc.dao.UserDao;
import com.spring.mvc.model.User;

@service
public class UserService {

@Autowired
private UserDao userDao;

public int createUser(User user) {
	return this.userDao.saveUser(user);
}

}
`

`

<tx:annotation-driven />

<!-- viewResolver -->



<context:component-scan
	base-package="com.spring.mvc.service, com.spring.mvc.dao, com.spring.mvc.model, com.spring.mvc" />

<bean
	class="org.springframework.web.servlet.view.InternalResourceViewResolver"
	name="viewResolver">

	<property name="prefix" value="/WEB-INF/views/" />
	<property name="suffix" value=".jsp" />
</bean>

<bean name="ds"
	class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	<property name="driverClassName"
		value="com.mysql.jdbc.Driver" />
	<property name="url"
		value="jdbc:mysql://127.0.0.1:3306/SpringMvc" />
	<property name="username" value="root" />
	<property name="password" value="admin" />
</bean>


<bean
	class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"
	name="factory">
	<!-- datasource prop -->
	<property name="dataSource" ref="ds" />
	<!-- hibernate Prop -->
	<property name="hibernateProperties">
		<props>
			<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
			<prop key="hibernate.show_sql">true</prop>
			<prop key="hibernate.hbm2ddl.auto">update</prop>
		</props>
	</property>
	<!-- annoted classes -->
	<property name="annotatedClasses">
		<list>
			<value>
				com.spring.mvc.model.User
			</value>
		</list>
	</property>

</bean>

<bean class="org.springframework.orm.hibernate5.HibernateTemplate"
	name="hibernateTemplate">
	<property name="sessionFactory" ref="factory"></property>
</bean>

<!-- <bean class="com.spring.orm.dao.StudentDao" name="StudentDao">
	<property name="hibernateTemplate" ref="hibernateTemplate" />
</bean> -->

<bean
	class="org.springframework.orm.hibernate5.HibernateTransactionManager"
	name="transactionManager">
	<property name="sessionFactory" ref="factory" />
</bean>

`

`package com.spring.mvc;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import com.spring.mvc.model.User;
import com.spring.mvc.service.UserService;

@controller
public class ContactController {

@Autowired
private UserService userService;

@ModelAttribute          //automatically data set up for view
public void commmonDataForModel(Model m) {
	m.addAttribute("desc", "Signup for join");
	m.addAttribute("head", "Join Us ");
}

@RequestMapping("/contact")
public String showForm(Model m) {
//	m.addAttribute("header", "Registration Form");
/*
 * m.addAttribute("desc", "Signup for join"); m.addAttribute("head",
 * "Join Us ");
 */
	
	return "contact";
}

@RequestMapping(path = "/processform", method = RequestMethod.POST)
public String processForm(@ModelAttribute("user") User user, Model model) {
	// Modelattribute is setting data automaticaly and returning that value into success.jsp page 
	
	this.userService.createUser(user);
	
	return "success";
}

/*old pattern 
 * @RequestMapping(path = "/processform", method = RequestMethod.POST) public
 * String processForm(@RequestParam("userName") String
 * userName,@RequestParam("userEmail") String
 * userEmail, @RequestParam("userPassword") String userPassword , Model model) {
 * 
 * System.out.println("User Nmae is : "+userName);
 * System.out.println("User Email is : "+userEmail);
 * System.out.println("User Password Is : "+userPassword);
 * 
 * 
 * User user=new User(); user.setUserEmail(userEmail);
 * user.setUserName(userName); user.setUserPassword(userPassword);
 * 
 * 
 * 
 * model.addAttribute("userName", userName); model.addAttribute("userEmail",
 * userEmail); model.addAttribute("userPassword", userPassword);
 * 
 * 
 * // All data set into the class and them sended it into view
 * model.addAttribute("user", user); return "success"; }
 */

}
`

When am running project am facing error Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isolated work