[Hibernate-JIRA] Created: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
6:08 p.m.
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server with
id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
10:12 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Emmanuel Bernard commented on EJB-249:
--------------------------------------
I don't think the actual cause is the @Column(nullable=false).
Can you a minimal runnable test case where mobi.database.domain.Server with id 249 is
actually in the DB.
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
12:16 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Koda Janh commented on EJB-249:
-------------------------------
I don't have a testcase yet (I'll try generating one for you) but I suspect the
following is going on:
- I invoke em.createQuery("select user from " + User.class.getName() + " as
user").getResultList()
- Class User has a @ManyToOne relationship to class Server, so although loading a given
User is an optional operation, loading the related Server is probably a mandatory
operation somehow.
Please see the attached log (log4j with hibernate=DEBUG logging level). It should give
you more than enough information as to what is going on inside Hibernate's guts.
Please let me know whether you still need a test case or whether this log file gives you
enough information.
Thank you!
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
12:16 a.m.
New subject: [Hibernate-JIRA] Updated: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[ http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=all ]
Koda Janh updated EJB-249:
--------------------------
Attachment: stacktrace.txt
Hibernate=DEBUG logging level output showing what is going on under the hood
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
12:27 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Koda Janh commented on EJB-249:
-------------------------------
Notice the last SQL query in the log is:
select server0_.id as id1_1_, server0_.hostId as hostId1_1_, server0_.port as port1_1_,
server0_.shutdownRequested as shutdown3_1_1_, server0_.running as running1_1_, host1_.id
as id0_0_, host1_.name as name0_0_, host1_.shutdownRequested as shutdown3_0_0_ from
servers server0_ inner join hosts host1_ on server0_.hostId=host1_.id where
server0_.id=316
and when I run this query manually this yields an empty set for me too. But (!!) if you
take out the inner join on servers.hostId you get back the results as expected, so I think
this explains what is going on. Hibernate's use of the inner join implicitly assumes
that servers.hostId is not null (which it actually is for my case) and so it gets back an
empty set which it isn't expecting and so it throws an exception. The problem is
that:
The User exists, the Server it references exists but the Host that the Server references
does not (because Server.host is null).
Class server defines the following relationship:
@ManyToOne
@JoinColumn(name="hostId", nullable=false)
private Host host;
so again Hibernate is being told that hostId is not supposed to ever be null but it
actually is.
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
12:30 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Koda Janh commented on EJB-249:
-------------------------------
I just replaced @JoinColumn(name="hostId", nullable=false) by
@JoinColumn(name="hostId", nullable=true) and the exception went away so I am
100% sure the problem has to do with the @JoinColumn :)
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
8:11 a.m.
New subject: [Hibernate-JIRA] Resolved: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[ http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=all ]
Emmanuel Bernard resolved EJB-249:
----------------------------------
Resolution: Won't Fix
Ah get it. @JoinColumn has a nulllable, not @Column.
This makes sense to use an inner join in this case.
We can't really give you more details on the failure, so the exception you have while
a bit misleading is really what Hibernate knows about it.
I have created a new feature proposal to hbmlint our metamodel checker.
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
8:11 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Emmanuel Bernard commented on EJB-249:
--------------------------------------
HBX-818
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
9:39 p.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Koda Janh commented on EJB-249:
-------------------------------
Emmanuel,
The main point of the bug report was not that Hibernate should give a less misleading
exception but rather that it should throw only the declared exceptions according to the
specification. Two alternatives are:
1) Hibernate catches EntityNotFoundException in getResultList() and returns an empty list
instead (seems to best choice from a specification point of view, but harder to debug
problems), or
2) Hibernate wraps the EntityNotFoundException using IllegalStateException which is
declared by the specification (easier to debug problems but IllegalStateException
wasn't strictly designed for this sort of exceptional case)
What do you think?
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
10:20 p.m.
New subject: [Hibernate-JIRA] Commented: (EJB-249) Query.getResultList() throws undocumented EntityNotFoundException
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-249?page=co...
]
Emmanuel Bernard commented on EJB-249:
--------------------------------------
The spec does not cover such a case, so I'm happy for the current state.
Returning a null list is not the right path, it hides issues in your data.
ENFE is expected ot be raised on refresh(), getReference(), this is really what happens
but by cascade.
Query.getResultList() throws undocumented EntityNotFoundException
-----------------------------------------------------------------
Key: EJB-249
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-249
Project: Hibernate Entity Manager
Type: Bug
Components: EntityManager
Versions: 3.2.0.ga
Reporter: Koda Janh
Attachments: stacktrace.txt
I am issuing the query: "select user from " + User.class.getName() + " as
user"
and I am getting this stack-trace:
javax.persistence.EntityNotFoundException: Unable to find mobi.database.domain.Server
with id 249
at
org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:143)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
I've tracked down the problem to a "@Column(nullable=false)". Specifically,
if one of the objects in the result-set contain a null field that is defined as
"nullable=false" then the above exception will occur.
This behavior should either be documented in the Javadoc or the implementation should be
changed to throw one of the declared exceptions instead. Also, the actual error message is
misleading in that the specified object *is* found, but it violates the constraints of the
ORM mapping.
--
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
7112
days inactive
7116
days old
hibernate-issues@lists.jboss.org
9 comments
2 participants
participants (2)
-
Emmanuel Bernard (JIRA) -
Koda Janh (JIRA)