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.
