Database Isolation Level

[Anna Bikkina <an...@pinksheets.com>]

Hi,

I am using cocoon's connection pool to make connections to my informix 
database. I think the connection cocoon is making is trying to lock rows in 
the database. In my application I have only reads no writes so I want cocoon 
to make dirty reads instead. Is there a place where I can set this?
"set islation to dirty read;"

My connection params look like this

    <jdbc logger="core.datasources.myserver" name="myserver">
      <pool-controller min="3" max="10" />
      <auto-commit>false</auto-commit>
      <dburl>jdbc:informix-sqli://
dev:1000:informixserver=myserver;Database=mydatabase</dburl>
      <user>informix</user>
      <password>password</password>
      <driver>com.informix.jdbc.IfxDriver</driver>
    </jdbc>


Thanks,
Anna.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org