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.
