November 2011 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database

by Andrei Zaitsev (JIRA)

SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database --------------------------------------------------------------------------------------------- Key: HHH-6728 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6728 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 4.0.0.CR4, 3.6.7 Environment: MS SQL Server 2008 with Latin1_General_CS_AS collation Reporter: Andrei Zaitsev SQLServer2005Dialect changes the original query in getLimitString() to lowercase. That leads to SQLGrammarExcepton with case sensitive collation and not-lowercase table and column names. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

4
5
0 / 0

[Hibernate-JIRA] Created: (HHH-3958) Superfluous generated updates cause Violation of UNIQUE KEY constraint

by Guenther Demetz (JIRA)

Superfluous generated updates cause Violation of UNIQUE KEY constraint ---------------------------------------------------------------------- Key: HHH-3958 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3958 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.1 Environment: 3.3.1 GA, SQLServer 2008 Reporter: Guenther Demetz Priority: Minor Attachments: Testcase.jar When deleting a entire closure of objects associated over @ManyToOne within one single transaction, then on commit the FlushEventListener creates update statements on objects which are going to be deleted anyway. These update statements seems not only be useless, in certain scenarios they lead to Constraint Violation Exceptions, see the example here: @Entity public class A { public A() { } @Id @GeneratedValue private long oid; } @Entity @Table(uniqueConstraints = {@UniqueConstraint(columnNames={"assA_oid"})}) public class B { public B() {}; @Id @GeneratedValue private long oid; @javax.persistence.ManyToOne protected A assA = null; } A a1 = new A(); em.persist(a1); A a2 = new A(); em.persist(a2); B b1 = new B(); b1.assA = a1; // set unique association B b2 = new B(); b2.assA = a2; // set unique association em.persist(b1); em.persist(b2); em.getTransaction().commit(); em.getTransaction().begin(); em.remove(a1); em.remove(a2); em.remove(b1); em.remove(b2); em.getTransaction().commit(); // p6spy report: // update B set assA_oid='',version=0 where oid=1 and version=0 // update B set assA_oid='',version=0 where oid=2 and version=0 --> this raises "Violation of UNIQUE KEY constraint on all DB's which don't allow multiple null values in a unique index See testcase in attachment -- 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

13 years, 11 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HBX-1194) hibernate.hbm2ddl.auto=update works with multiple oracle schemas

by Vyacheslav (JIRA)

hibernate.hbm2ddl.auto=update works with multiple oracle schemas ---------------------------------------------------------------- Key: HBX-1194 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1194 Project: Hibernate Tools Issue Type: Bug Environment: <org.hibernate.core.version>3.6.8.Final</org.hibernate.core.version> <org.hibernate.entitymanager.version>3.6.8.Final</org.hibernate.entitymanager.version> <org.hibernate.validator.version>4.0.2.GA</org.hibernate.validator.version> Reporter: Vyacheslav if privileges are set hbm2ddl schema update searches for created tables in all db schemas which can be accessed, not only in current one. Don't create tables needed in current schema and fails to alter them. http://community.jboss.org/thread/175353?tstart=0 info level log viewing says during schema update that: table found: REALTY.DATA_EXCH_LOG table found: REALTY_NEW.FILES_AUD table found: SYSTEM.PROPERTIES_AUD table found: SYSTEM.REVISIONS Script see different database schemas and creating AUD tables in one schema scanning others: table found: REALTY.REF_RSR_ORDER_TYPES table found: REALTY_NEW.REF_RSR_ORDER_TYPES_AUD After hbm2ddl cannot find tables created in other schemas: Unsuccessful: alter table PROPERTIES_AUD add BASE_TYPE_ID number(10,0) not null Current schema is REALTY_NEW Very strange behaviour. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-6800) MySQLDialect missing Types.BINARY mapping, used by UUIDBinaryType

by Artem Gelun (JIRA)

MySQLDialect missing Types.BINARY mapping, used by UUIDBinaryType ----------------------------------------------------------------- Key: HHH-6800 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6800 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.8 Reporter: Artem Gelun In 3.6.8 there is no BINARY type mapping. Workaround: {code} public class MySQL5InnoDBBinaryDialect extends MySQL5InnoDBDialect { public MySQL5InnoDBBinaryDialect() { registerColumnType( Types.BINARY, "binary($l)" ); } } {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

3
3
0 / 0

[Hibernate-JIRA] Created: (HHH-6505) Develop "id bag"-style plural attribute support for new metamodel

by Steve Ebersole (JIRA)

Develop "id bag"-style plural attribute support for new metamodel ----------------------------------------------------------------- Key: HHH-6505 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6505 Project: Hibernate Core Issue Type: Task Components: core, metamodel Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 4.0.0.next -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

2
3
0 / 0

[Hibernate-JIRA] Created: (HHH-6526) Integrate "Id bag"-style plural attributed into persisters)

by Gail Badner (JIRA)

Integrate "Id bag"-style plural attributed into persisters) ----------------------------------------------------------- Key: HHH-6526 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6526 Project: Hibernate Core Issue Type: Task Components: core Reporter: Gail Badner Assignee: Gail Badner Fix For: 4.0.0.next -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

3
4
0 / 0

[Hibernate-JIRA] Created: (OGM-27) Make sure that Hibernate OGM works fine with Seam

by Emmanuel Bernard (JIRA)

Make sure that Hibernate OGM works fine with Seam ------------------------------------------------- Key: OGM-27 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-27 Project: Hibernate OGM Issue Type: New Feature Reporter: Emmanuel Bernard injectable unwrap / getDelegate() in particular unwrap(Session.class) / SessionFactory HibernateEntityManager.getSessionFactory() -- 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

13 years, 11 months

4
5
0 / 0

[Hibernate-JIRA] Created: (OGM-46) Make sure that all test clean their entries when they are done

by Emmanuel Bernard (JIRA)

Make sure that all test clean their entries when they are done -------------------------------------------------------------- Key: OGM-46 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-46 Project: Hibernate OGM Issue Type: Improvement Components: core Reporter: Emmanuel Bernard This does not appear to be the case. When you open a second node, some entities remain when running the test suite. -- 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

13 years, 11 months

1
2
0 / 0

[Hibernate-JIRA] Created: (HHH-4030) Implement support for native recursive query functionality of popular DBMSes

by David Cracauer (JIRA)

Implement support for native recursive query functionality of popular DBMSes ---------------------------------------------------------------------------- Key: HHH-4030 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4030 Project: Hibernate Core Issue Type: New Feature Components: core, query-hql, query-sql Environment: Hibernate 3.3.2, MSSQL Reporter: David Cracauer We have a couple of areas in our system where need to load tree structures from our database. These trees can be very deep (often 20+ levels). SQL Server 2005 introduced Common Table Expressions, a kind of in-line view that can be used recursively. These allow us to quickly get a result set like this: id, label, parentId 1, foo, null 2, foo2, 1 3, foo3, 2 4, foo4, 2 5, foo5, 4 6, foo6, 1 >From a tree like this: [1, foo] | | -[2, foo2] | | - [3, foo3] | | - [4, foo4] | | - [5, foo5] |- [6, foo6] using a query like this (not tested): with MyCTE( id, label, parentId) as ( select n.id, n.label, n.parentid from Node n UNION ALL select c.id, c.label, c.parentId from MyCTE c inner join Node n on n.id=c.parentId) select * from MyCTE It happens many times more quickly than we've been able to load the graphs with Hibernate, even using batching etc. We've tried using hibernate's built in native sql support without success. The alias injection breaks the Common Table Expression definition ( with MyCTE ), as it is a view definition and doesn't allow for the 'id as id_276' syntax, rather requiring just a column name. I know that there are several other major DBMSes that support recursive querying now. Is there a way to have support for this functionality in hibernate core? -- 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

13 years, 11 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HSEARCH-817) Make it possible to configure an alternative MergePolicy and MergeScheduler

by Sanne Grinovero (JIRA)

Make it possible to configure an alternative MergePolicy and MergeScheduler --------------------------------------------------------------------------- Key: HSEARCH-817 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-817 Project: Hibernate Search Issue Type: New Feature Reporter: Sanne Grinovero Priority: Minor Fix For: 4.0 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 11 months

2
7
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues November 2011