Yes, i watched those thread. Thank you very much!
On Thu, Sep 11, 2008 at 6:15 AM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
> You don't have transactions here.
> Note the recent thread about it in nhcdev
>
>
> On Thu, Aug 28, 2008 at 10:46 AM, Andrew Melnichuk <
> [EMAIL PROTECTED]> wrote:
>
>> Ok, i have played with unit test more and it seems that query caching
>> works only when connection.release_mode is set to "on_close" value. Here is
>> updated test. If i have this config parameter
>> cfg.Properties.Add("connection.release_mode", "on_close"); - test passes.
>> But if i set it to "auto" or "after_transaction" test fails. Can't
>> understand how query cache correlates with connection management.
>>
>> [TestFixture]
>> public class QueryCacheTestFixture
>> {
>> private ISessionFactory factory;
>>
>> [SetUp]
>> public void SetUp()
>> {
>> Configuration cfg = new Configuration();
>> cfg.Properties.Add("connection.driver_class",
>> "NHibernate.Driver.SQLite20Driver");
>> cfg.Properties.Add("dialect",
>> "NHibernate.Dialect.SQLiteDialect");
>> cfg.Properties.Add("connection.provider",
>> "NHibernate.Connection.DriverConnectionProvider");
>> cfg.Properties.Add("connection.connection_string", "Data
>> Source=D:\\Temp\\QueryCacheTest\\bin\\Debug\\db3;Version=3;New=True;");
>> cfg.Properties.Add("connection.release_mode", "on_close"); //
>> TEST PASSES for on_close only
>> cfg.Properties.Add("cache.use_second_level_cache", "true");
>> cfg.Properties.Add("cache.use_query_cache", "true");
>> cfg.Properties.Add("cache.provider_class",
>> "NHibernate.Cache.HashtableCacheProvider, NHibernate");
>> cfg.Properties.Add("show_sql", "true");
>>
>> //cfg.Properties.Add("cache.use_structured_entries", "true");
>> //cfg.Properties.Add("generate_statistics", "true");
>>
>> cfg.AddAssembly(typeof(QueryCacheTestFixture).Assembly);
>>
>> factory = cfg.BuildSessionFactory();
>> new SchemaExport(cfg).Execute(true, true, false, true);
>> }
>>
>> [TearDown]
>> public void TearDown()
>> {
>> }
>>
>> [Test]
>> public void Test()
>> {
>> Customer c = new Customer();
>> c.Name = "Customer";
>> Resource r1 = new Resource();
>> r1.Customer = c;
>> r1.Name = "Resource1";
>> Resource r2 = new Resource();
>> r2.Customer = c;
>> r2.Name = "Resource2";
>>
>> using (ISession session = factory.OpenSession())
>> {
>> session.Save(c);
>> session.Save(r1);
>> session.Save(r2);
>> session.Flush();
>> }
>>
>> long count1 = 0;
>> long count2 = 0;
>>
>> using (ISession session = factory.OpenSession())
>> {
>> count1 = session
>> .CreateQuery("select count(r) from Resource r where
>> r.Customer = :customer")
>> .SetCacheable(true)
>> .SetParameter("customer", c)
>> .UniqueResult<long>();
>> }
>>
>> using (ISession session = factory.OpenSession())
>> {
>> IDbCommand cmd = session.Connection.CreateCommand();
>> cmd.CommandText = "delete from Resource";
>> cmd.ExecuteNonQuery();
>> }
>>
>> using (ISession session = factory.OpenSession())
>> {
>> count2 = session
>> .CreateQuery("select count(r) from Resource r where
>> r.Customer = :customer")
>> .SetCacheable(true)
>> .SetParameter("customer", c)
>> .UniqueResult<long>();
>> }
>>
>> Assert.That(count1 == count2);
>> }
>> }
>>
>> On Thu, Aug 28, 2008 at 10:17 AM, Andrew Melnichuk <
>> [EMAIL PROTECTED]> wrote:
>>
>>> You were right! It works for different sessions! Thanks.
>>>
>>>
>>> On Tue, Aug 26, 2008 at 4:23 PM, Ayende Rahien <[EMAIL PROTECTED]>wrote:
>>>
>>>> You cannot use the query cache on the same session, create a new one and
>>>> see what is going on.
>>>>
>>>>
>>>> On Tue, Aug 26, 2008 at 9:17 AM, Andrew Melnichuk <
>>>> [EMAIL PROTECTED]> wrote:
>>>>
>>>>> I feel that i'm doing something wrong, or i have some concept
>>>>> miunderstanding of how it all should work. Ok here my code.
>>>>>
>>>>> [TestFixture]
>>>>> public class QueryCacheTestFixture
>>>>> {
>>>>> private ISession sess;
>>>>>
>>>>> [SetUp]
>>>>> public void SetUp()
>>>>> {
>>>>> Configuration cfg = new Configuration();
>>>>> cfg.Properties.Add("connection.driver_class",
>>>>> "NHibernate.Driver.SQLite20Driver");
>>>>> cfg.Properties.Add("dialect",
>>>>> "NHibernate.Dialect.SQLiteDialect");
>>>>> cfg.Properties.Add("connection.provider",
>>>>> "NHibernate.Connection.DriverConnectionProvider");
>>>>> cfg.Properties.Add("connection.connection_string", "Data
>>>>> Source=:memory:;Version=3;New=True;");
>>>>> cfg.Properties.Add("connection.release_mode", "on_close");
>>>>> cfg.Properties.Add("cache.use_second_level_cache", "true");
>>>>> cfg.Properties.Add("cache.use_query_cache", "true");
>>>>> cfg.Properties.Add("cache.provider_class",
>>>>> "NHibernate.Cache.HashtableCacheProvider, NHibernate");
>>>>> cfg.Properties.Add("show_sql", "true");
>>>>>
>>>>> //cfg.Properties.Add("generate_statistics", "true"); -->
>>>>> causes NullReference exception
>>>>> cfg.Properties.Add("cache.use_structured_entries", "true");
>>>>>
>>>>>
>>>>> cfg.AddAssembly(typeof(QueryCacheTestFixture).Assembly);
>>>>>
>>>>> ISessionFactory factory = cfg.BuildSessionFactory();
>>>>> sess = factory.OpenSession();
>>>>> new SchemaExport(cfg).Execute(true, true, false, true,
>>>>> sess.Connection, null);
>>>>> }
>>>>>
>>>>> [TearDown]
>>>>> public void TearDown()
>>>>> {
>>>>> sess.Close();
>>>>> }
>>>>>
>>>>> [Test]
>>>>> public void Test()
>>>>> {
>>>>> Customer c = new Customer();
>>>>> c.Name = "Customer";
>>>>> Resource r1 = new Resource();
>>>>> r1.Customer = c;
>>>>> r1.Name = "Resource1";
>>>>> Resource r2 = new Resource();
>>>>> r2.Customer = c;
>>>>> r2.Name = "Resource2";
>>>>>
>>>>> sess.Save(c);
>>>>> sess.Save(r1);
>>>>> sess.Save(r2);
>>>>> sess.Flush();
>>>>>
>>>>> // select and cache value type result (count)
>>>>> long count1 = sess
>>>>> .CreateQuery("select count(r) from Resource r where
>>>>> r.Customer = :customer")
>>>>> .SetCacheable(true)
>>>>> .SetParameter("customer", c)
>>>>> .UniqueResult<long>();
>>>>>
>>>>> // remove resources, cache not involved
>>>>> IDbCommand cmd = sess.Connection.CreateCommand();
>>>>> cmd.CommandText = "delete from Resource";
>>>>> cmd.ExecuteNonQuery();
>>>>>
>>>>> // should get cached value, but it still goes do DB
>>>>> long count2 = sess
>>>>> .CreateQuery("select count(r) from Resource r where
>>>>> r.Customer = :customer")
>>>>> .SetCacheable(true)
>>>>> .SetParameter("customer", c)
>>>>> .UniqueResult<long>();
>>>>>
>>>>> Assert.That(count1 == count2); // fails 2 == 0
>>>>> }
>>>>> }
>>>>> }
>>>>>
>>>>> Mappings are simple:
>>>>>
>>>>> public class Customer
>>>>> {
>>>>> private int _id;
>>>>> private string _name;
>>>>>
>>>>> public Customer() { }
>>>>>
>>>>> public virtual int Id
>>>>> {
>>>>> get { return _id; }
>>>>> set { _id = value; }
>>>>> }
>>>>>
>>>>> public virtual string Name
>>>>> {
>>>>> get { return _name; }
>>>>> set { _name = value; }
>>>>> }
>>>>> }
>>>>>
>>>>> <?xml version="1.0" encoding="utf-8" ?>
>>>>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
>>>>> assembly="QueryCacheTest" namespace="QueryCacheTest">
>>>>> <class name="Customer" table="Customer" lazy="false">
>>>>> <cache usage="read-only" region="customer" />
>>>>> <id name="Id">
>>>>> <generator class="identity" />
>>>>> </id>
>>>>> <property name="Name" />
>>>>> </class>
>>>>> </hibernate-mapping>
>>>>>
>>>>> public class Resource
>>>>> {
>>>>> private int _id;
>>>>> private string _name;
>>>>> private Customer _customer;
>>>>>
>>>>> public Resource() { }
>>>>>
>>>>> public virtual int Id
>>>>> {
>>>>> get { return _id; }
>>>>> set { _id = value; }
>>>>> }
>>>>>
>>>>> public virtual string Name
>>>>> {
>>>>> get { return _name; }
>>>>> set { _name = value; }
>>>>> }
>>>>>
>>>>> public virtual Customer Customer
>>>>> {
>>>>> get { return _customer; }
>>>>> set { _customer = value; }
>>>>> }
>>>>> }
>>>>>
>>>>> <?xml version="1.0" encoding="utf-8" ?>
>>>>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
>>>>> assembly="QueryCacheTest" namespace="QueryCacheTest">
>>>>> <class name="Resource" table="Resource">
>>>>> <cache usage="read-only"/>
>>>>> <id name="Id">
>>>>> <generator class="identity" />
>>>>> </id>
>>>>> <property name="Name" />
>>>>> <many-to-one name="Customer" column="CustomerId" />
>>>>> </class>
>>>>> </hibernate-mapping>
>>>>>
>>>>>
>>>>> On Mon, Aug 25, 2008 at 9:16 PM, Andrew Melnichuk <
>>>>> [EMAIL PROTECTED]> wrote:
>>>>>
>>>>>> Sure will do it tomorrow.
>>>>>>
>>>>>>
>>>>>> On Mon, Aug 25, 2008 at 7:34 PM, Ayende Rahien <[EMAIL PROTECTED]>wrote:
>>>>>>
>>>>>>> Can you create a small test case that demonstrate the issue?
>>>>>>>
>>>>>>> On Sun, Aug 24, 2008 at 6:25 AM, Andrew Melnichuk <
>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>
>>>>>>>> Does anybody had same problems?
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Aug 22, 2008 at 10:13 PM, Andrew Melnichuk <
>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>
>>>>>>>>> No i do not create process again, so cache exists between 2 calls
>>>>>>>>> in my web app. As i told, caching of classes and collections works as
>>>>>>>>> expected. Maybe i missed something in config?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Fri, Aug 22, 2008 at 10:04 PM, Andrew Melnichuk <
>>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>>
>>>>>>>>>> In fact, launches are web requests (session-per-request model). I
>>>>>>>>>> just posted logs from 1st and 2nd requests to show that 1st request
>>>>>>>>>> hits DB
>>>>>>>>>> than caches data, and 2nd request hits cache only, but it is not :(
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Fri, Aug 22, 2008 at 7:45 PM, Ayende Rahien <[EMAIL PROTECTED]
>>>>>>>>>> > wrote:
>>>>>>>>>>
>>>>>>>>>>> What do you mean by second launch?Are you using separate
>>>>>>>>>>> sessions ? Are you creating the process again?
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Fri, Aug 22, 2008 at 12:29 PM, Andrew Melnichuk <
>>>>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hello everybody.
>>>>>>>>>>>>
>>>>>>>>>>>> I'm trying to use second-level query cache, but my query just
>>>>>>>>>>>> misses cache and always goes to database. Here is my code:
>>>>>>>>>>>>
>>>>>>>>>>>> Configuration (castle's nhibernate facility)
>>>>>>>>>>>> ...
>>>>>>>>>>>> <item
>>>>>>>>>>>> key="cache.provider_class">NHibernate.Caches.SysCache.SysCacheProvider,
>>>>>>>>>>>> NHibernate.Caches.SysCache</item>
>>>>>>>>>>>> <item key="cache.use_query_cache">true</item>
>>>>>>>>>>>> <item key="cache.use_second_level_cache">true</item>
>>>>>>>>>>>> ...
>>>>>>>>>>>>
>>>>>>>>>>>> Query
>>>>>>>>>>>> ......
>>>>>>>>>>>> using (ISession session =
>>>>>>>>>>>> _sessionManager.OpenSession())
>>>>>>>>>>>> {
>>>>>>>>>>>> return session.CreateQuery(
>>>>>>>>>>>> "select count(r) from Resource r where
>>>>>>>>>>>> r.Customer = :customer")
>>>>>>>>>>>> .SetParameter("customer", customer)
>>>>>>>>>>>> .SetCacheable(true)
>>>>>>>>>>>> .SetCacheRegion("resource-count")
>>>>>>>>>>>> .UniqueResult<long>();
>>>>>>>>>>>> }
>>>>>>>>>>>> .......
>>>>>>>>>>>>
>>>>>>>>>>>> And here is what in the log
>>>>>>>>>>>>
>>>>>>>>>>>> 1st launch, nothing cached yet
>>>>>>>>>>>>
>>>>>>>>>>>> SQL:
>>>>>>>>>>>> select count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_ where ([EMAIL PROTECTED] ); @p0 = '2'
>>>>>>>>>>>>
>>>>>>>>>>>> CACHE:
>>>>>>>>>>>> Fetching object 'NHibernate-Cache:resource-count:sql: select
>>>>>>>>>>>> count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_ where
>>>>>>>>>>>> (resource0_.CustomerKey=? ); parameters: []; named parameters:
>>>>>>>>>>>> [EMAIL PROTECTED]' from the
>>>>>>>>>>>> cache.
>>>>>>>>>>>>
>>>>>>>>>>>> adding new data: key=NHibernate-Cache:resource-count:sql: select
>>>>>>>>>>>> count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_ where
>>>>>>>>>>>> (resource0_.CustomerKey=? ); parameters: []; named parameters:
>>>>>>>>>>>> [EMAIL PROTECTED]
>>>>>>>>>>>> &value=System.Collections.ArrayList
>>>>>>>>>>>>
>>>>>>>>>>>> 2nd launch, should be cached (if i understood all correct :))
>>>>>>>>>>>>
>>>>>>>>>>>> SQL:
>>>>>>>>>>>> select count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_ where ([EMAIL PROTECTED] ); @p0 = '2'
>>>>>>>>>>>>
>>>>>>>>>>>> CACHE:
>>>>>>>>>>>> Fetching object 'NHibernate-Cache:resource-count:sql: select
>>>>>>>>>>>> count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_ where
>>>>>>>>>>>> (resource0_.CustomerKey=? ); parameters: []; named parameters:
>>>>>>>>>>>> [EMAIL PROTECTED]' from the
>>>>>>>>>>>> cache.
>>>>>>>>>>>>
>>>>>>>>>>>> updating value of key 'NHibernate-Cache:resource-count:sql:
>>>>>>>>>>>> select count_big(resource0_.ResourceKey) as x0_0_ from Resource
>>>>>>>>>>>> resource0_
>>>>>>>>>>>> where (resource0_.CustomerKey=? ); parameters: []; named
>>>>>>>>>>>> parameters:
>>>>>>>>>>>> [EMAIL PROTECTED]' to
>>>>>>>>>>>> 'System.Collections.ArrayList'.
>>>>>>>>>>>>
>>>>>>>>>>>> So, query to database is always issuing. Caching for classes and
>>>>>>>>>>>> collections works as expected. Not sure, maybe i missed something?
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Best regards,
>>>>>>>>>>>> Andrew Melnichuk
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Best regards,
>>>>>>>>>> Andrew Melnichuk
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Best regards,
>>>>>>>>> Andrew Melnichuk
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Best regards,
>>>>>>>> Andrew Melnichuk
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Best regards,
>>>>>> Andrew Melnichuk
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Best regards,
>>>>> Andrew Melnichuk
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Andrew Melnichuk
>>>
>>
>>
>>
>> --
>> Best regards,
>> Andrew Melnichuk
>>
>>
>>
>
> >
>
--
Best regards,
Andrew Melnichuk
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
