1. Cast function for Hibernate stackoverflow.comI have tried to cast to float numbers from string in the database fields to compare with another numbers. The field in the database was String type. I have tried to ... |
2. NHibernate HQL date functions stackoverflow.comI'm writing a notification platform using C# and NHibernate. I'm having difficulties with my queries.
I have a Customer entity - which contains an |
3. How to use the CURRENT_DATE function in a hibernate criterion? stackoverflow.comI want to translate the following HQL into Criteria notation: |
4. Week(Date) Function in Grails/Hibernate Criteria stackoverflow.comi want to ask whether is it possible to get week number from date property of a domain with
Grails or hibernate Criteria ?
e.g in mysql it is |
5. Hibernate date function forum.hibernate.org |
6. please tell me!why hibenate support to_date() function ??? forum.hibernate.org |
7. @SQLInsert with current_timestamp function forum.hibernate.org |
8. Where does the date() function come from forum.hibernate.org |
9. Error using array_agg() PSQL function forum.hibernate.orgString queryString = "select new PerformanceProfile(min(sp.id), sp.category, max(sp.samplecount), array_agg(sp.toptraces)) " + "from PerformanceProfile sp where sp.operation = '" + pageName + "' and " + "sp.keytype = 6 and sp.timewidth = 0 and ... |
10. criteriaBuilder function throws No data type for node: org.h forum.hibernate.orgHello, I have this code which worked perfectly with eclipselink JPA implementation. CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder(); CriteriaQuery |
11. Mysql - hql with DATE_ADD function forum.hibernate.orgHello guys!!! I have a mysql table called INTEGRANTE with a date field mapped : Code: @Temporal(TemporalType.DATE) @Column(name = "INTE_DT_ULTIMA_RENOVACAO_SMV", nullable=true) private Date dataUltimaRenovacaoSmv; I built the following query: Code: Map |
12. Null value single row functions forum.hibernate.orgOracle has an NVL function to convert a null field to whatever you want. In the Hibernate Mapping XML file, is there a way to do the same sort of thing? How would I specify that I wanted the bean value to be populated with 0 if the column field was null, based on the following definition? |
13. using to_char function from hibernate forum.hibernate.org |
14. MySQL date functions - strange behavior? forum.hibernate.orgI am new to both the Java community and Hibernate. I am attempting to use date functions and then aggregate them. Here is what I am doing: Code: Iterator i = session.createQuery("select s.person, sum(s.viewed), sum(time_to_sec(timeEnd) - time_to_sec(timeStart))" + "from SessionTrackerN s " + ... |
15. Bug in SQL Server & Sybase date/time functions forum.hibernate.org// Get the first message that is ready to be processed from a queue. Message msg = (Message)session.createFilter(queue.getMessages(), "where ProcessAt >= current_timestamp() order by ProcessAt asc") ... |
16. SQL Cast function problem with HQL forum.hibernate.org |
17. Date functions in Hibernate 3 forum.hibernate.org |
18. HQL string functions forum.hibernate.orgAccording to Hibernate documentation length(), as well as other EJB-QL 3.0 functions, such as trim(), are supported. However, the following HQL query does not work: select length(trim(obj.ObjName)) from Objective as obj While this HQL query works (on SQL Server): select len(ltrim(obj.ObjName)) from Objective as obj Am I missing something or should the documentation be corrected? Thanks. |
19. Oracle and date functions forum.hibernate.orgQuery q = session.createQuery( "from Bank bk " + "where b.balanceDate > current_date - interval :time" ); ... |
20. Need help with using TO_DATE function of SQL while Inserting forum.hibernate.org |
21. Problems with time functions forum.hibernate.org[b]Hibernate version: 3.1[/b] The problem I'm facing is that my query doesn't work in Hibernate, i'm having trouble with the intervals, but if I type the same query in MySQL's console i get the results, has anyone faced something like this?? I'll apreciate ANY help [b]Code between sessionFactory.openSession() and session.close():[/b] [code] String sql = "select count(*) from Table a WHERE (a.closedDate ... |
22. HQL function CAST ( ... AS ... ) in criteria? forum.hibernate.orgwell... i have a string property in a table and i need to compare it with an integer either with Restrictions.eq or Restrictions.between. The property is string because i need to preserve the zeros in the beginning. I have already done this with queries using the "cast" function. Now i need to do it using criteria... I don't know what else ... |
23. How can i use casting function in HQL? forum.hibernate.org |
24. how to use null check(NVL) function in HQL? forum.hibernate.orgHi, I am using Hibernate3.0. I want to know how to use null check function(NVL). My DB is Oracle 10g.My dialect is "org.hibernate.OracleDialect". I am using named querys. If i use NVL function directly, when Null value is going for Long or Integer I got error like "can't assign Binary value to Integer". In search condition if i have three fields ... |
25. any null check(NVL) function in HQL? forum.hibernate.orgHi karthika, You haven't provided enough information, post the stack trace of the error you're getting. As for the functionality, if you check Oracle9Dialect.java in the src/org/hibernate/dialect directory of your Hibernate distribution, you will see that the NVL() function is defined and its HQL syntax is identical to SQL. Maybe you're using the wrong dialect? Cheers, Roger |
26. Postgres Equivalent HQL Function forum.hibernate.orgHi, This is the SQL query used in postgres: select distinct tag_serialno from process_instances where tag_serialno='"+tag_serialno[i] +"' and state_id='"+ prevStateid +"' and timestamp_mi('" + dt + "',start_date) <= '" + timeperiod + "';"); in the above query timestamp_mi function is used to get the timestamp difference between the current time and the time specified in the start_date column. Is there any ... |
27. Postgres Equivalent HQL Function forum.hibernate.orgHi, This is the SQL query used in postgres: select distinct tag_serialno from process_instances where tag_serialno='"+tag_serialno[i] +"' and state_id='"+ prevStateid +"' and timestamp_mi('" + dt + "',start_date) <= '" + timeperiod + "';"); in the above query timestamp_mi function is used to get the timestamp difference between the current time and the time specified in the start_date column. Is there any ... |
28. [Criteria] How to use 'to_char' pgres function? forum.hibernate.orgHello, i'm trying to create a criteria to execute a SQL query that uses the 'to_char' function from postgres. I also need to make a cast from string to integer in the query. I just can't find a way to do it using Criteria. Code: SELECT documento.id as id_documento,alunopre.id as id_alunoPre FROM alunopre INNER JOIN nucleo on alunopre.nucleo_id = nucleo.id INNER ... |
29. Problem with MySQL:DATE_SUB() function in Hibernate forum.hibernate.org |
30. HQL Date function forum.hibernate.org |
31. How to use TO_DATE SQl function with Criteria API forum.hibernate.orgWell, there's a few ways to go. Of course, the Criteria API is object based, so much depends on how many objects you have. This might easily be accomplished by creating an Accounts objects an using a greater than or less than Restriction on the salary range or date range, or whatever property you want to place a restriction on. Here's ... |
32. Hibernate not supporting DATE_ADD function using mysql forum.hibernate.org |
33. Needing Date functions for calculating difference forum.hibernate.org |