Mantis - Resin
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2001 minor always 09-10-07 08:42 09-10-07 12:32
Reporter: sam Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: closed Product Version: 3.1.2  
Product Build: Resolution: no change required  
Projection: none      
ETA: none Fixed in Version: 3.1.2  
Summary: 0002001: database auto-commit=false option
Description: (rep by V Simkus)

I'm trying to run Jasper report server on Resin
instead of Tomcat. It seems to work OK except for when it comes to
large objects at which point the PostgreSQL driver throws an exception
that all LO operations must be performed inside a transaction...

Tomcat has an option to turn off auto-commits at the resource
definition. Does Resin have anything along these lines?

 <database>
    ...

    <connection>
      <auto-commit>false</auto-commit>
    </connection>
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:

Notes
(0002288)
sam   
09-10-07 12:32   
The transaction filter can be used to colve this problem:

 <filter filter-name='transaction-filter'
         filter-class='com.caucho.filters.TransactionFilter'/>

  <filter-mapping url-pattern='/*'
                  filter-name='transaction-filter'/>

The example above causes all requests to be done within a transaction.
The url-pattern could be made more specific so that only those requests that use jasper reports are captured by the filter.