Since it is part of the transaction, the transaction should take care of committing
it. Does it
not work that way? In case you are having problems you caould always try this -
try {
// call the helper class methods
connection.commit();
} catch (SQLException e) {
throw EJBException();
}
But then, I don't think you need to do this.
--
thanks,
Rama
********************************************************************
I've got plenty of common sense. I just choose to ignore it.
- Calvin
********************************************************************
Pooja Keswani wrote:
> Hi,
> Thanks for the solution.
> I tried this. but it will require explicit commit if no exception occures. how do i
>do it?
> Pls reply soon.
> I'll appreciate it.
>
> On Fri, 19 January 2001, G Ramasubramani wrote:
>
> >
> > Pooja,
> >
> > In your getDBConnection method you need to do this change -
> >
> > connection = ds.getConnection();
> > connection.setAutoCommit(false);
> >
> > Also, in your ejbCreate() method you better close the connection in a
>finally{} block.
> >
> > This should take care of the issue.
> >
> > Rama
> >
===========================================================================
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".