1. Helper in order to copy non null properties from object to another ? (Java) stackoverflow.comSee the following class |
2. Avoiding NULL object in HQL Query where clause stackoverflow.comI have an entity which might have a parent entity. I want to run this query: select entity where entity.parent.id = 9 some of the entity does not have parents (entity.parent = null) and ... |
3. Hibernate: How to set NULL query-parameter value with HQL? stackoverflow.comhow can I set a Hibernate Parameter to "null"? Example: |
4. Can I select null as a column value in HQL query? stackoverflow.comI need a list with three columns. column 1st and 3rd having values while 2nd as null. Can I do it through HQL query? I need something like this: |
5. Hibernate order by with nulls last stackoverflow.comHibernate used with PostgreSQL DB while ordering desc by a column puts null values higher than not null ones. SQL99 standard offers keyword "NULLS LAST" to declare that null values should be ... |
6. Hibernate HQL Query Null Columns stackoverflow.comI have a simple HQL SELECT query. When the columns are not null, I'm able to retrieve the records. But if one of the columns are null, I don't get that ... |
7. JPQL query --- how to use 'is null' stackoverflow.comi use the following query in JPQL to query the people whose address column is empty. List rl = ... |
8. Hibernate Criteria Query Join with Null Value stackoverflow.comI have a table called roles. Each role may belong to an organization. Roles that do not belong to an organization have a value of null. I want to find all ... |
9. Hibernate Named Query excluding null values stackoverflow.comI am using the following named query to get results from the database based on parameters I am passing from a JSP page. |
10. JPA perform part of an query if a value is not null stackoverflow.comin Java the following is a common idiom: |
11. How to query a column which value is null in JPA? stackoverflow.comI am using JPA namedQuery to select data from DB. |
12. Handling null in subquery stackoverflow.com |
13. How to include NULL using Order By with JPQL? stackoverflow.comI am trying to run such JPQL query: |
14. Hibernate Named Query is Null stackoverflow.comI have a problem with the hibernate named queries. My Entity: |
15. JPA Find Method gives null value forums.netbeans.orgHi All, Please I am trying to implement the JPA find method in a visual web application so that when an action is performed , the application uses the Customer find(Object ... |
17. HQL sort with NULL coderanch.comI don't see the point of using Java to sort if HQL does not return the row with myParentClass is null when I sort on myParentClass.name. I am required to sort from Database level, not Java level and I think would be more difficult to sort in Java level for me anyways. Now to be clear, I don't need Null to ... |
18. making hibernate query [select] using null value coderanch.comi am using hibernate 3 all i want to achieve is to make a query using select and in the where clause there is a property may be null, if this property is null at run time it throws Null Pointer Exception at the statement that set this property please tell me how can i do it . this the code ... |
19. A question about null value in "order by" forum.hibernate.orgThere is a hsql code: "select p from project p where p.manager=? order by p.company.name asc". When the "order by p.company.name asc" section is removed from the code, I will get the right result of project data. But I didn't get anything if this section is presented. And then, I find that there are some wanted project data with company null ... |
20. some times , hibernet select query return null forum.hibernate.orgHi, Some times hibernaet return null for select query, although table contain data. May I know why it is happening, I tried a lot but couldn't get any solution for it. My code is as follows String query = "select usr from User usr where usr.email3= :email and AGENT=:agt"; String[] parmaNames = new String[2]; Object[] parmaValues = new Object[2]; parmaNames[0] = ... |
21. Find by null property forum.hibernate.orgI have a MySql sql statement from a legacy php application that is the following: SELECT * FROM document WHERE category_id = '$categoryId' OR (category_id IS NULL AND '$categoryId' = '0') ORDER BY list_order; As one can see, this statement allows for the finding of documents that have no categories set to them. I'm trying to have it behave in the ... |
22. Why so many "null as" projections? forum.hibernate.org[..] , null as ROHRLEITUNGSTYP_ID , MODIFICATIONDATE , null as NENNGROESSE , null as SCHWELLENHOEHEMAX , null as BEZUGSPUNKTHORIZONTAL_ID , null as EXISTENZPUMPE , 151 as clazz_ from GL.FIRMENART union all select null as DECKELFORM_ID ... |
23. Hibernate query cache get method intermittently returns null forum.hibernate.org |
24. Handling null in queries forum.hibernate.orghi, I am fairly new to Java and hibernate so please bare with me if this is a fairly simple question. This is my scenario: select id,name from table Now i want to handle null in name. One way of handling null would be to check in the Hibernate generated class, but currently my project doesn't allow me to handle this. ... |
25. What is this query for? ...SELECT NULL AS table_cat... forum.hibernate.org |
26. Null pointer for elementcollection query forum.hibernate.org |
27. how can I use order by colum asc null first with HQL forum.hibernate.orgI have a simple query that need put the null or empty string first in result set by work with HQL , but HQL just ignore the "null first..." so this make my sorting is not correct... but the query is running very well in oracle database or with JDBC can any body help or any idea? Thanks! |
28. select generatedAlias0 from null forum.hibernate.org@Entity @Table(name = "players", uniqueConstraints = {@UniqueConstraint(columnNames={"playerId"})} ) public class Player implements java.io.Serializable { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Integer id; @Column(nullable = false) private String fullName; @Column(nullable = false) private String playerId; ... |
29. Query with null criteria forum.hibernate.org |
30. HQL query with a null parameter? forum.hibernate.org |
31. Error if a null parameter is in my order by query forum.hibernate.org |
32. select single columns including null values forum.hibernate.orgHi, with HQL I try to select single columns of a Class like select line.id, line.name, line.description from a.b.c.Line line where ... This usually works fine, also when selecting colums from many-to-one-relations, etc. Now I have a problem with nullable columns: I have 2 classes "Service" and "Provider" and have a many-to-one-relation in Service pointing to Provider (field "provider") with Provider ... |
33. Hibernate select NULL values query forum.hibernate.orgHibernate version:1.2 Name and version of the database you are using: MySQL Simple question: I have a table with where a certain attribute can be set to null. I want to write a hibernate query to return all the null listed items in the table. The MySQL code is SELECT * FROM `rights_type` WHERE parent_rights_type_id IS NULL The HQL I'm trying ... |
34. Manage query with null value forum.hibernate.orgHi, I've a problem with a query in hibernate. I want to select all object where a particular field is null. If I try to make this query "from Node as n where n.parent is null" it return an empty list of object type Node. The database table that I interrogate has this structure and the following value NODE_ID NAME HIERARCHY_ID ... |
35. Intercepter NULL previousState even with select-befor-update forum.hibernate.orgHi all, We have been using hibernate for over 6 months with great experience so far. However, I am running into a probelm which I suspect is a bug but I would like to check with other users first. Anyway, I am trying to implement an auditlog feature using hibernate interceptor following the ideas described by Kenan Sevindik's Weblog http://www.jroller.com/page/ksevindik/20050413 . ... |
36. Constants, paging and null values forum.hibernate.orgHi, I'm using hibernate 3.0.3 against an Oracle9i database, and have a few problems/questions. 1) Is there any way to set a constant instead of a bind variable in a query? For example, I'm currently having to write: Code: "FROM t1 a WHERE a.status=" + Constants.TWO; And so this is not able to be seperated out into the configuration file as ... |
37. Return null values query forum.hibernate.orgHi, I'll do that in code but I get this error: Code: 11:41:06,828 ERROR StandardWrapper[/intranet:jsp]: Servlet.service() para servlet jsp lanz excepcin org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [bbdd.modelos.tUsuarios#83645] at org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:118) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:75) ... |
38. query#setFloat() with null values forum.hibernate.org |
39. MySQL drivers 3.1.x and Null objects when querying forum.hibernate.org@Entity @Inheritance(strategy=InheritanceType.JOINED) @Table(name = "Org") public class Organization extends Party { @Transient public Long getOrgId() { return getPartyId(); } public void setOrgId(final Long orgId) { ... |
40. Passing NULL into SPs through Hibernate named queries. forum.hibernate.orgI have a set of stored procedures in Oracle 10g database which I access using Hibernate named queries. These SPs also accept NULL input parameters as well. But when I try to pass NULL objects I get the following error. -------------------------------------------------------- Data Access Failure Hibernate operation: could not execute query; bad SQL grammar [{? = call GET_KOMMUNFOR(?) }]; nested exception is ... |
41. SELECT a column as NULL forum.hibernate.orgHello I am fairly new to Hibernate . I would like to execute the following query and I am constructing a HSQL statement for it. Select value1 as X1, null as X2 from TEST_TABLE I have the TEST_TABLE mapped to a TEST_OBJECT. The following HSQL statement fails select new TEST_OBJECT ( value1Obj, null ) from TEST_OBJECT This fails with an exception ... |
42. sorting with null value forum.hibernate.orgI appreciate if you can help me with this problem... I have 2 tables: people and address, they are linked via a foreign key, say user_id, for a given user, it could have multiple addresses (rows) returned, so I'd like to sort the address search result in descending order based on the column "last_update_timestamp" in the Address table if all the ... |
43. Query with sum(..) returns null instead of expected value forum.hibernate.orgWhy is the query returning null when I execute the following code: Query query = session.createQuery("select sum(wl.hours) from WorkLog wl where wl.owner.id = ?"); query.setString(0,"myId"); Object result = query.uniqueResult(); ------------------ The query is just trying to get me the sum of hours. I'm expecting this to return a Double which is the type for my hours property. I see in the ... |
44. Select objects with null property forum.hibernate.orgHi everybody How can i select the objects where a property is null? I have a Category table: * Id, int * Name, varchar * Parent, int The parent field makes the relation between the present category and its parent, if it has one. If the category is a root category that value should be null. So how can i select ... |
45. HOWTO - HQL where clause that can be null or have a value forum.hibernate.orgLets assume I have the following HQL query: from MyObject m where m.column1 = :column1 and m.column2 = :column2 and m.column3 = :column3 It is possible in the business logic that any of the values may be null (the values are all strings). The query works fine when all the columns have values other than null. I tried using empty string ... |
46. Order by ignores null values forum.hibernate.org |
47. order by "property" is null ?? forum.hibernate.orgNewbie Joined: Tue Jan 22, 2008 8:23 am Posts: 3 i did it, the problem is that i want to page the result, (with limit ..) with little calculations i make it ;) about the union -> you can't make a that query Quote: select * from users where prop1 is not null order by prop1, laslogin asc UNION select * ... |
48. HQL and null values in the select forum.hibernate.orgI am using HQL to add a few fields from a table. Here is an example: select (foo.valueA + foo.valueB + foo.valueC) from Foo foo where foo.bar.date = :date I can then get the resulting value doing something like: Code: Double value = (Double)this.getSession().createQuery(queryString) ... |
49. HQL help: possible to "select NULL as ..."? forum.hibernate.orgYep, thats even worse... it returns data that isn't correct. If I have a table with 1 row, 3 cols: COL1 | COL2 | COL3 ---------------------- 'val1' | 'val2' | 'val3' And I run: "select COL1, NULL, COL3 from TABLE1" What I want to get back is: Object[3]{"val1", null, "val3"} But what I get is: Object[1]{"val1"} Likewise, if I said "select ... |
50. SQL SELECT NULL AS table_cat... executes very much forum.hibernate.org |
51. Query parameter that can be null forum.hibernate.orgHello Having a few issues with JPA querying at the moment and i was wondering could anybody help shed some light on it. Code: Query query = em.createQuery(" select user from User user " + " where ... |
52. SELECT * returns NULL Objects forum.hibernate.org |
53. Selecting 'column = null' produces bad sql for mysql? forum.hibernate.org |
54. 'select from table where column = null' -> bad mysql forum.hibernate.org |
55. 'select from table where column = null' -> bad mysql sql forum.hibernate.orgAuthor Message dhoyt Post subject: 'select from table where column = null' -> bad mysql sql Posted: Mon Nov 17, 2008 12:18 pm Newbie Joined: Mon Nov 17, 2008 10:40 am Posts: 3 Hello all, I'm writing a little app that uses straight JPA calls, with Hibernate as the provider and MySQL as the database. I specify org.hibernate.dialect.MySQLInnoDBDialect as ... |
56. Query return null forum.hibernate.orgWhen i do this query Criteria put my pr object to null, "usuario" and "codigo" vars found correctly, I use manually the Criteria query in mysql command line with "usuario" and "codigo" values copy directly of debug and found without problems. Hibernate version: 3 Mapping documents: Code: |
57. HQL query for "x is null or x.y = value" forum.hibernate.orgHi. I'm trying to write an hql query that does something like this: "from Data as data where (data.info is null or data.info.startDate > :timestamp)" I am working with HSQLDB. The problem is that the result ignores the cases in which data.info IS null. I've noticed that the HQL is translated to SQL like this: Code: select ... |
58. Named query with possibly-null parameter value forum.hibernate.org |
59. How to add capability of return null values from query... forum.hibernate.orgorg.hibernate.Query q = session.createQuery( "select name, description, startDate from NewsData where id=43711"); List |
60. Excluding null columns from HQL insert and update queries forum.hibernate.orgI am using hibernate annotation to map model objects to db columns, is there any configuration settings to exclude null columns from the insert/update hql queries ? Here is the scenario : I have the table of user information. Along with user information i am storing user's photo as well ( BLOB). It is not mandatory that always i need to ... |
61. sorting date column containing null values using Hibernate forums.oracle.com |