1. Is there such thing CASE expression in JPQL? stackoverflow.comLet say there is a table: |
2. Storing conditional logic expressions/rules in a database stackoverflow.comHow can I store logical expressions using a RDBMS? I tag objects and would like to be able to build truth statements based on those tags. (These might be considered as ... |
3. NHibernate: HQL equivalent of Criteria Expression.In()? stackoverflow.comHow would you express the following Criteria query in HQL? |
4. Expressions in hibernate criteria stackoverflow.comLet's say I have a persistent class Item with a quantity field and a price field. Is there a way to build a Criteria that calculates the sum of quantity*price? |
5. NHibernate HQL Query: Expressions in the Select clause stackoverflow.comIs there any way to use expressions in the Select clause? E.g.: select u.Age/2 from User u I'm having this exception right now: NHibernate.QueryException: ',' expected in SELECT before:/ [select u.Age/2 from Business.Entities.User u] |
6. Does anyone know how to translate LINQ Expression to NHibernate HQL statement? stackoverflow.comDoes anyone know of an existing solution to translate a LINQ Expression to HQL statement? Thanks in advance to all the good samaritans out there. P.S. We already use Linq to NHibernate. However, it ... |
7. Nhibernate ICriteria and Using Lambda Expressions in queries stackoverflow.comhi i am new in NHibernate and i am a little confused. Suppose we have a product table. Let the product table have 2 columns price1 and price2. then i may query mapped ... |
8. Using Hibernate to 'order by' a column which having a expression(sum, max, ...)? stackoverflow.com |
9. Is there a library etc that walks joins in property path expression in a Hibernate Restriction property stackoverflow.comIt seems irritating that property paths that involve joins must be broken down into multiple criteria. This means that code building a HQL is considerably bloated especially when the path has ... |
10. JPQL LIKE expression on enum stackoverflow.comCan JPQL execute LIKE expressions against enums? If I have an entity Foo with an enum field bar I can execute the following in MySQL(bar is stored as a MySQL ... |
11. HQL query: how to use "is empty" expression? stackoverflow.comI am a beginner in NHibernate queries. And an easy task enters me into a stupor. Trying to get list of hotels filtering by cityIDs (where the hotels are located in) ... |
12. how to use regular expression in EJB named query stackoverflow.comI have query in mysql like SELECT COUNT(DISTINCT MOBILE) FROM TBLM_CUSTOMER WHERE MOBILE NOT REGEXP '^00*0$' AND LENGTH(MOBILE) >= 10; I am using EJB 3.0 and I want to make same query ... |
13. hql conditional expressions in aggregate functions stackoverflow.comDoes HQL support conditional expressions in aggregate functions? I would like to do something like this |
14. How to use regular expressions with Hibernate/Oracle stackoverflow.comI'm trying to implement a web service which accepts a list of strings, each of which is a regular expression. These need to be compared against six columns of a ... |
15. How to write Order by expression in JPQL stackoverflow.comPostgreSQL and MySQL offers to write expression into |
16. JPA 2.0, Criteria API, Subqueries, In Expressions stackoverflow.comI have tried to written a query statement with a subquery and a in expression for many times. But I have never succeed. I always get the exception, " Syntax error near ... |
17. Hibernate, Postgresql: Column "x" is of type oid but expression is of type byte stackoverflow.comI have a strange problem regarding the hibernate mapping containing large objects (BLOB), when switching between different databases. |
18. How to break expression into more lines in Hibernate's import.sql? stackoverflow.comIn Hibernate there is possibility to add |
19. JPA2 critera query in-expression on FK issues n select statements, where n is #values stackoverflow.comI have the same issue using hibernate against DB2 and MySQL. Here is a test: |
20. JPQL/HQL and JPA/Hibernate: boolean expression in select constructor expression not working (unexpected AST node: AND, NPE, HqlSqlWalker.setAlias)? stackoverflow.comI have a JPQL statement to return a schedule of sports games: |
21. JPQL: boolean expression in CASE WHEN needs explicit comparison with TRUE/FALSE? stackoverflow.comI had tried the following: |
22. Hibernate: is there the way to use "like" expression in filters? stackoverflow.comI use hibernate filters massively, but face the problem with using like expression together with '%' literals. So, I can use this: |
23. Criteria API: same query, different resultset types (constructor expressions) stackoverflow.comI have a method, which generates a JPA Criteria: |
24. JPA Criteria API select distinct on String Lob with Constructor Expression stackoverflow.comI have a static method that creates a criteria query: |
25. Accent in Regular Expression in Java stackoverflow.comI'd like to use Hibernate Validator to validate some columns. The problem, as I understand, is that the \w marker in java doesn't accept letters with accents on them. Is there any ... |
26. Case Expression in Hibernate Query Language stackoverflow.comi am new to NHibernate and Hibernate Query Language, i have the following two tables: |
27. JPQL: Receiving a Collection in a Constructor Expression stackoverflow.comI'm using JPQL and want to receive some normal parameters and a collection in a Constructor Expression to directly create the DTO-objects. But if the Collection is empty, I always get ... |
28. JPQL: Problems receiving a Collection in a Multiple Select Expression stackoverflow.comi'm using JPQL of JPA 2.0 and have just a simple Question. I have a Multiple Selection Expression and so i want to receive barely this: |
29. Jpa QueryBuilder Multiple expressions in where clause not working stackoverflow.comI am having an issue with creating queries with javax.persistence.criteria.CriteriaBuilder. I am using EclipseLink 2.1 and an Oracle 10g database. When building a query with multiple restrictions it will use only ... |
30. NHibernate Execute SQL Query with case expression problem stackoverflow.comi am trying to write the following sql query in HQL : |
31. HQL Expression equivalent for data types stackoverflow.comBackground : I need to create a custom like extension method for linqtohiberante to do the below, |
32. jpa 2.0 criteria api expression for sql minus stackoverflow.comHow do you create a jpa Criteria expression that is equivalent to the sql minus statement example |
33. Retrieve all Entities that contains specific letters using criteria expression? stackoverflow.comHEllo I have this scenario to search for specific user and the result that should appear is all users that contains the letters in the search text field ex. if I ... |
34. How to order results by customer expression in Hibernate/HQL/JPQL stackoverflow.comI have persistent entity Cats (id, name). I want to query all cats (using HQL/JPQL) that cats named 'Tom' were in top, i.e. order by custom expression name='Tom'. In Oracle I ... |
35. help with expression for nHibernate linq provider extension stackoverflow.comI'm working on a custom linq extension for nHibernate by extending the BaseHqlGeneratorForMethod. The technique is documented here: http://fabiomaulo.blogspot.com/2010/07/nhibernate-linq-provider-extension.html I've had success with implementing these for various types of operations, ... |
36. Inline expressions in HQL stackoverflow.comWhat is the most effective way to write this sql query in HQL |
37. How to create constant numeric value expression in QueryDSL? stackoverflow.comI'd like to create query like this with QueryDSL |
38. hibernate criteria like expression for Long coderanch.comHi, I am using Hibernate criteria for search purposes. I have an option to search the objects using its id.(primary key). This id search should be like search and not exact search. i.e If i give 1, then all objects having key start with 1 should be displayed. In my pojo this id is Long. (if i concat % to this ... |
39. hibernate expression query week of the year coderanch.comHi there, I'm using JBoss 4.0.5 and it built in Hibernate 3. Into a POJO I have the following query, which should returns me all objects having the same district id and matching week of the year: @NamedQuery(name = "findShiftByWeekAndDistrict", query = "FROM Shift s WHERE week(s.week) = :weekInput AND district = :mrgreen: istrictInput") from the ejb, I call it using ... |
40. Hibernate : Restrictions Vs Expression coderanch.com |
41. HQL: how to use collection value expressions? coderanch.com |
42. How to ignore the time in criteria.add(Expression.eq("",")) forum.hibernate.org |
43. Using Regular expression in entity query - Is it possible?? forum.hibernate.org |
44. discriminator-value with logical expression forum.hibernate.orgHi Is it possible to write discrimination-value with 'or' expression? I have one table witch I want to map in three class, for instance A,B,C. Class B and C extends A. The problem is that one row in table can be both B and C. I'd like to use subclass tag with discriminator-value attribute but I don't know how to write ... |
45. Ordering by an expression with Criteria API? forum.hibernate.orgyou need to subclass Order: Code: public class SQLOrder extends Order { private static final long serialVersionUID = 1L; private final static String PROPERTY_NAME = "uselessAnyways"; private boolean ascending; private String sql; protected SQLOrder(String sql, boolean ascending) { ... |
46. Postgres conditional expressions in Hibernate Query Language forum.hibernate.org |
47. The problem using ORDER BY and expression (CASE WHEN THEN ) forum.hibernate.org |
48. Multiple columns on a count expression forum.hibernate.orgHello there! I need to do a count using multiple columns but I get the following error: expecting CLOSE, found '(' I searched a lot about this issue and my conclusion is that hibernate does not support count(distinct t.col, t.col2) or something like that. The table I want to do this count has a composite id and once this is a ... |
49. Criteria Left Join with additional "ON" expression forum.hibernate.org |
50. Expressions in JDBC Connect fields forum.hibernate.orgCan we use an expression language to set parameters to JDBC at run time? In particular we want to make changes to the URL to add arguments, and to change the Username and Password values from the typical proxy user and password to an actual logged in user's username and password. We would want to get the values from the current ... |
51. creating a select count(*) expression with JPA criteria forum.hibernate.orgI need to build a select count(*) expression using JPA criteria. I know HQL supports this kind of query select country, count(*) from census c group by c.country I don't know how to create a count(*) expression using the JPA CriteriaBuilder. The JPA builder has a count method Expression |
52. ORA-00936: missing expression with a Query - Hibernate 3.3.2 forum.hibernate.orgHello, I have a stange error with this HBM query : Code: |
53. Reverse Engineer regular table filter regular expression forum.hibernate.orgAfter realizing reverse engineering table-filter does not support full regular expression, I modified my reveng.xml: My reverse engineering xml should get tables starting with name (AA_) (BB_) but excluding tables ends with (_ID), as such: |
54. Date object and constructor expressions forum.hibernate.orghi I was recently using constructor expressions in my hql queries and was supprised to see that selecting a field in an entity in this way of type java.sql.Date returned me an object of type java.util.Date. Have anybody else encountered this issue..? or can somebody explain me why this is the expected behaviour, if thats the case..? cheers Rasmus |
55. how to use the hql expression "hour(date)" forum.hibernate.org |
56. MappingException: write expression must contain exactly one forum.hibernate.orgI am using Hibernate read/write properties to decrypt and encrypt data while reading and writing. I am able to read the values but I am unable to write data into DB. My configuration would be something like below, followed by the exception stacktrace that is noticed Code: |
57. Expression.isNull("field") returns all records forum.hibernate.orgcriteria = session.createCriteria(WorksheetHeader.class).add( Expression.eq(WORKSHEET_ID, new Integer(worksheetID))); criteria = criteria.createCriteria("products"); criteria = criteria.add(Expression.isNull(PRODUCT_ID)); |
58. Expressions and data types - can I just use Strings? forum.hibernate.orgI'm trying to use the QueryByCriteria API to allow users to build dynamic queries. Basically, I'm presenting them with a drop-down that contains all the tables/column that they're able to search on. Then they're presented a drop-down of expressions (i.e. <, >, =, !=) and finally a text box for the value they want to search for. I noticed that when ... |
59. problem with criteria / expression forum.hibernate.orgI have a mapping many to one fairly standard I think a "titles" class with a genre property which is an instance of a genre class |
60. Expression.in problem forum.hibernate.org |
61. IN expression follow by a SELECT forum.hibernate.orgHye, I'm a newbie and have a trouble with the following query : List list = session.find("from Pelftvllotpn A where timestamp(A.ddlanpn,A.dhlanpn) in (select timestamp(X.ddlanpn,X.dhlanpn) from Pelftvllotpn X)"); An exception is thrown about the second timestamp : select timestamp(X.ddlanpn,X.dhlanpn) from Pelftvllotpn X. It is : "undefined alias: timestamp ..." However, the following query works : List list = session.find("from Pelftvllotpn A where ... |
62. Using expressions in select forum.hibernate.orgHi, I have a table with three int fields (a,b,c) and want to get the sum of them in a select this way: select a+b+c as result from table It seems that you cannot use expressions in the select, but only in the where clause. Is there a possibility to do such a select? TIA, Thorsten |
63. Create Expression for associations without createCriteria. forum.hibernate.orgHi, Is it possible to create an expression on attributes of an associated object by using just Expression and not createCriteria() for the association ? I'd like to keep the layer in my application that constructs the expressions free from the Criteria stuffm and just pass in a collection of Expressions for the query. If I use createCriteria, I have to ... |
64. 'case' expression in SQL-statement forum.hibernate.orgHello! I'm using hibernate2.1 and firebirdsql (dialect=net.sf.hibernate.dialect.InterbaseDialect). I have problem for inheritance. I have 3 classes - Person and Organization inherits Subject (joined-subclass). For expression: session.load(Subject.class, new Integer(1)); , hibernate generates next SQL-query: select organiza1_.ID as ID0_, organiza1_.FULLNAME as FULLNAME2_0_, organiza1_.BRIEFNAME as BRIEFNAME2_0_, organiza1_.ORGPHONE as ORGPHONE2_0_, organiza1_.ORGMAILTO as ORGMAILTO2_0_, organiza1_.ID_PARENT as ID_PARENT2_0_, organiza2_.ID as ID1_, organiza2_.FULLNAME as FULLNAME2_1_, organiza2_.BRIEFNAME as BRIEFNAME2_1_, ... |
65. negation of an expression forum.hibernate.orgHello, In my application a have a Project class with a collection of Persons. I want to present a list of Persons in the database which are not in this collection, so if I have 4 Persons in the database and I have a project which has person1 in it's collection, I want to show person2 till person4. Therefore, I've made ... |
66. Expression missing a "NotEquals" method? forum.hibernate.org |
67. Many to Many expression in HQL forum.hibernate.orgI have a many to many relationship between two tables A and B. I am trying to figure out how to write a HQL statement for the following scenario : Table a with attribute id and att1 Table b with attribute id and att2 The persisters for the two have a collection for the other ie a.b's and b.a's Now how ... |
68. SybSQLException: Select expression results in more than one forum.hibernate.orgPosted this bug report a week ago, but still no luck/responses. Anyone with ideas how to attack this one? I'm using Sybase ASE 12.5 and Hibernate 2.1.2 seems to have introduces a couple of annoying bugs. I went back to beta 6 last night and it work fined. Therefore, I'm pretty sure the following two items represent 2.1.2 bugs. Hope someone ... |
69. What is difference between Expression and Criterion ? forum.hibernate.orgHi, I'm a hibernate beginner. I read a documented linked here. About Data Access Layer - "http://www.ociweb.com/jnb/jnbNov2003.html" -. And I found some deprecated(?) API Criteria.add(Expression) used until version 2.1beta-2. Criteria.add(Criterion) used from 2.1beta-3, but I couldn't find any description about this change, so compile error occurred. Have you ever been this problem ? I want to use "Data Access Layer..". Help ... |
70. What is difference between Expression and Criterion ? forum.hibernate.orgHi, I'm a hibernate beginner. I read a documented linked here. About Data Access Layer - "http://www.ociweb.com/jnb/jnbNov2003.html" -. And I found some deprecated(?) API Criteria.add(Expression) used until version 2.1beta-2. Criteria.add(Criterion) used from 2.1beta-3, but I couldn't find any description about this change, so compile error occurred. Have you ever been this problem ? I want to use "Data Access Layer..". Help ... |
71. What is difference between Expression and Criterion ? forum.hibernate.orgHi, I'm a hibernate beginner. I read a documented linked here. About Data Access Layer - "http://www.ociweb.com/jnb/jnbNov2003.html" -. And I found some deprecated(?) API Criteria.add(Expression) used until version 2.1beta-2. Criteria.add(Criterion) used from 2.1beta-3, but I couldn't find any description about this change, so compile error occurred. Have you ever been this problem ? I want to use "Data Access Layer..". Help ... |
72. AnyOf in Expression forum.hibernate.org |
73. outer or full join must be followed by path expression forum.hibernate.orgI read the posts here, and tried the documentation, so I'm feeling really dense. I just can't figure out a left join. This is how I would do it in pure SQL: select timeslot.queuesize, timeslotdelta.actualQueueSize from timeslot, linkdayplanlocation left join timeslotdelta on timeslotdelta.timestart = timeslot.timeslotstart and timeslotdelta.linkid = linkdayplanlocation.id where linkdayplanlocation.dayplanid = timeslot.dayplanid and linkdayplanlocation.linkactivedate = '2004-04-10' and timeslot.timeslotstart = '1970-01-01 ... |
74. Missing expression error when collection is empty forum.hibernate.org |
75. how to use Expression.in() for a collection? forum.hibernate.orgI'd like to know how to make a criterion for deciding whether my object is the element of a collection of a Hibernate object. E.g. A class has Collection props containing Property object. I'd like to know my Property q is the element of A.props. How can I ask it? thanks for help. Thomas |
76. Criteria API suggestion (IN expression) forum.hibernate.orgwhat i want to do is something similar to: q=s.createQuery("from Kitten k where k.parent in (:cats)"); q.setParameterList("cats", catsCollection); catsCollection contains Cat entities (not IDs!).. this works flawlessly and is great.. Now I'd like to do the same with the criteria API, but the InExpression class insists that I specify a property name.. I know its possible to do it like this: ... |
77. Outer Join Error - path expression forum.hibernate.org |
78. Conditional Search using Criteria and Expression forum.hibernate.org |
79. Expression.ilike forum.hibernate.org |
80. Using Expression.in() with named paramaters forum.hibernate.orgHi, I've had a look and I beleive you can't use the Expression.in(String, Object[]) with named parameters in named queries. If I could say in my named query: from User user where user.email in (:emailList) And then substitue the 'emailList' named parameter with this code: String[] emails = { "foo@bar.com", "bar@foo.com"}; List results = session.getNamedQuery("getUsersByEmailAddress") .setIn(Expression.in("emailList", emails )) .list(); Or maybe ... |
81. expression in aggregate function - SQLQuery problem forum.hibernate.org |
82. Expression methods forum.hibernate.org |
83. outer or full join must be followed by path expression ERROR forum.hibernate.orgHello. I've got a problem with outer join. There are 2 tables: TABLE_A id | NAME =========== 1 | Mark 2 | Kate 3 | Adolf 4 | Benito TABLE_B id | SPORT =========== 1 | Football 2 | Volleyball and there an application, where I can set what sport do they like (by checkboxes: I pick a name, and I ... |
84. Outer or full join must be followed by path expression forum.hibernate.orgNewbie Joined: Tue Jul 20, 2004 12:27 am Posts: 8 Hi, I get the following exception......i have removed the mappings from the Item.hbm.xml and Misc.hbm.xml files.......can somebody help me in fetching data using joins......code is shown below.....Application perfectly works without join relationship..... I am using MySql4.1, JBoss 3.2.3, Hibernate2.1.4 14:56:31,403 ERROR [STDERR] Hibernate Exceptionouter or full join must be followed by ... |
85. Expressions in the SELECT clause forum.hibernate.org |
86. Node selection expressions forum.hibernate.orgHi guys. This is only tangentially related to Hibernate, hope it's okay in the Miscellaneous section. I'm finding myself in need of a little expression language for selecting nodes in my object graph. Since my object graph happens to be a tree, I was thinking that xpath might make a good choice. I might be able to write a custom object ... |
87. Arithmetic expressions in aggregate functions forum.hibernate.orgFull stack trace of any exception that occurs: net.sf.hibernate.QueryException: , expected in SELECT [ select sum(sq.maxToSend) - sum(sq.sent) from com.tunisiana.mytunisiana.model.SmsQuota as sq where sq.account.id = ? and current_date >= sq.startDate and current_date <= sq.endDate and sq.maxToSend > 0 and sq.sent < sq.maxToSend order by sq.priority desc ] at net.sf.hibernate.hql.SelectParser.token(SelectParser.java:169) at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87) at net.sf.hibernate.hql.ClauseParser.end(ClauseParser.java:114) at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:143) at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) ... |
88. outer or full join must be followed by path expression forum.hibernate.orgHibernate version: 2.3.1 Hi i have a doubt with a external query where i use a SQL string and the class Query , this is my function : public List obtenEjecutivosXGrupo(String[] parametros) throws HibernateException{ ResourceBundle bundle; bundle=ResourceBundle.getBundle("resources.GlobalExceptions"); if(parametros==null && parametros.length!=4 && parametros[0].trim().length()==0 && parametros[1].trim().length()==0 && parametros[2].trim().length()==0){ throw new IllegalArgumentException(bundle.getString("cat.obtenEjecutivosXGrupo.errParams")); } try{ String strQry=" SELECT G.id.flGrupo, G.dsGrupo, U.id.idPersona, U.fgEstatus, P.paterno, P.materno, P.nombre,U.flCampania,C.dsCampania ... |
89. how to give Intersect clause in criteria 's expression forum.hibernate.org |
90. Creating "or" expressions w/ Criteria API? forum.hibernate.org |
91. Oracle Functions in Criteria Expression forum.hibernate.orgHibernate version: 2.1 I am trying to do something in the Crieria API that works great in HQL Here is the HQL version: "from Product prod where prod.year = currentyear()" currentyear() is an Oracle function that returns the current year Now, I want to move this query into the Criteria API. Here's my attempt that doesn't work: .createCriteria(getSession(),Product.class) .add(Expression.eq("year","currentyear()")) .list(); This ... |
92. Problem of using multiplication sign (*) in hql expression forum.hibernate.orghi, When i execute the following hql statement: Code: hql = "SELECT " + "a.employee.fname," + "AVG([b]a.scoreItemA * a.coefficient[/b])," + "SUM(a.sumItemB)," + "SUM(a.sumItemC) " + ... |
93. outer or full join must be followed by path expression ?! forum.hibernate.orgSession s=HibernateLocalUtil.currentSession(); Transaction t=s.beginTransaction(); String sql="select p.ProjectCode,a.Name from com.digitalchina.gx.common.bean.PubProStatus p left join com.digitalchina.gx.common.bean.PubApplyProinfo a where p.ProjectCode=a.ApplyCode"; List list=s.createQuery(sql).list(); ... |
94. Expression.like being ignored. forum.hibernate.orgHi, My database is mysql4.1.1, when I query it with just one 'like' expression, it works fine, eg: Criteria criteria = session.createCriteria(npd.hibernate.Plant.class); criteria.add( Expression.like("genus", plantForm.getGenus() +"%" )); list = criteria.list(); The sql that's generated is: Hibernate: select this.id as id0_, this.active as active0_, this.genus as genus0_, this.species as species0_ from plant this where this.genus like ? order by this.genus asc, this.species ... |
95. does Expression eq has case insensitive verison forum.hibernate.org |
96. mathematical expressions in HQL select clause forum.hibernate.orgof course, i've tried, it didn't run giving: aggregate function expected before ( in SELECT [select (1 / suggestion.numberOfAuthors) from ots.domain.Suggestion as suggestion] when i change the query into this select sum(1/suggestion.numberOfAuthors) from Suggestion as suggestion it worked. in fact this was what i wanted. i was just trying withot aggregate functions before it gets too complicated. now again there seems ... |
97. Criteria API and the OR Expression forum.hibernate.orgHello, I'm using the Criteria API and i Need to produce such SQL from Foo f where a=? and (b=? or b=? or b=? or b=?) but i only managed to produce that from Foo f where a=? and (((b=? or b=?) or b=?) or b=?) Is it possible to limit the brackets ? I'm also obliged to limit the size ... |
98. Add to documentation - 11.x Path Expression forum.hibernate.org |
99. How to query using a collection: Expression.in() and QBE forum.hibernate.orgHibernate version:2.1.8 Oracle 10g Java 1.5 I have a collection (Set) of objects |
100. can use expression: select new classname with createSQLQuery forum.hibernate.org |