setRollBackOnly

[sowmya thiru]

here is the code that im running SFSB on WLS8.1. SFSB is called from a standalone java client.
clients transfer money from checking to savings. in my db i have 20$ in Checking. I make an attmpt to transfer $60 from checking to savings.
public void transferToSaving(double amount) throws InsufficientBalanceException {
checkingBalance -= amount; savingBalance += amount;
try { updateChecking(checkingBalance); if (checkingBalance < 0.00) {
System.out.println("loop starting"); //THIS LOOP IS PUT DELIBERATELy, // so that I can check DB if value has been deducted from checking table
for (int i = 0 ; i < 1000000000; i++) { }
context.setRollbackOnly(); throw new InsufficientBalanceException(); } updateSaving(savingBalance); } catch (SQLException ex) { throw new EJBException ("Transaction failed due to SQLException: " + ex.getMessage()); }
}
At end of above method, i see -40 in my checking account, and savings account incremented by 60$
my question. why updated to checking table has not rolled back?

[Chris Mathews]

Two Comments:
1) I am moving this to the BEA/WebLogic Forum since it has nothing to do with the SCEA exam.
2) Make sure you are using a TxDatasource. This is the number one problem that new users have with transactions in WebLogic.
[ August 13, 2003: Message edited by: Chris Mathews ]

[Rahul Mahindrakar]

Hi,
The code looks ok. Very strange indeed
Try this code

 
checkingBalance -= amount;
savingBalance += amount;
if (checkingBalance < 0.00) {
System.out.println("loop starting");
throw new Exception("");
} else {
try {
//updateChecking(checkingBalance);
//updateSaving(savingBalance);
} catch (Exception e) {
//context.setRollbackOnly();
throw new Exception("");
}
}