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" 
    maxActive="100" maxIdle="30" maxWait="10000"
        username="jasperadmin" password="password" 
defaultAutoCommit="false" />

resin-interest mailing list

Reply via email to