Could not roll back JPA transaction; nested exception is javax.persistence.Persistenc

[Cguillen]

After a period of time working fine, my tomcat6 server display this error after the user achive the login



type Informe de Excepción

mensaje

descripción El servidor encontró un error interno () que hizo que no pudiera rellenar este requerimiento.

excepción

org.springframework.web.util.NestedServletExceptio n: Request processing failed; nested exception is org.springframework.transaction.TransactionSystemE xception: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:656)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:549)
javax.servlet.http.HttpServlet.service(HttpServlet .java:617)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.springframework.security.web.FilterChainProxy$ VirtualFilterChain.doFilter(FilterChainProxy.java: 368)
org.springframework.security.web.access.intercept. FilterSecurityInterceptor.invoke(FilterSecurityInt erceptor.java:109)
org.springframework.security.web.access.intercept. FilterSecurityInterceptor.doFilter(FilterSecurityI nterceptor.java:83)
org.springframework.security.web.FilterChainProxy$ VirtualFilterChain.doFilter(FilterChainProxy.java: 380)
org.springframework.security.web.access.ExceptionT ranslationFilter.doFilter(ExceptionTranslationFilt er.java:97)
org.springframework.security.web.FilterChainProxy$ VirtualFilterChain.doFilter(FilterChainProxy.java: 380)
org.springframework.security.web.session.SessionMa nagementFilter.doFilter(SessionManagementFilter.ja va:100)
org.springframework.security.web.FilterChainProxy$ VirtualFilterChain.doFilter(FilterChainProxy.java: 380)

"Look at attachments"
---------------------------------------------------------------------------
My config is:
database.username=cgui
database.password=werty1245
database.url=jdbc:oracle:thin:@7.110.14.54:1522:O2
database.driverClassName=oracle.jdbc.driver.Oracle Driver
database.maxActive=20
database.maxIdle=30000
database.maxWait=100
database.validationQuery=SELECT 1 from dual
database.testOnBorrow=true
database.testWhileIdle=true
database.timeBetweenEvictionRunsMillis=10000
database.minEvictableIdleTimeMillis=60000

Can anyone help me with this error please, I am able to ping the database and even the log in with a Oracle client.

[dr_pompeii]

Hello

Next time use code tags, according to your second file

org.hibernate.exception.GenericJDBCException: Cannot release connection
	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
...
causa raíz

java.sql.SQLException: Already closed.

I suggest post (with code tags) your Datasource and transaction configuration to get a better understanding.

[Cguillen]

The transactions are managed with the service layer in this case

@Transactional
	public List<Tarea> obtenerTiposTareasDisponibles ()
	{
		return tareaDAO.obtenerTiposTareasDisponibles();
	}

The db connection setting are:

database.username=cgui
database.password=werty1245
database.url=jdbc:oracle:thin:@7.110.14.54:1522:O2
database.driverClassName=oracle.jdbc.driver.OracleDriver
database.maxActive=20
database.maxIdle=30000
database.maxWait=100
database.validationQuery=SELECT 1 from dual
database.testOnBorrow=true
database.testWhileIdle=true
database.timeBetweenEvictionRunsMillis=10000
database.minEvictableIdleTimeMillis=60000

The errors are

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.hibernate.exception.GenericJDBCException: Cannot release connection
	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

org.hibernate.exception.GenericJDBCException: Cannot release connection
	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)