I am trying to perform an hql query which returns a list of objects with distinct property value. Following is my pseudo code:
I have written an hql to support paging string hql = @\"select distinct mr from MediaResource as mr wheremr.Deleted= false
I have a table with more than 10 000 000 rows. In TOAD this query works very well on it: select /*+ INDEX(x IDX_CASHFLOW_COMPLEX)*/ *
I am using HQL to save an object in the DB. It is something like this Query query = sessionFactory.getCurrentSession().createQuery(ASK_FOR_HELP_SAVE_QUERY);
I am running into similar situation as this post. My pseudo code is string hql = \"select ai from AreaInfo as ai where ai.PhoneSegment is substring of :InputPhoneNumber\";
I have an entity which might have a parent entity. I want to run this query: select entity where entity.parent.id = 9
I have implemented a search function using Castel Active Record. I thought the code is simple enough but I kept getting
I need to work around an NHibernate bug I reported here. Essentially, NHibernate will generate multiple SQL parameters for the same HQL parameter, which results in problems for queries that use a para
How can HQL be used to select specific objects that meet a certain criteria? We\'ve tried the following to generate a list of top ten subscribed RSS feeds (where SubscriptionCount is a derived proper
I\'m using Hibernate EntityManager, and am experiencing a weird slowdown in my Hibernate queries. Take a look at this code:
加载中,请稍侯......