1. Hibernate criteria DB2 composite keys in IN clause stackoverflow.comHibernate criteria, using DB2 dialect, generates the following SQL with
composite keys in the |
2. Hibernate generating wrong SQL (composite key of composites) forum.hibernate.orgAuthor Message kwutzke Post subject: Hibernate generating wrong SQL (composite key of composites) Posted: Sat Sep 04, 2010 7:49 am Beginner Joined: Thu May 20, 2010 12:31 pm Posts: 28 Hello, I'm using a table that has four columns as primary key, with pairs of two columns each referencing another table via composite FK (MySQL 5.1). Both references are ... |
3. HQL inequality operator on composite-id generate wrong SQL forum.hibernate.orgI can't find any thread/issue on this looking in the forum or jira. inequality operator used on a composite-id generate the corresponding sql using AND instead of OR (behaviour tested using hibernate 3.2.7 DB H2/Oracle) mapping snippet: Code: |
4. Bad sql generated by OneToManyPersister with composite key forum.hibernate.orgNewbie Joined: Fri Aug 20, 2004 1:13 pm Posts: 10 Hibernate version:2.1.6 from cvs Name and version of the database you are using:sqlserver2k I am seeing a problem wherein the sql generated for a eager load collection is wrong. Specifically, hibernate appears to be reversing the sense of the keys when it creates the prepared statement. Look at the statements below ... |
5. NonUniqueResultException: Generated SQL on composite-id forum.hibernate.orgNonUniqueResultException: Problem with generated SQL on composite-id mapping. I would like to select one document by the document id. I get an error with the following code: Criteria lCriteria = lSession.createCriteria(Document.class); Document lDocumentExample = new Document(); lDocumentExample.setDocumentID(aDocumentID); lCriteria.add(Example.create(lDocumentExample)); lDocument = (Document) lCriteria.uniqueResult(); But it works with the following code: lDocument = (Document) lSession.get(Document.class, aDocumentID); Why does the first statement generate the ... |
6. Invalid SQL for HQL where referencing a composite id forum.hibernate.orgHibernate version: 3.0.1 Mapping documents: Code: |
7. return-join and composite elements in native sql forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: Mapping documents: Code between sessionFactory.openSession() and session.close(): Full stack trace of any exception that occurs: Name and version of the database you are using: The generated SQL (show_sql=true): Debug level Hibernate log excerpt: Problems with Session and transaction handling? Read this: http://hibernate.org/42.html Hi All, I cannot find a solution ... |