I've seen similar problems but with a slightly different setup. We can
recreate our problem within 3-5 minutes of starting JOnAS.
Setup:
WinNT SP5
Sun JDK 1.3
Jonas 2.0
Sybase 11.0.3 database
jConnect 5.2
4 clients repeatedly executed the same method on a stateless session bean
which obtained a datasource and executed a stored procedure on the Sybase
database. DB connection pooling was not used. Though it is fully appreciated
that this would improve performance, it may or may not improve the "time to
hang".
Results
While the test ran the database saw a lot of activity. Each Client made
about 3 calls per second. After about 3-5 minutes the clients hang (in mid
call?) and DB and JOnAS activity drops to zero.
Conclusion
It seems that there is some problem with the database driver or our setup,
which causes it to hang after only 3000 calls to the DB. Possibly there is a
problem with JOnAS.
Any further insight or test suggestions would be greatly appreciated.
Incidentally, we ran the same test on another EJB Server, jBoss, with
connection pooling, with better results (e.g. 5 calls/sec), though the
clients still hang in much the same way after about 35000 calls.
Peter
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Darren Young
Sent: Thursday, November 30, 2000 11:32 PM
To: [EMAIL PROTECTED]
Subject: Database connection problem?
Dear all,
We have a JOnAS server (RedHat 6.2/Sun JVM 1.2.2)
running against an Oracle 8i (RedHat 6.2) server. We
have maybe 15 entity beans deployed (or so). On a
fresh start of JOnAS a peek at the connection procs on
the Oracle machine (ps -eaf | grep <ORA_SID>) shows no
connections. At the end of a day with very little
activity the same peek shows anywhere up to 50 procs.
After a while of letting this sit, the app simply
stops responding. Restarting the JOnAS procs yields a
useable system again.
What I am not sure of is if the large number of db
connections is causing the app to fail or something
within the beans themselves.
We have the same app in our QA environment on a JOnAS
app server (Sun E250/Solaris 7/Sun JDK 1.2.2)
connecting to an Oracle 8i server (Sun E450/Solaris 7)
server. Same symptoms appear but take longer to
manifest (2 days).
Any ideas on how/where to move deeper into the
investigation?
Thanks.
=====
---
Darren Young
YoungHome.Com
Mobile: 708-275-3172
---
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
