Announcement Announcement Module
Collapse
No announcement yet.
Could not roll back JPA transaction; nested exception is javax.persistence.Persistenc Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    Hello

    Next time use code tags, according to your second file

    Code:
    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.

    Comment


    • #3
      update

      The transactions are managed with the service layer in this case
      Code:
      @Transactional
      	public List<Tarea> obtenerTiposTareasDisponibles ()
      	{
      		return tareaDAO.obtenerTiposTareasDisponibles();
      	}
      The db connection setting are:
      Code:
      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
      Code:
      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
      Code:
      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)
      Code:
      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)
      Code:
      org.hibernate.exception.GenericJDBCException: Cannot release connection
      	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
      Code:
      org.hibernate.exception.GenericJDBCException: Cannot release connection
      	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

      Comment

      Working...
      X