https://bz.apache.org/bugzilla/show_bug.cgi?id=68295

            Bug ID: 68295
           Summary: Connection has already been closed - Tomcat connection
                    pool
           Product: Tomcat 9
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Documentation
          Assignee: dev@tomcat.apache.org
          Reporter: angadpaul.si...@rbc.com
  Target Milestone: -----

Created attachment 39435
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=39435&action=edit
Logs from batch job

As per the documentation on
https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html. We have implemented
Tomcat Connection pool in our project. It is a Java batch job and we are using
below properties.

maxTotal="100"
maxIdle="20" 

removeAbandoned="true"
removeAbandonedTimeout="1800"

Our batch job abruptly ends with below logs:
exitDescription=org.springframework.transaction.TransactionSystemException:
Could not roll back JPA transaction; nested exception is
org.hibernate.TransactionException: Unable to rollback against JDBC
Connection\n\tat org.springframework.orm.jpa.JpaTransactionManager.doRollback

I need to understand what should be the combination of these params?
removeAbandoned as per documentation is for longest running query but this
fails even the queries run less than 5 mins. 
Is there a different param like maxAge we need to use?
Also attcahed complete logs too.
Pls help as this is impacting our batch jobs.

Thanks
Angadpaul

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org

Reply via email to