Sorry Shyam,
My concept was wrong....You should close the DB connection in the
same method scope.
Nittile.
> -----Original Message-----
> From: Puri, Ketan [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 22, 2000 5:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Database Connection
>
> hello,
> i have a doubt.
> can you explain, when the ejb remove method is called?
> is it not better to close the connections in the same block of code where
> they have been opened.
> why we wait for ejbRemove() method to close the connections.
> And also usually we call ejb remove method when we want to delete a row in
> the data base.
> Please correct me if i am wrong.
> thanks and regards
> ketan
>
>
> Ketan Puri
> B-26, Sector 57,
> Noida-201301
> Tel: 91-11-91 4581236-41
> Fax: 91-11-91 4581235
> Email: [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> > -----Original Message-----
> > From: Nittle Gupta [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, June 22, 2000 4:57 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Database Connection
> >
> > Hello Shyam,
> > In BMP entity beans, the callback methods are implemented. Open
> > the
> > database connection in ejbCreate() method and close it in ejbRemove()
> > method.
> >
> > Nittile.
> >
> > > -----Original Message-----
> > > From: Shyam Sankar S. [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, June 22, 2000 4:12 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Database Connection
> > >
> > > Hi all,
> > >
> > > We are working on Bean Managed Persistent Entity Beans. We got a mail
> > now
> > > from our DBA that there are around 200 sessions open in the Oracle
> > Server.
> > > This could be because our connection.close statements don't work or
> > maybe
> > > don't get called. Could anyone tell me which is the right place in an
> > > Entity Bean to:
> > > 1. Open Connection
> > > 2. Close Connection
> > >
> > > Presently, Connection is opened in the setEntityContext and closed in
> > > unsetEntityContext. unsetEntityContext is not called explicitly.
> > >
> > >
> >
> ==========================================================================
> > > =
> > > 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".
> >
> >
> ==========================================================================
> > =
> > 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".
>
> ==========================================================================
> =
> 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".
===========================================================================
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".
