1. Hibernate HQL Query : How to properly use ANY function in where clause? stackoverflow.comI'm struggling to understand my error in an HQL query: |
2. Incorrect usage of STR() function in HQL stackoverflow.comWith this HQL query: |
3. JPA Query MONTH/YEAR functions stackoverflow.comHow can I write a JPA query using |
4. How to construct advanced Hibernate Query with OR and summarize functions stackoverflow.comI have a rather complex query which works in SQL, but I would like to express this in HQL for portability. I'm going to fetch a user configured preference value if ... |
5. hql rank function, select in select causes antlr exception stackoverflow.comI'm trying to make the following hql query work, but with no success. I'm trying to find out what rank has a specific user, dependent on a field value in a ... |
6. Is it possible to have a sub-select in a HQL dateAdd function? stackoverflow.comI am having some trouble with a HQL dateAdd function in Hibernate 3. In the following code I want to get all matters which have a lastTimeDate greater then the maximum deadline ... |
7. How to use in hibernate user-defined-function done is sql (and still have pagination) stackoverflow.comI need to run a query that uses a function I created on the Oracle SQL(10g) database.
|
8. JPA Criteria API. Query with sql function call which takes parameters stackoverflow.comI'm trying to construct this query using Criteria typesafe API: |
9. [JPA/TOPLINK] is the function "lower" supported in "order by" clause? if not, how.... coderanch.comIn EJB-QL I can use lower() or upper() in where clause. But there is always a parse exception thrown when i tried to use it in main clause or order by clause. works: select s from Student s where lower(s.name) like 'm%' exception thrown: select s from Student s where s.name like 'm%' order by lower(s.name) OR ----------------------------------------------------------------------------Why i am asking ... |
10. Problem calling Query using a function ... forum.hibernate.orgI have a function that calculates the distance between 2 strings. Doing so with various fields, I can calculate whether 2 users are the same/similar or not, by doing this in the "MS SQL Server Management Studio" (see discussion here). Code: with Search_distances as ( select dbo.LEVENSHTEIN (USEARCH.logonuid, :logonuid) distance_logonuid, dbo.LEVENSHTEIN (USEARCH.firstname, ... |
11. Using Informix TODAY built-in function in where clause forum.hibernate.orgI'm using Hibernate 3.3.2GA against an Informix 11.5 database. Records are begin- and end-dated in this database, so I want to define where clauses for a few classes to limit the retrieval to only active records, which would look like this: Code: |
13. order by clause with user-defined function forum.hibernate.orgWe have a Family Hibernate Entity. This entity has(among others) 4 booleans properties. When retrieving the Families from the Postgres 8.4 DB, it is required that the List of families be ordered by sum of the boolean properties. There are 2 other fields in the order by criterion. Eg Code: select fam.a, fam.b, fam.c, fam.d, fam.e from family fam ... |
14. scalar functions in native SQL queries? (to_char) forum.hibernate.orgI wonder if anyone can tell me how to use a function such as to_char in Oracle in a native SQL query? I want to execute the following query: Select sum(t.personligtmeddelandetyp) as PERSONLI2_0_, to_char(t.skapatdatum, 'YYYY') as AVSENDARE0_, to_char(t.skapatdatum, 'MM') as MOTTAGARE0_ from personligtmeddelandesok t group by to_char(t.skapatdatum, 'YYYY'), to_char(t.skapatdatum, 'MM') It works fine when a execute it in a SQL*plus. When ... |
15. .class property does not function in polimorphic queries forum.hibernate.org |
16. Query parser complaints about SQL functions? forum.hibernate.orgThis was previously mentioned in December 2003 in this thread here: http://forum.hibernate.org/viewtopic.php?t=926173 Basically, the query parser complains about certain common sql functions, particularly those to do with full-text searching. In the example above, the function was mySQL's match() function. In my problem, it is the MS-SQL equivilent, contains(). Both the match() and contains() function take two arguments, which seems to be ... |
17. Order By problem with Oracle/Aggregated functions with MySql forum.hibernate.orgHibernate 2.14 Oracle 8.17 MySQL 3.23.49 I am having problems with ORDER BY with Oracle and MySQL I am attempting to use the following HQL. select new RankedCompetencyView( avg(cp.score), a.name, comp.description) from Candidate c join elements(c.candidateProfiles) cp join c.nextPosition np join np.currentGrade a join cp.competency comp group by a, comp order by a // avg(cp.score) |
18. Find query function .... Question forum.hibernate.org |
19. How to use oracle decode function or something like this forum.hibernate.org |
20. hql and sql functions in group by forum.hibernate.orgrelease : last hibernate3 cvs (today) I play with hql and group by and this query : select substr(human.nickName,1,3),count(*) from Human human group by substr(human.nickName,1,3) work with old parser, but doesn't work with new (AST) parser I try next workaround in hql.g (line 332) ( "by"! expression ( COMMA! expression )* )? except : ( "by"! path ( COMMA! path )* ... |
21. query and bit functions forum.hibernate.org |
22. HQL query using functions forum.hibernate.orgHI, Thanks for your help, I still didn't get it to work. Previously I have tried what you suggested from myobject as analias where analias.columnA = 1 and analias.columnB IN(my_function()) but this throws a JDBC exception. ORA-00932: inconsistent datatypes: expected NUMBER got IDS_ARRAY I know that the end of the sql query should look something like this select * from table(my_function()) ... |
23. How does hibernate handl sql-functions in hql-where clause? forum.hibernate.org |
24. Queries on Oracle Functions forum.hibernate.orgHello all, I am trying to do a query from an Oracle function and am tearing my hair out trying to figure out the answer. I am using Hibernate v2 and want to find the result from the following: Code: SELECT pkgName.pkgFunction FROM dual WHERE rownum = 1 Basically there is a Oracle Package that contains a Function I need to ... |
25. How to order agregate functions? forum.hibernate.org |
26. Using distinct function in SQLQuery with other MySQL funcs forum.hibernate.orgThe second approach I mentioned yeilds the following error: "column id0_ not found". I have seen this error before and posted it on the forums. Various techs have attempted to answer this question, but I am still at a loss as to how I can format this style of query. Again, all I want to do is execute the following query, ... |
27. Named query using internal function forum.hibernate.orgHi, guys. New to the forum. I have a problem using a named query, located in the class mapping file. Here's the mapping file: Code: |
28. Realod function in a join query forum.hibernate.org |
29. Using Mysql function AES_DECRYPT in select clause of HQL forum.hibernate.orgHi I am using the hibernate 3.2 alpha 2 I am getting an error using the AES_DECRYPT MySQL function in select clause of the HQL. The same function i am able to use in the order by clause of the HQL. Am i missing something or this function is not supported in the select clause. Reply is greatly appreciated. Here is ... |
30. Nullpointer while calling function from named query forum.hibernate.orgFollowing exception occurs while calling a function that returns SYS_REFCURSOR |
31. How To Achieve Order By Clause Functionality in Hibernate forum.hibernate.org |
32. Function calls in Criteria-based queries forum.hibernate.orgDate now = ... (date with time truncated) ... Integer resultCount = (Integer)session.createCriteria( MyEntity.class ) .add( Restrictions.sqlRestriction( "date_between_range( ?, {alias}.active_start_date, {alias}.active_end_date ) = ?", new Object[] { now, 1 }, new Type[] { Hibernate.DATE, Hibernate.INTEGER } ) ) .setProjection( Projections.rowCount() ) .uniqueResult(); |
33. hql: imbricated functions in select clause forum.hibernate.orgThe problem was the TIME_TO_SEC function... Considering the error message I got first time, I assumed the problem was that you can't open a new paranthesis inside a pair of paranthesis (the imbricated function). I modified the query and I got the exception below. So you were right... javax.servlet.ServletException: undefined alias: TIME_TO_SEC [ select viz.cliId, TIME_TO_SEC(viz.vizDataIn) from com.sm.sfa.mapping.Sfa_vizite as viz where ... |
34. double JOIN / GROUP BY / AGREGATE Function ... forum.hibernate.org |
35. Hibernate Criteria API + Order by native SQL function forum.hibernate.orgHibernate version: 3.2.1 Hi, Since I cannot find anything about how to achieve my goal in the documentation, I am trying to forums.... So, the context of the problem : in pure SQL, I have something like : select * from city where gis_distance(..) <= 50000 ORDER BY gis_distance(...); gis_distance is a DMBS-specific function, and (..) are its parameters. So, I ... |
36. Can I include a Java function in an hql query? forum.hibernate.orgBear with me... This isn't as odd as it sounds... I want to write an hql query like this: "from Person p where p.name='Smith' and p.age > 20" where 'name' is a standard Hibernate mapped and persisted field but 'age' is programmatically generated. It looks like I need to map the 'age' field in my hbm mapping in order to include ... |
37. Need help about query with a stored function forum.hibernate.orghello guys!!! I'm newbie in hibernate and my english very bad. But I'll try it. I need run a query with a stored function. The stored function is : CREATE OR REPLACE FUNCTION Civ_Genera_Xml_PROFE (PID_PROFESIONAL PROFESIONALES.ID_PROFESIONAL%TYPE, PUSUARIO VARCHAR2, PCODERROR OUT NUMBER, PTEXTERROR OUT VARCHAR2 ) RETURN NUMBER IS my question is: How I can do to mapping the create query into ... |
38. Group by functionality with Criteria forum.hibernate.orgHi, I'm very new to Hibernate and I have a question about Criteria and group by. I have a little test project up with a table that contains some data. Let's say it is possible to have duplicate entries for certain properties (in my case, usernames -- just a test :D). Anyway, I want to select rows such that no duplicate ... |
39. Registering functions to use native sql queries forum.hibernate.org |
40. 'concat' or 'group_concat' functions in HQL's SELECT clause forum.hibernate.orgHi, I have a requirement where I need to use 'concat' and 'group_concat' functions in HQL's SELECT clause but as I use them in HQL I get following errors a) "Undefine alias group_concat" b) "Undefined alias concat" The query I am using is: SELECT group_concat( concat(E.firstName, ':', a.lastName) ) FROM Employee E Group By E.department Are "concat" and "group_concat" functions available ... |
41. wish to use external sql-query with Oracle Analytic function forum.hibernate.orgIt's actually reasonably easy, if you're willing to fiddle about getting the names right!!! Just use nativeQuery.addEntity(Entity.class); As long as the field names are exact, it should work. My example uses annotations however, so not sure how this pans out in standard hibernate. An example, access code first... public List jon(){ Session session = (Session) getJpaTemplate().getEntityManagerFactory().createEntityManager().getDelegate(); SQLQuery q = session.createSQLQuery(" select ... |
42. NVL function usage in Order.asc() forum.hibernate.orgThaks for the post. I am using oracle 10g database. This DB supports NVL. I see the same issue with other oracle functions like decode also. I never used dialect. If possible could you please provide more infomation on registering function or provide the sample code. It would be of great help. Thanks. |
43. Calling oracle function from hibernate as named query forum.hibernate.orgHi, I am trying to execute a named query having a call to an oracle function. The following is the mapping |