Tarun Dewan wrote:
>
> Hi All,
>
> I have send this message around 3 days back but didn't get any response, so
> i'm sending this message again.
Possibly because no-one knows the answer??
> I have created a Process in Session EJB which takes data from different EJBs
> and do some process and enter the result into 2 table through EJBs. All my
> entity EJBs are CMPs.
>
> My problem is that connection once open is not closed and after opening the
> max. no. of connections (15) allowed, it generates an error. Could somebody
> explain the problem? Pls. also specify about the Transaction and Isolation
> attributes, i.e. what are the most suitable one in this case. Before
> commiting one part of my process, I have to do 20 selects and 3 inserts in
> different tables (through Entity EJB only).
>
> Any kind of information/link will be very helpful.
Perhaps if you told the answers to these questions we could come up with an
explanation:
1. What kind of connections are you talking about?
2. What do you mean by "do some process"? How long does this process last? Which
application object (if any) lasts the same length of time?
3. What sort of EJB is "Session EJB" - stateful or stateless?
4. What sort of EJB is "different EJB"?
Most likely explanation is that you are creating 15 stateful EJBs each of which
is used once only and handgs around.
Ian McCallion
Alexis Systems Limited
===========================================================================
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".
