April 2011 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-5757) OneToOne SQL missing parameter

by Martin Striz (JIRA)

OneToOne SQL missing parameter ------------------------------ Key: HHH-5757 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5757 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.6.0, 3.5.6 Environment: Hibernate 3.5.6 / 3.6.0 H2 1.2.143 (in-memory) / PostgreSQL 9.0-801.jdbc4 Reporter: Martin Striz Priority: Critical Attachments: issue-test-case.zip Hibernate fails to query OneToOne association from the non-owning side when there is a reference inside the where clause. The behaviour was observed on both Hibernate 3.5.6 and 3.6.0 and tested in H2 and PostgreSQL environments. Given two entities: {code:java} @Entity public class Frame implements Serializable { @Id private long id; @OneToOne private Picture picture; } @Entity public class Picture implements Serializable { @Id private long id; @OneToOne(mappedBy = "picture") private Frame frame; } {code} If the query is issued from the owning side of the association, everything works as expected. {code} Picture pictureRef = entityManager.getReference(Picture.class, 5L); // id exists // list Frames by Picture reference (works) List<Frame> frames = entityManager.createQuery("from Frame f where f.picture = :picture", Frame.class) .setParameter("picture", pictureRef) .getResultList(); {code} However, if the query is issued from the non-owning side, the exception is thrown. {code} Frame frameRef = entityManager.getReference(Frame.class, 3L); // id exists // list Pictures by Frame reference (crashes!) List<Picture> pictures = entityManager.createQuery("from Picture p where p.frame = :frame", Picture.class) .setParameter("frame", frameRef) .getResultList(); {code} The stacktrace produced with H2 database used: {noformat} javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255) at issue.OneToOneIssueMain.query2(OneToOneIssueMain.java:83) at issue.OneToOneIssueMain.run(OneToOneIssueMain.java:29) at issue.OneToOneIssueMain.main(OneToOneIssueMain.java:19) Caused by: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246) ... 3 more Caused by: org.h2.jdbc.JdbcSQLException: Parameter "#1" is not set; SQL statement: select picture0_.id as id1_ from Picture picture0_ where picture0_.id=? [90012-143] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.expression.Parameter.checkSet(Parameter.java:73) at org.h2.command.Prepared.checkParameters(Prepared.java:161) at org.h2.command.CommandContainer.query(CommandContainer.java:79) at org.h2.command.Command.executeQuery(Command.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) ... 11 more {noformat} -- 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

14 years, 6 months

2
3
0 / 0

[Hibernate-JIRA] Created: (OGM-41) Make it possible to grab an existing Infinispan CacheManager via JNDI

by Sanne Grinovero (JIRA)

Make it possible to grab an existing Infinispan CacheManager via JNDI --------------------------------------------------------------------- Key: OGM-41 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-41 Project: Hibernate OGM Issue Type: New Feature Components: core Reporter: Sanne Grinovero Assignee: Sanne Grinovero Make it possible to grab an existing Infinispan CacheManager via JNDI, so that multiple applications deployed in the same server can share the same CacheManager, and/or reuse the one being started and configured by the container (Like JBossAS6 provides one). -- 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

14 years, 6 months

2
1
0 / 0

[Hibernate-JIRA] Created: (OGM-29) Migrate tests to no longer need @Persister but rather use the transparent configuration approach

by Emmanuel Bernard (JIRA)

Migrate tests to no longer need @Persister but rather use the transparent configuration approach ------------------------------------------------------------------------------------------------ Key: OGM-29 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-29 Project: Hibernate OGM Issue Type: Task Components: core Reporter: Emmanuel Bernard Fix For: 1.0-next -- 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

14 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (OGM-30) Implement JPA generated value strategy for a grid

by Emmanuel Bernard (JIRA)

Implement JPA generated value strategy for a grid ------------------------------------------------- Key: OGM-30 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-30 Project: Hibernate OGM Issue Type: New Feature Components: core Reporter: Emmanuel Bernard Assignee: Emmanuel Bernard -- 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

14 years, 6 months

1
2
0 / 0

[Hibernate-JIRA] Created: (OGM-36) Make grid keys serializable

by Emmanuel Bernard (JIRA)

Make grid keys serializable --------------------------- Key: OGM-36 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-36 Project: Hibernate OGM Issue Type: Bug Components: core Reporter: Emmanuel Bernard Assignee: Emmanuel Bernard Fix For: 1.0-next -- 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

14 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-6097) Review log levels, especially related to i18n messages

by Steve Ebersole (JIRA)

Review log levels, especially related to i18n messages ------------------------------------------------------ Key: HHH-6097 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6097 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 4.0.0.Alpha2 Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 4.0.0.Alpha3 With the move to JBoss logging and its use of i18n message bundles, we have a much more clear picture of places we might be logging at too verbose of a level. Explore these places and adjust accordingly. -- 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

14 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-6112) ElementsCollection with List of Embeddables and FetchType.Eager result in wrong fetch

by Edmondo Porcu (JIRA)

ElementsCollection with List of Embeddables and FetchType.Eager result in wrong fetch ------------------------------------------------------------------------------------- Key: HHH-6112 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6112 Project: Hibernate Core Issue Type: Bug Components: annotations Affects Versions: 3.5.4 Environment: MYSQL 5, Hibernate Core and Annotation 3.5.4-Final Reporter: Edmondo Porcu Priority: Critical Dear all, a simple collection of embeddables who is not a set cannot be fetched correctly by Hibernate if one needs a fetchType.Eager . @Column(nullable=true) @IndexColumn(name="Ordinal") @JoinColumn(name = "Curve_curveName") @ElementCollection(fetch = FetchType.EAGER) private List<CurveInstrument> oisList; I have been forced to add the indexColumn to avoid fetching multiple bags at once, and this worked fine in persisting my objects. When i retrieve them from the database, however, my list contains only the first element of the collection I have persisted. @Embeddable public class CurveInstrument implements Serializable { private static final long serialVersionUID = 4797265087176461985L; private String name; @Column(nullable=true) @Type(type="org.hibernate.type.NumericBooleanType") private boolean active = false; @Column(nullable=true) private double value=0; @Column(nullable=true) private double spread=0; // Getters and setters } -- 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

14 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-6107) Metamodel dependence on ServiceRegistry

by Steve Ebersole (JIRA)

Metamodel dependence on ServiceRegistry --------------------------------------- Key: HHH-6107 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6107 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 4.0.0.Alpha2 Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 4.0.0.Alpha3 There are 2 options here: # Metadata can take a ServiceRegistry as ctor param : new Metadata( serviceRegistry ) ## this will be the short term solution # serviceRegistry.getService( Metadata.class ) ## possibly the long term solution ## pro/con: metadata lives on as part of SessionFactory (would continue to be available) ## possible first step to allowing "changes on the fly" ## maybe utilize internal caching (not our cache API) rather than simple maps to leverage disk storage capabilities of the cache (infinispan or ehcache) -- 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

14 years, 6 months

1
2
0 / 0

[Hibernate-JIRA] Created: (HHH-6115) jaxb generation should follow directory pattern

by Steve Ebersole (JIRA)

jaxb generation should follow directory pattern ----------------------------------------------- Key: HHH-6115 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6115 Project: Hibernate Core Issue Type: Task Components: build Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 4.0.0.Alpha3 Should go into generated-src/jaxb/main -- 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

14 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-6104) Criteria query on interface with projections produces unexpected result

by David Donn (JIRA)

Criteria query on interface with projections produces unexpected result ----------------------------------------------------------------------- Key: HHH-6104 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6104 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.2.6 Reporter: David Donn If you have three classes A, B and C that inherit from a common superclass D. The classes are mapped one table for each class A, B and C. When you do a count projection you get three rows returned. A count for each concrete class. It should return one row only. session.createCriteria(D.class).setProjection(Projections.rowCount()) -- 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

14 years, 6 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues April 2011