cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: query_governor_cost_limit setting not working with cayenne?
Date Sat, 20 Dec 2008 08:22:37 GMT
Hi Kathy,

Which version of Cayenne is that? Also do you have a working JDBC  
example - maybe I can try to reproduce it and compare to Cayenne.

Andrus


On Dec 20, 2008, at 1:08 AM, KathyS wrote:

>
> Hello,
>
> I'm retrofitting an existing project to use Cayenne back end. We use  
> SQL
> Server, and we need to be able in certain cases to prevent long  
> running
> queries from starting. SQL Server does that by using
> query_governor_cost_limit setting and comparing it with time  
> estimation
> prior to running the query. And it works with plain JDBC - executing  
> in the
> same connection "SET query_governor_cost_limit x" and the long running
> select query results in the query being canceled. But it doesn't  
> work with
> Cayenne for some reason. I made a query chain, and added the  
> governor as the
> first query, then long running select. It all gets executed, which -  
> in this
> case - is a big problem! Log is shown below. I'd appreciate advice. Is
> cayenne re-setting connection between queries in a chain? Is there  
> any funky
> stuff going with PreparedStatement?
>
> INFO  QueryLogger: SET query_governor_cost_limit 2
> INFO  QueryLogger: SELECT ...
> INFO  QueryLogger: === returned 2700 rows. - took 15594 ms.
>
> Thanks!!
> Kathy
> -- 
> View this message in context: http://www.nabble.com/query_governor_cost_limit-setting-not-working-with-cayenne--tp21099002p21099002.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
>


Mime
View raw message