Hi Reddy,
yaa.. u got the problem coeectly. but see.. i tried without helper class also . but
problem didn't get solved.
about ur design.. actually in my code, there is a session bean which calls some helper
object's method which inturn calls create of this entity bean.so it is same as
wrapping entity bean in session bean. and the entity bean is not container managed.
onlythe transaction is container managed.
i also tried using usertransaction class. but it couldn't solve the problem.
Pls reply...
On Fri, 19 January 2001, E Bakka Reddy wrote:
>
> Hi Pooja,
>
> As I understood, u are creating a employee database, which contains three
> tables, if u are adding one emploee all his/her complete info. should be
> enetered into all three tables, inbetween any problem comes entire
> transaction has to be rolled back, is it yes?
>
>
> One Q? is it CMT supports the transactions in the helper classes?
> Is it not u design is so complex?
>
> can i tell u a simple design for the same thing.
>
> Wrap three CMB's in a session bean and put all three create stmt in
> UserTransaction scope, problem will be solved.
>
> Reply to this mail with u comments on my design, whether it solves or not?
>
> C U Pooja
> Reddy
>
>
>
>
>
> Pooja Keswani <[EMAIL PROTECTED]> on 19/01/2001 01:28:46 PM
>
> Please respond to A mailing list for Enterprise JavaBeans development
> <[EMAIL PROTECTED]>
>
> To: [EMAIL PROTECTED]
> cc: (bcc: ebreddy/Cds)
>
> Subject: Re: Container Managed Transactions in Entity Beans
>
>
>
>
> 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
>
>
>
>
> On Fri, 19 January 2001, E Bakka Reddy wrote:
>
> >
> > Hi Pooja,
> >
> > I understood u problem, no need of doing anything like catching
> > SQLException.
> >
> > What ever i gave in my last mail it works fine.
> >
> >
> > <%@ page import="javax.transaction.*" %>
> >
> > UserTransaction u = (UserTransaction) ctx.lookup(
> > "javax.transaction.UserTransaction");
> > u.begin();
> > deposit=depositHome.create(accountId,balance);
> > System.out.println("Record Created in deposit");
> > accountId="5";
> > withdraw=withdrawHome.create(accountId,balance);
> > System.out.println("Record Created in withdraw");
> > u.commit();
> >
> > in the above code i am inserting two records into a table from two beans,
> > if second bean fails to create, the entire transaction will be rolled
> back.
> >
> >
> >
> > otherewise u can use executeBatch
> >
> > And executebatch.
> >
> > Statement smt = con.createStatement();
> > stmt.addBatch("INSERT INTO COFFEES" +
> > "VALUES('Amaretto', 49, 9.99, 0, 0)");
> > stmt.addBatch("INSERT INTO COFFEES" +
> > "VALUES('Hazelnut', 49, 9.99, 0, 0)");
> > stmt.addBatch("INSERT INTO COFFEES" +
> > "VALUES('Amaretto_decaf', 49, 10.99, 0, 0)");
> > stmt.addBatch("INSERT INTO COFFEES" +
> > "VALUES('Hazelnut_decaf', 49, 10.99, 0, 0)");
> >
> > stmt.executeBatch(); I hope here also any one of insert stmt fails the
> > transaction will rolled back.
> >
> >
> > Edla B. Reddy
> >
> >
> ===========================================================================
> > 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".
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".
