-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: JBoss crashes on hibernate query
PostPosted: Thu Sep 23, 2010 3:53 am 
Newbie

Joined: Thu Sep 23, 2010 3:36 am
Posts: 1
I am using JBoss Seam 2.2.0.GA, JBoss AS 5.1.0.GA and Oracle 10g. My application seems to be running fine except that a couple of queries are crashing the whole application. I have pasted one such query below.

Code:
@PersistenceContext
EntityManager em;

...

em.createQuery("FROM ExperimentalFactor ef").getResultList();


The JBoss seems to quietly shutdown when I make the getResultList() call with absolutely no stack trace. The last message I get in the logs is the hibernate query.


Code:
2010-09-23 03:01:48,611 INFO  [STDOUT] Hibernate:
    select
        experiment0_.EXPERIMENTAL_FACTOR_ID as EXPERIME9_1_,
        experiment0_.id as id1_,
        experiment0_.id as id21_0_,
        experiment0_.CREATED_BY as CREATED2_21_0_,
        experiment0_.CREATED_DATE as CREATED3_21_0_,
        experiment0_.DELETE_RECORD as DELETE4_21_0_,
        experiment0_.DESCRIPTION as DESCRIPT5_21_0_,
        experiment0_.EXPERIMENTAL_FACTOR_ID as EXPERIME9_21_0_,
        experiment0_.FACTOR_VALUE as FACTOR6_21_0_,
        experiment0_.MODIFIED_BY as MODIFIED7_21_0_,
        experiment0_.MODIFIED_DATE as MODIFIED8_21_0_
    from
        EXPERIMENT_FCTR_PERM_VAL experiment0_
    where
        experiment0_.EXPERIMENTAL_FACTOR_ID=?


Did anyone else ever encounter such an issue? What could potentially be going wrong?


Top
 Profile  
 
 Post subject: Re: JBoss crashes on hibernate query
PostPosted: Thu Sep 23, 2010 6:25 am 
Newbie

Joined: Thu Sep 23, 2010 4:43 am
Posts: 10
Hi,

How many elements does ExperimentalFactor table contains? if there is huge amount of data, this may result to that issue.

Another interesting thing, i noticed;

your query is select * from table,

but hibernate generates a query with contraint, why hibenate creates query with where condition?, you can evaluate this.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.