need some help

[zhengyan <zh...@gmail.com>]

Hi, I'm using the Cayenne3.1.2 version .
I want to set the QueryTimeout parameter , like the parameter in
JDBC setQueryTimeout(5);
 Where I can set this parameter in Cayenne3.1.2?

Thanks !

Re: need some help

[Andrus Adamchik <an...@objectstyle.org>]

Also #3:

Since DbAdapter serves as SQLAction factory for the entire stack, you may install a Statement timeout-aware custom DbAdapter. There are also a few levels of indirection to do that. I think the simplest is to create a custom Module [1] like this:

public class MyModule implements Module {

    public void configure(Binder binder) {
        binder.bind(DbAdapterFactory.class).to(MyDbAdapterFactory.class);
    }
} 

and then implement MyDbAdapterFactory to return your own adapter, subclassing whatever DbAdapter is appropriate for your DB (e.g. MySQLAdapter), overriding it "getAction" method to return that action that can manipulate the statement timeout.

(Like I said, we need to do better in the future, so that you won't have to jump through so many hoops to access the JDBC layer)

Andrus


[1] https://cayenne.apache.org/docs/3.1/cayenne-guide/#customize 


> On Jun 20, 2019, at 10:49 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> 
> 
> 
>> On Jun 20, 2019, at 10:33 AM, zhengyan <zh...@gmail.com> wrote:
>> 
>> Hi, I'm using the Cayenne3.1.2 version .
>> I want to set the QueryTimeout parameter , like the parameter in
>> JDBC setQueryTimeout(5);
>> Where I can set this parameter in Cayenne3.1.2?
>> 
>> Thanks !
> 
> Hi,
> 
> Unfortunately there's no direct way to do it, and you will have to implement some roundabout approach:
> 
> 1. Your connection pool may support a default query timeout. E.g. DBCP has "defaultQueryTimeout" config parameter.
> 2. You may need to subclass your SelectQuery, to implement a custom "createSQLAction" method, them subclass your DB-specific SelectAction to control the Statement.
> 
> The second solution would require poking inside a few Cayenne internals, but is not as scary as it may seem :)
> 
> Also I made a note to explore exposing JDBC Statements in some way for user customization, so hopefully the future versions of Cayenne will allow for a more direct approach.
> 
> Andrus
> 
> [1] https://commons.apache.org/proper/commons-dbcp/configuration.html
> 

Re: need some help

[Andrus Adamchik <an...@objectstyle.org>]

> On Jun 20, 2019, at 10:33 AM, zhengyan <zh...@gmail.com> wrote:
> 
> Hi, I'm using the Cayenne3.1.2 version .
> I want to set the QueryTimeout parameter , like the parameter in
> JDBC setQueryTimeout(5);
> Where I can set this parameter in Cayenne3.1.2?
> 
> Thanks !

Hi,

Unfortunately there's no direct way to do it, and you will have to implement some roundabout approach:

1. Your connection pool may support a default query timeout. E.g. DBCP has "defaultQueryTimeout" config parameter.
2. You may need to subclass your SelectQuery, to implement a custom "createSQLAction" method, them subclass your DB-specific SelectAction to control the Statement.

The second solution would require poking inside a few Cayenne internals, but is not as scary as it may seem :)

Also I made a note to explore exposing JDBC Statements in some way for user customization, so hopefully the future versions of Cayenne will allow for a more direct approach.

Andrus

[1] https://commons.apache.org/proper/commons-dbcp/configuration.html