Prepared vs plain statement may change execution plan for the governor query
itself, but as long as it runs, and I verified it runs by watching sql
server trace, it should "work". I was more concerned seeing sp_prepare /
sp_unprepare surrounding each query, even inside of the chain.
Andrus Adamchik wrote:
>
>
> On Dec 20, 2008, at 4:48 PM, KathyS wrote:
>
>> JDBC code is straightforward:
>> Statement stmnt = con.createStatement();
>> stmnt.execute("SET query_governor_cost_limit 2");
>
> The only difference with Cayenne internal execution path would be that
> Cayenne will use PreparedStatement here. Anyways, I need to try it I
> guess...
>
> Andrus
>
>
>
-- View this message in context: http://www.nabble.com/query_governor_cost_limit-setting-not-working-with-cayenne--tp21099002p21105729.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 - 10:00:35 EST