1. Using TRIM in HQL Queries - Hibernate forum.hibernate.orgI want to use TRIM function in my HQL. This is the query in SQL form: select A.CODE, trim(A.DSCR) from CODETABLE A where (A.CONDITION='100') order by trim(A.DSCR) I want to write this query in HQL. This is my code in Hibernate: StringBuffer qryStr = new StringBuffer(); qryStr.append("Select A.CODE, trim(A.DSCR) "); qryStr.append(" from CODETABLE A "); qryStr.append(" WHERE A.CONDITION = '100' "); ... |
2. how to do this query using HQL ? forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.0.3 PostgreSQL Problem: supose the follow classes A, B e C: ==================================================== A "has one" B A "has many" (a collection) of B B "has many" (a collection) of C C "has one" int value ==================================================== So, in example we have: ==================================================== public class A { private B b; ... |
3. HQL query.... forum.hibernate.orgI need help generating an HQL query : String queryString = "from A_B_Link inner join"+ "A on A_B_Link.A_id=A.id "+ "B on A_B_Link.B_id=B.id" The equivalent SQL query would be" select * from A, B where A.id=A_B_Link.A_id and B.id=A_B_Link.B_id; Since I used Eclipse to generate POJO classes for my tables, I have many-to-many mapping for tables A and B.... so I have A.java ... |
4. Can i Use parametric in Query in HQL forum.hibernate.orgString hql = "select order.id, sum(price.amount), count(item) from Order as order join order.lineItems as item join item.product as product, Catalog as catalog join catalog.prices as price where order.paid = false and order.customer = :customer and price.product = ... |
5. Can Query translator ignore part of hql while parsing? forum.hibernate.orgI am trying to execute this hql SELECT DATE_TRUNC('DAY', aVO.endDate at time zone 'EDT') at time zone 'EDT' FROM com.vo aVO; And it fails An equivalent sql (the one that is supposed to be generated for postgresql) works fine select date_trunc('day', end_date at time zone 'EDT') at time zone 'EDT' from vo_table; I got the date_trunc function for postgresql registered by ... |
6. how to do it in HQL query forum.hibernate.orgHi thanks to all , I know that i did not get reply from anyone of you but i have received your prays to God to help me ... so thanks alot for all of you ... I have made the query using Native Sql and here the piece of code (if anyone want to know how i wrote) Code: String ... |
7. HQL query forum.hibernate.orgHello! I am writing an application that uses Hibernate. And I need a specific HQL query: select count(distinct date(o.date)) from MyObject o; As you see, I want to select all unique dates. The problem is that date property of the class MyObject represents date and time,so if I use following select count(distinct o.date) from MyObject o; I do not get what ... |
8. HQL query how to forum.hibernate.orgAuthor Message praedos Post subject: HQL query how to Posted: Fri Sep 26, 2008 5:01 am Newbie Joined: Mon Sep 01, 2008 3:41 am Posts: 19 Hi all, Since now, I only execute simple querys but how can translate this query from SQL to HQL? SQL Code: SELECT * FROM (select ... |
9. Escaping keywords from HQL queries forum.hibernate.org |
10. Escape keywords from HQL queries forum.hibernate.org |
11. Some difficulties with this HQL query forum.hibernate.orgHi, I guess I would have the same problem with SQL, I'm a beginner for both. Anyway, here is a HQL query that seems to give me the right result: Code: @"select Parent from Parent parent join parent.Children ch where (ch.Type ... |
12. MySQLSyntaxErrorException: Can't use HQL to build queries? forum.hibernate.orgHi, I'm trying to use Hibernate to access a table I created into a local MySQL 5 instance. I've tried various diferent HQL statements, even a simple "from SakaiEvent sakaievent", but all of them end in the same error. I also tried all possible MySQL dialects listed here: http://www.hibernate.org/hib_docs/v3/re ... l-dialects plus org.hibernate.dialect.MySQL5Dialect, all with the same result. The only way ... |
13. Escaping HQL keywords in queries? forum.hibernate.orglittypreethkr: Thank you so much, you have no idea how glad I am to get that solved. I had been using square brackets in the hibernate mapping, not backticks, and I guess it was confusing the HQL parser even though it worked in other situations. Switching to backticks in the mapping solved the problem. Thanks! |
14. Queries from HQL forum.hibernate.orgSession sess = factory.openSession(); Transaction tx; try { tx = sess.beginTransaction(); //do some work ... tx.commit(); } catch (Exception e) { if (tx!=null) tx.rollback(); throw e; } finally { ... |
15. HQL query. forum.hibernate.org |
16. HQL Query forum.hibernate.org@Entity public class CustomerTransaction implements Serializable{ /** * */ private static final long serialVersionUID = -7177554785463001529L; private long id; private double amount; private String description; private Date date; ... |