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="10000"
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
