December 2012 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] (HHH-7839) Documentation bug at SimpleNaturalIdLoadAccess.getReference(Object naturalIdValue)

by Janning Vygen (JIRA)

11 years, 6 months

2
1
0 / 0

[Hibernate-JIRA] (HHH-7421) ObjectDeletedException with Session.get() and lock after read only HQL query

by Miguel Diaz (JIRA)

11 years, 6 months

2
6
0 / 0

[Hibernate-JIRA] (HHH-7848) criteria on association w/ fetch=join, get n+1 queries

by Pavan Bhatia (JIRA)

11 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] (HSEARCH-1241) Polymorphism, lazy initialization and @ContainedIn don't work well together

by Guillaume Smet (JIRA)

11 years, 6 months

2
1
0 / 0

[Hibernate-JIRA] (HHH-7835) Inefficient implementation of JarVisitorFactory.getBytesFromInputStream

by Andriy Kharchuk (JIRA)

11 years, 6 months

2
12
0 / 0

[Hibernate-JIRA] (HHH-7847) UniqueConstraint broken, unique constraint not created with HSQL

by Torsten Krah (JIRA)

11 years, 6 months

2
1
0 / 0

[Hibernate-JIRA] (HHH-465) order by nulls first / last

by Stephane Eybert (JIRA)

11 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HHH-2776) Restrictons.in(..) generates invalid SQL if list of values is empty

by Adrian Smith (JIRA)

Restrictons.in(..) generates invalid SQL if list of values is empty ------------------------------------------------------------------- Key: HHH-2776 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2776 Project: Hibernate3 Issue Type: Bug Components: query-criteria Affects Versions: 3.2.2 Environment: Hibernate 3.2.2.ga, MySQL 4.1.18, Windows XP Reporter: Adrian Smith I have classes called A and B. There is a 1:n relationship from A to B. Class B has the following in its mapping file: <many-to-one name="a" class="A" column="fk_a_id" not-null="true" /> If I write the following code: List<B> foo() { List<A> aList = .... Session session = .... Criteria query = session.createCriteria(B.class); query.add(Restrictions.in("a", aList)); return query.list(); } Then all works fine and the results I want are returned. However, if aList is empty (i.e. aList.size()==0) then the query.list function generates and executes invalid SQL for MySQL. java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1" I imagine that it is generating SQL like IN () which isn't valid. I realize it's a bit ridiculous to want to find the rows where a field is IN the empty list. Nothing will ever be returned. However, in my opinion it should still be allowed, and return no rows, just as saying "WHERE 1=2" is allowed, just doesn't return any rows. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

6
12
0 / 0

[Hibernate-JIRA] (HHH-7846) Add messages and throw NotYetImplementedException to help categorize test failures

by Gail Badner (JIRA)

11 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] (HHH-465) order by nulls first / last

by Lukasz Antoniak (JIRA)

11 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues December 2012