1. HQL Equivalent of SQL Contains stackoverflow.comI'm trying to write an HQL query to select objects which contain an object in a child collection.
Example:
Contest Object |
2. Hibernate HQL and Date stackoverflow.comI have a MySQL table with one of the column type as Date. In my hibernate mapping file I have mapped this column to type java.util.Date. Now in HQL while trying ... |
3. how do you enforce conditional not null check across sql columns stackoverflow.com |
4. How do I know if a date is within the certain period stackoverflow.comWe are capturing attendance data in a certain table primarily capturing the values (userId, startDate, endDate). If a person applies leave on a certain date then only startDate is filled and ... |
5. java.lang.NoSuchMethodException: java.sql.Date.(java.lang.String) stackoverflow.com |
6. Get stream from java.sql.Blob in Hibernate stackoverflow.comI'm trying to use hibernate @Entity with java.sql.Blob to store some binary data. Storing doesn't throw any exceptions (however, I'm not sure if it really stores the bytes), but reading does. ... |
7. node to traverse cannot be null (Hibernate SQL) stackoverflow.comI'm performing a SQL query through hibernate, which looks like: |
8. How to compare two dates stackoverflow.com |
9. Localizable strings in JPA stackoverflow.comTo solve the need for localized dynamic (user created, stored in db) data in my Java EE 6 project, I made a general localized string table that is capable of storing ... |
10. Get overlaped time range with conditions stackoverflow.comI m trying to make a scheduler of tasks, but I ran into a problem that don't know what to do or how to solve :S I'll try to explain as best ... |
11. What is the HQL equivalent of the following SQL? stackoverflow.comBelow is the SQL running properly on the SQL server 2008. |
12. Hibernate/Native SQL and null inparams coderanch.comHi i wonder if i could get some help regarding a small but so irretation thing. Is there a problem of using Timestamp as null in a call to a stored procedure, by using Hibernate and Native SQL to to the call. (im using this as an example, http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf -> 16.2.2. Using stored procedures for querying) Im using Spring 2.3, Hibernate ... |
13. Hibernate, Oracle DATE -> java.sql.Date, times cut out forum.hibernate.org |
14. java.sql.Date for PK!? Works well? forum.hibernate.orgLooks like the problem has absolutely nothing to do with Hibernate, so how about trying to get it working in JDBC first. P.S. Using a date as a PK column is one of the most evil things you can do to your database - only do this if you know that you will never, ever need to change your data model. ... |
15. DATE manipulation in SQL forum.hibernate.orgThe query does not return anything. Can anybody help me with this ? This is the code String queryStr = "from PasswordExpiration passObj " + " where ( passObj.lastUpdateTimeOfAttribute + :expirePeriod - :notificationPeriod ) >= :todaysdate " ; Query query = session.createQuery(queryStr); Date d = new Date(); Timestamp ts = new Timestamp(d.getTime()); query.setTimestamp("todaysdate",ts); int expirePeriod = def.getTaAttrPolicy().getDaysToExpire(); int warnPeriod = def.getTaAttrPolicy().getDaysToWarn(); ... |
16. Sql Blob type problem forum.hibernate.orgFull stack trace of any exception that occurs: [junit] null [junit] java.lang.ClassCastException [junit] at net.sf.hibernate.type.BlobType.set(BlobType.java:27) [junit] at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48) [junit] at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35) [junit] at net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:393) [junit] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:466) [junit] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) [junit] at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) [junit] at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418) [junit] at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) [junit] at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) [junit] at org.springframework.orm.hibernate.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:214) [junit] at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:177) [junit] at org.springframework.orm.hibernate.HibernateTemplate.save(HibernateTemplate.java:298) [junit] at catalog.model.dao.hibernate.PostingDaoHibernateImpl.savePostingIdentification(PostingDaoHibernateImpl.java:28) [junit] at catalog.model.dao.PostingDAOTest.testAddAndRemoveAndUpdatePosting(PostingDAOTest.java:131) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... |
17. SQL Warning: 17110, SQLState: null forum.hibernate.org |
18. Hibernate alters empty string in MS-SQL DB to space forum.hibernate.orgAuthor Message equus Post subject: Hibernate alters empty string in MS-SQL DB to space Posted: Thu Apr 07, 2005 8:40 am Newbie Joined: Thu Apr 07, 2005 8:00 am Posts: 1 HI, I'm trying to save data from a JSF GUI via Java Beans and Hibernate to a MS-SQL DB. In my DB are several fields which are are ... |
19. Native SQL using a limit number af columns forum.hibernate.org |
20. java.sql.Time problem while using Hibernate forum.hibernate.org |
21. Equivalent of SQL in forum.hibernate.org |
22. how to get the execution time of an sql statement ? forum.hibernate.org |
23. Native SQL on ORACLE 9 with date type forum.hibernate.orgi try query like your and it work fine test case (DATD is type date in database) Code: public void testNativeSql () { Session session = getSessionFactory().openSession(); List tList = session.createSQLQuery(" select" + " DATD," ... |
24. type = "java.sql.timestamp" VS type = "java. forum.hibernate.org1)In hbm i code the type "type = "java.sql.timestamp"" but in java pojo it is java.util.Date. Is it correct? /** * @hibernate.property * column = "created_date" * type = "java.sql.timestamp" * not-null = "false" * */ public Date getCreatedDate() { return this.createdDate; } 2)In the hbm the type is java.util.Date but how about in DB. Is it sure all the database ... |
25. HQL equivalent for this SQL forum.hibernate.orgHi All I am using Hibernate version 3.0 This is the SQL query I have ********************************** select obj.id, obj.name from obj, r_obj,r, usr where obj.id = r_obj.id and r_obj.r_id = r.r_id and usr.u_id='testuser' ********************************** I have 2 rows in my obj table which i want to retrieve based on the above query. So i tried to create this HQL equivalent of ... |
26. How to execute SQL querie and have hibernate return a Date forum.hibernate.org |
27. java.sql.SQLException: ORA-00020: maximum number of processe forum.hibernate.orgHi! every once in a while I get the following Exception from our Application Server. Anybody an idea what goes wrong? THX! Hibernate version: Hibernate 3.0.2 Mapping documents: Code between sessionFactory.openSession() and session.close(): Code: public List findUserConfigurationByNameAndCategory(String loginName,String mainCategory,String subCategory,String attribute) throws BusinessException { ... |
28. java.sql.BatchUpdateException: Data truncation: NULL forum.hibernate.orgHI, I have a stupid problem: I have an entity called DSTST wich has a 1:n relationship to POL. Now if I want to update my DSTST there is always popping up this exception (see bottom). I know that setting the DSTSTBO_FK option not-null="false" would help and I have also tried it already. BUT I DON'T UNDERSTAND why hibernate perfoms an ... |
29. how to get native sql String forum.hibernate.org |
30. SQL setResultTransformer support equivalent in Hibernate3.1? forum.hibernate.orgHi I read a few posts and gathered that Hibernate 3.2 will have setResultTransformer support for native SQL queries, which will be great!. Meanwhile, is there any equivalent feature in Hibernate 3.1? What I want to do is execute a native SQL query for which I dont have a java entity. And so from the result of the query I want ... |
31. Issues with java.sql.Timestamp to "TIMESTAMP WITH TIMEZ forum.hibernate.orgHibernate 3.0.5, JDK 1.4.2. I defined several Oracle columns TIMESTAMP, and I'm mapping them to java.sql.Timestamp with Hibernate. After I got the application going, I realized that I probably should have defined the columns as TIMESTAMP WITH TIMEZONE. In some situations, I'm writing to the table and reading from it in a different timezone (I know which tables that's happening in). ... |
32. java.sql.SQLException: could not reset reader -- Blobs in Hi forum.hibernate.orgHibernate version: 3.1.3 Mapping documents: [...] |
33. need help merging sql.date in hql forum.hibernate.org |
34. Get SQL/HQL string from DetachedCriteria forum.hibernate.org |
35. statistics number of sql executed forum.hibernate.orgthrantal wrote: Hello, We have done just that (automatic developer tests asserting the number of SQL queries made by a Hibernate operation), using two techniques: - programmatically turning show_sql=true, redirecting System.out and counting the number of lines starting with "Hibernate: " :) - using Statistics.getPrepareStatementCount() I think that Statistics.getPrepareStatementCount() is accurate and shows the same number as the SQLs shown with ... |
36. need help with TO_DATE in sql forum.hibernate.orgsuppose I would like to find the 'day of the week' of the first day of the millennium. Could you help me with the code? I've tried so many ways. and I also need help with the code if I would like to list all the Member(table) that were born on the first month of the year. Thank you |
37. whats the Hibernate Equivalent for this SQL forum.hibernate.orgHere's a sample performance critical query in SQL that I'm wary of porting to Hibernate Quote: UPDATE METRICS SET DOCS=DOCS+100, PAGES=PAGES+100, SIZE=PAGES+100 WHERE GROUPID=1 AND GROUPTYPE='C' AND TYPE='viewed' From what I understand , HQL can't be used on save / update methods. Basically, my question boils down to the following: 1. Is there a way to have Hibernate increment the existing, ... |