Pooja,
I suppose that i had the same problem the last days.
What happened for me is that I obtained the connection from the JDBC driver
directly. When i replaced it by obtaining the connection from a Server
Datasource it worked fine.
(With more details, it seems that every connection is commited at the moment
u close it; in the case u use datasources from a Server connection pool when
u close the connection, the server give it back to the pool and don't close
it really)
It seems that the App Servers (Websphere in my case) can't integrate the
connections directly done to JDBC in the transactionnel contexts !!
Hope it helps
Amine
> -----Message d'origine-----
> De : Pooja Keswani [mailto:[EMAIL PROTECTED]]
> Envoyé : vendredi 19 janvier 2001 13:38
> À : [EMAIL PROTECTED]
> Objet : Re: Container Managed Transactions in Entity Beans
>
>
> Hi Jay,
>
> I m using oracle database, weblogic5.1,oracle driver.
> is there any option for autocommit? pls tell me if u know about it.
>
> cheers
> Pooja
>
>
> On Fri, 19 January 2001, Jay Walters wrote:
>
> >
> > Pooja,
> >
> > What server, database and JDBC drivers are you using? This
> almost sounds
> > like autocommit is on for the connection to the database.
> >
> > Cheers
> > Jay Walters
> >
> > -----Original Message-----
> > From: G Ramasubramani [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, January 19, 2001 3:28 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Container Managed Transactions in Entity Beans
> >
> >
> > Pooja,
> >
> > Could you post the relevant part of the code in
> ejbCreate which
> > catches the SQL exception and then rethrows a EJB
> Exception? Also the
> > deployment files for the entity?
> >
> > Rama
> >
> > Pooja Keswani wrote:
> >
> > > Hi Reddy,
> > > I would like to give u more information about the
> problem so that it will
> > be easier for u to understand it exactly. i m using entity
> bean which has
> > container managed transcation. This ejb has one helper
> class(DAO) for
> > database transactions . ejb calls DAO's create method in
> its ejbcreate
> > method. now DAO's create method calls one more method named
> > insertIndividual() which actually updates the D/B ie it
> executes 3 insert
> > queries. Now if SQL exception occures in this method, it
> throws it to create
> > of DAO and then to ejbcreate of ejb which will throw the
> EJBexception
> > causing rollback . but it is not doing this way. Actually it says
> > transaction rolled back. but doesn't undo changes in D/B.
> > > what must be happening?
> > > I will appreciate ur reply.
> > > thanks
> >
> > ********************************************************************
> >
> > I've got plenty of common sense. I just choose to ignore it.
> > - Calvin
> > ********************************************************************
> >
> >
> ==============================================================
> =============
> > 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".
>
>
> Chequemail.com - a free web based e-mail service that also pays!!!
> http://www.chequemail.com
>
> ==============================================================
> =============
> 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".
