RE: [cinjug-users] Hibernate in JBoss vs Tomcat

["Wei Zhang" <wei.zhang@xxxxxxxxxxxxxxxxx>]

I am using Hibernate3.0, Jboss 4.0.1 and Tomcat 5.5.12. It is ok with
Tomcat. The problem is Jboss. What I studied is the same method call in
a while loop. 

        try {
            String sql = "from table where id = :id order by property1";
            Query query = getSession().createQuery(sql).setString("id",
id);
            parts = query.list();
        } catch (Exception e) {
            e.printStackTrace();
        }

Below is the time for each call with the loop in milli-seconds for Jboss
and Tomcat. You can see that somehow Jboss just takes longer. The total
difference is at the end.

Jboss   Tomcat
21      10
20      0
260     0
10      0
10      10
10      0
20      10
50      10
10      10
10      0
10      10
20      10
10      10
20      10
21      0
20      0
20      10
20      10
30      10
20      0
10      10
20      0
20      10
20      10
20      10
20      10
20      0
20      10
20      10
10      0
10      10
30      10
10      10
20      0
20      10
20      10
10      10
10      0
20      10
10      10
21      10
20      10
50      10
30      10
20      10
20      10
20      10
20      10
20      10
40      10
20      0
20      10
20      10
30      10
20      10
20      20
20      10
20      10
20      0
20      10
20      10
20      10
30      10
30      10
20      10
20      0
30      10
20      10
20      10
20      10
20      10
20      10
20      0
30      10
40      10
20      10
30      0
30      0
20      10
421     90
161     40
60      20
80      20
60      10
50      10
61      20
50      10
70      20
50      20
460     101
490     100
301     70
100     30
100     430
100     31
110     30
100     30
101     30
90      30
90      20
100     30
90      20
90      30
100     20
101     30
100     20
90      30
90      20
90      20
100     30
90      30
101     30
90      30
100     20
100     30
100     30
100     30
111     31
90      20
110     20
140     40
100     30
111     30
100     30
100     20
100     831
100     30
7682    3304 (total)

-----Original Message-----
From: Broyles, Eric [mailto:ebroyles@xxxxxxx] 
Sent: Friday, April 21, 2006 11:42 AM
To: users@xxxxxxxxxx
Subject: RE: [cinjug-users] Hibernate in JBoss vs Tomcat

Ironic that you didn't find any Jboss/Hibernate documentation since
Jboss provides professional support for it. 

I use Hibernate in Tomcat and it's been great.  I haven't tried running
the application in Jboss.

What versions are you using?

-----Original Message-----
From: Wei Zhang [mailto:wei.zhang@xxxxxxxxxxxxxxxxx] 
Sent: Friday, April 21, 2006 11:16 AM
To: users@xxxxxxxxxx
Subject: [cinjug-users] Hibernate in JBoss vs Tomcat

Hi, 

I hava an application with Hibernate classes and mapping file bundled
along with. I have Tomcat as my dev and test environment. Recently we
decide to switch to Jboss. However, when I setup everything in Jboss and
deployed the same application to Jboss, it becomes very slow. Each
database fetch takes 3 or 4 times longer for Hibernate. I searched Jboss
and hibernate document and forum and did not find a solution. 

Any help will be appreciated.
Thanks in advance for your time and comments, Zhang, Wei
(513)701-7324
Wei.zhang@xxxxxxxxxxxxxxxxx



---------
You may unsubscribe from this mailing list by sending a blank email
addressed to:
users-unsubscribe@xxxxxxxxxx

--
Find additional help by sending a blank email addressed to:
users-help@xxxxxxxxxx


---------
You may unsubscribe from this mailing list
by sending a blank email addressed to:
users-unsubscribe@xxxxxxxxxx

--
Find additional help by sending a blank email
addressed to:
users-help@xxxxxxxxxx