Issue with DAO using Spring - Write operations not allowed in read-only mode

[Nagaraju Boddu]

HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or remove 'readOnly' marker from transaction definition.
these are my files

LoginController.java

package com.spring.controller;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import com.spring.dao.RegisterDao;
import com.spring.model.Register;

@Controller

public class LoginController {

	@Autowired

	private RegisterDao dao;

	@RequestMapping(value = "registerpage", method = RequestMethod.GET)

	public ModelAndView getRegisterPage() {

		System.out.println("control is in getRegister method");

		return new ModelAndView("register", "reg", new Register());
	}


	@RequestMapping(value = "registeruser", method = RequestMethod.POST)
	public ModelAndView registerUser(HttpServletRequest request) {

		System.out.println("control is in registeruser method");

		Register register = new Register();

		register.setUname(request.getParameter("uname"));
		register.setPassword(request.getParameter("password"));
		register.setEmail(request.getParameter("email"));
		register.setDob(request.getParameter("dob"));
		register.setAge(request.getParameter("age"));
		register.setCountry(request.getParameter("country"));
		
		

		dao.addUser(register);

		return new ModelAndView("success");
	}

	@RequestMapping(value = "delete", method = RequestMethod.GET)
	public ModelAndView delete() {

		return new ModelAndView("delete");
	}

	@RequestMapping(value = "deleteUser", method = RequestMethod.DELETE)

	public void deleteUser(@RequestParam("uname") String uname, ModelMap map) {

		Register register = new Register();
		register.setUname(uname);
		dao.deleteUser(register);

	}

	@RequestMapping(value = "readUsers", method = RequestMethod.GET)

	public List<Register> usersList(ModelMap map) {

		List<Register> register = dao.readUsers();

		map.addAttribute("Users", register);

		return register;
	}

}

RegisterDao.java

package com.spring.dao;

import java.util.List;

import com.spring.model.Register;

public interface RegisterDao {
	public void addUser(Register register);

	public List<Register> readUsers();

	public void deleteUser(Register register);

}

RegisterDaoImpl.java

package com.spring.dao;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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

import com.spring.model.Register;

@Service
public class RegisterDaoImpl implements RegisterDao {

	@Autowired

	private HibernateTemplate template;

	public void addUser(Register register,HttpServletRequest request,HttpServletResponse response) {
		// TODO Auto-generated method stub

		System.out.println("control is in adduser method of daoimpl");
		
		
		template.saveOrUpdate(register);
		
	}

	public List<Register> readUsers() {
		// TODO Auto-generated method stub

		System.out.println("control is in readuser method of daoimpl");

		List<Register> list = template.loadAll(Register.class);
		return list;
	}

	public void deleteUser(Register register) {
		// TODO Auto-generated method stub

		System.out.println("control is in deleteuser method of daoimpl");

		template.delete(register);

	}

	public void addUser(Register register) {
		// TODO Auto-generated method stub
		
		template.save(register);
		
	}
}

spring-servlet.xml

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd"> <context:component-scan base-package="com.spring" /> <mvc:annotation-driven /> <tx:annotation-driven /> <tx:annotation-driven transaction-manager="transactionManager" /> <bean id="handlerMapping" class="org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping"></bean> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/" /> <property name="suffix" value=".jsp" /> </bean> <bean id="template" class="org.springframework.orm.hibernate5.HibernateTemplate"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean class="org.springframework.orm.hibernate5.LocalSessionFactoryBean" id="sessionFactory"> <property name="dataSource" ref="dataSource"></property> <property name="annotatedClasses"> <list> <value>com.spring.model.Register</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe" /> <property name="username" value="scott" /> <property name="password" value="tiger" /> </bean> </beans>
web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <display-name>RegistrationWithSpringMvc</display-name> <servlet> <servlet-name>spring</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>spring</servlet-name> <url-pattern>*.html</url-pattern> </servlet-mapping> </web-app>

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.spring</groupId> <artifactId>RegistrationWithSpringMvc</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>RegistrationWithSpringMvc</name> <url>http://maven.apache.org</url> <dependencies> <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.3.2.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-web --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>4.3.2.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/com.hynnet/oracle-driver-ojdbc6 --> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId> <version>4.3.2.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-entitymanager --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>4.3.2.Final</version> </dependency> <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-validator --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>5.2.4.Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> <version>5.2.0.Final</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> <scope>provided</scope> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/jstl --> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api --> <dependency>     <groupId>org.slf4j</groupId>     <artifactId>slf4j-api</artifactId>     <version>1.7.21</version> </dependency> <dependency>     <groupId>org.jboss.logging</groupId>     <artifactId>jboss-logging</artifactId>     <version>3.3.0.Final</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.0.2</version> <configuration> <source>1.5</source> <target>1.5</target> </configuration> </plugin> </plugins> </build> </project>

[Ankit Garg]

Can you add more details like which request gives you this error. Few lines of the stack trace might also be helpful. One possible issue is that you've marked your DAO as a @Service, but DAOs are supposed to be @Repository...

[Nagaraju Boddu]

thank you for your replay.... i am getting this error while submitting values to database to store..... when i try to call dao.adduser() method in dao class am getting that error...

[Nagaraju Boddu]

thank you @Ankit Garg... i tried by @Repository annotation but it is also showing same error

[Ankit Garg]

You've included <tx:annotation-driven transaction-manager="transactionManager" /> but I don't see the transactionManager bean declared. Can you declare a transaction manager bean and try...

[Nagaraju Boddu]

i tried but getting error as

> > java.lang.IllegalStateException: Already value [org.springframework.orm.hibernate5.SessionHolder@19037196] for key [org.hibernate.internal.SessionFactoryImpl@1a513405] bound to thread [http-bio-2016-exec-5]
> java.lang.IllegalStateException: No value for key [org.hibernate.internal.SessionFactoryImpl@1a513405] bound to thread [http-bio-2016-exec-5]

[Ankit Garg]

This other thread you created seems very similar to the problem you are facing here (apart from the database everything else seems to be the same). I'm getting a bit confused, are you facing the same issue in both projects? If yes it would be better to focus on one of them so that it is easier to resolve the issue...