named-query
How to order by number of keywords found in sql/namedQuery
I created a query with a like and a or select * from xxx where title like (\'%bon%\') or title like (\'%test%\')[详细]
2023-02-12 16:55 分类:问答Can't access a stand alone domain object in hql namedQuery
First I need to apologize for the long post, I struggle with being overly verbose and yet not always clear enough. I also have searched extensively for an elegant solution for my issue and if I missed[详细]
2023-02-10 09:44 分类:问答Using if else statement for named query?
@NamedQueries( { @NamedQuery(name = \"GetAvailableProducts\", query = new StringBuilder(\"\").append(\"SELECT pFROM Product p WHERE p.type= :type AND (p.available = \'ALL\' OR\").append(isTest() ? \"[详细]
2023-01-31 05:14 分类:问答How do Hibernate event listeners behave using HQL (named queries)?
I create a lot of hibernate event listeners, to catch all database events like load, persist, update, delete etc. All events will be caught, but named queries will not be caught by my load even开发者_[详细]
2023-01-26 20:26 分类:问答Is there any size limit in arraylist used in "where in" in java named query?
Is there any si开发者_JAVA技巧ze limit in arraylist used in \"where in\" in java named query?With Oracle 10g you can you use 1000.I think this is entirely database-specific as opposed to Java or JDBC[详细]
2023-01-12 10:55 分类:问答JPA createNamedQuery syntax
In Pro JPA 2 (Apress) book, I have seen examples like, EntityManager em; Long count = em.createNamedQuery(countQueryName, Lon开发者_运维问答g.class).getSingleResult();[详细]
2023-01-09 13:32 分类:问答NHibernate, how to read NamedQuery result metadata?
I have an sql-query define on my nhibernate mapping file, that call an stored procedure to select some records.[详细]
2023-01-06 12:21 分类:问答Grails named queries
I started to write a simple nam开发者_Go百科ed query in Grails, but it says missing method on the domain for the named query. Am I doing something wrong? I referred the documentation and found no prob[详细]
2023-01-05 07:10 分类:问答Get list of named queries in NHibernate
I have a dozen or so named queries in my NHibernate project and I want to execute them against a test database in 开发者_运维问答unit tests to make sure the syntax still matches the changing domain/da[详细]
2023-01-02 04:32 分类:问答How to call Named Query
I wrote a named query in the entity class Voter NamedQuery(name = \"Voter.findvoter\", query = \"SELECT count(*) FROM Voter v WHERE v.voterID = :voterID\" and where v.password= : password),[详细]
2022-12-28 13:08 分类:问答