Hello,
Currently we are testing the performance of ejb's using WebLogic. Here we are
mainly concerned with creating connections with the database through the Entity beans.
We specified the initial capacity (number of connections) in the connection pool as
100. But it threw a Resource Exception when we started the server. In such case what
is the solution if I need to increase the number of connections to the database. I
thought over some solutions, but I would like to receive your feedback about the
same.I would like the following doubts cleared.
1. I can use Bean managed Entity bean and in each Entity bean I create a JDBC
connection to the database.
But in this case Performance is totally affected as each time I have to create a
fresh JDBC connection to the database.So this is
a bad sol.
2. Can I add connections in the connection pool (Is this possible?).
Is it possible that I use container Managed Entity bean and I check whether a
connection is available before getting RI to Entity bean. If the connection is not
available then can I add connection to the existing connection pool.
3. When is the ejbCreate called? (after establishing a connection to the db or before
establishing a connection to the db)
If a connection is established to the database before calling ejbCreate() can we
insert the code to check the availability of connections in ejbCreate. If they are not
available we can create a connection there itself.
What is the no. of connections that are limited in a connection pool.
In our application we will be accessing a third party database. Here the no. of users
that can connect to the db is limited(users in db).Does this fact also limit the
connection to db from my beans.Do I have to get more number of users who can access
the database.
Thanks and Regards,
Parikshit
_____________________________________________________________________________________________________________
Parikshit Pol
Systems Executive
KPIT System Ltd.
6,Mayur Colony,
Karve Road,
Pune-411029
e-mail :< [EMAIL PROTECTED] >
Phone : 91-020-5468654 ext. - 212
_______________________________________________________________________________________________
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
