Pooja,
When you get the SQL connection from the server - is it a transactional data
source or a non-transactional data source?
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
>
> 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".
--
thanks,
Rama
********************************************************************
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".
