Hi
This is a long mail, so please bear with me.
WL4.5, NT4, SqlServer6.5, JDBC type 4, JDK1.1.17b
I have a cmp with few attributes and 3 finders (name, primary key, all)
The DD for the same has TRANSACTION_REQUIRED with
TRANSACTION_SERIALIZABLE properties for isolation and control.
I have a stateless session bean which has a method called
modifyX(beanData)
This checks if there is one more bean with the same name but different
oid
It uses a wrapper method for findByName method of the cmp, which
returns the data instead of remote interface
So the calls go like this
1.modifyX(data)
2.pull out data.name("say madhu1") and data.id ("say xxx")
3.get DATA using wrapperFindByName("madhu1")
4.compare data.id("xxx") with DATA.id
5.if (unequal) throw an exception
/// 2 names are same but primary keys are different
else
// names and primary keys are same => same bean
update the bean data with data.name, data.volume, etc
The DD for the same has TRANSACTION_REQUIRED with
TRANSACTION_SERIALIZABLE properties for isolation and control.
Everything works fine till now and results come back to the client and
THEN the data gets rolled back to the original.
The sql trace (sqlserver) shows 2nd update statement with old data.
Why is this happening even EVE AFTER the client recieves updated bean
data??
Is the isolation level or transactionlevel messing up?
One is a read-only method (findByName)
One is write method (modify)
How shall I tackle this??
If anyone needs further information please cc to my personal id
Regards
Madhu
----------------------------------------
-- 9/8/99 15:31:58.126 SQL (ID=10, SPID=10, User=SRPWKSPCE(\),
App='WebLogic ', Host=''(89) )
DECLARE @INPAR1 bit
DECLARE @INPAR2 varchar(255)
DECLARE @INPAR3 varchar(255)
DECLARE @INPAR4 bit
DECLARE @INPAR5 varbinary(255)
update BIOS_ITEMCONTAINER set BIOS_SLANTABLE = 1 ,
BIOS_ITEM_CONTAINER_NAME = 'madhu1' , BIOS_ITEM_CONTAINER_VOLUME =
'23' , BIOS_ITEM_CONTAINER_STRLABLE = 1 where BIOS_ITEM_CONTAINER_OID
= 0x73D05C4060AD11D3AE7F0080C74455C6
go
-- 9/8/99 15:31:58.136 SQL (ID=10, SPID=10, User=SRPWKSPCE(\),
App='WebLogic ', Host=''(89) )
DECLARE @INPAR1 bit
DECLARE @INPAR2 varchar(255)
DECLARE @INPAR3 varchar(255)
DECLARE @INPAR4 bit
DECLARE @INPAR5 varbinary(255)
update BIOS_ITEMCONTAINER set BIOS_SLANTABLE = 1 ,
BIOS_ITEM_CONTAINER_NAME = 'madhu1' , BIOS_ITEM_CONTAINER_VOLUME =
'453' , BIOS_ITEM_CONTAINER_STRLABLE = 1 where BIOS_ITEM_CONTAINER_OID
= 0x73D05C4060AD11D3AE7F0080C74455C6
-----------------------------------------
===========================================================================
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".
