Actually I think I already have sufficient information to try it out.
Still information about Cayenne version may be important.
Andrus
On Dec 20, 2008, at 10:22 AM, Andrus Adamchik wrote:
> 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.
>>
>>
>
>
This archive was generated by hypermail 2.0.0 : Sat Dec 20 2008 - 03:33:14 EST