Re: [Resin-interest] Resin and transactions (disable autocommit)
Date: Tue, Aug 28, 2007 at 12:52:23PM -0500 Subject: Re: [Resin-interest] Resin and transactions (disable autocommit) ... Long story short 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? Added a bug report: http://bugs.caucho.com/view.php?id=2001 -- Sam ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Resin and transactions (disable autocommit)
On Sep 10, 2007, at 8:43 AM, Sam wrote: Date: Tue, Aug 28, 2007 at 12:52:23PM -0500 Subject: Re: [Resin-interest] Resin and transactions (disable autocommit) ... Long story short 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? Added a bug report: http://bugs.caucho.com/view.php?id=2001 Except that doesn't really make any sense. disabling auto-commit really means starting a transaction. But if your code isn't really handling the transactions itself, then it will be missing the commit()/rollback(). -- Scott -- Sam ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Resin and transactions (disable autocommit)
Long story short 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? Added a bug report: http://bugs.caucho.com/view.php?id=2001 The transaction filter can be used to solve 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. -- Sam ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Resin and transactions (disable autocommit)
Scott Ferguson wrote: On Aug 24, 2007, at 11:23 AM, Vic Simkus wrote: Hello Sorry for the duplicate if it has been asked before, but I could find anything conclusive... How do I turn off transaction autocommits in Resin? I'm running Resin 3.1.2 against a PosgreSQL database. In what kind of environment? If you're just using a JDBC connection from a DataSource, call conn.setAutoCommit(false). -- Scott I wish it were that simple :) Long story short 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? Resource name=jdbc/jasperserver auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 username=jasperadmin password=password driverClassName=org.postgresql.Driver url=jdbc:postgresql://localhost:5432/jasperserver defaultAutoCommit=false / ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
[Resin-interest] Resin and transactions (disable autocommit)
Hello Sorry for the duplicate if it has been asked before, but I could find anything conclusive... How do I turn off transaction autocommits in Resin? I'm running Resin 3.1.2 against a PosgreSQL database. Thanks -- Vic Simkus Center for Stroke Research Department of Neurology and Rehabilitation 1645 West Jackson, Suite 400 Chicago, Illinois 60612 There is no way to rule innocent men. The only power government has is the power to crack down on criminals. When there aren't enough criminals, one makes them. One declares so many things to be a crime that it becomes impossible for men to live without breaking laws. --Ayn Rand ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest