Dear All
I am facing a strange issue. We have to delete some roles from our application .As per business logic before deletion of roles we store them into ou archive table and once they are stored then we delete them from our main table
This logic works fine with single user environment but whenever testing is performed on multi user we are losing the roleName value of the record and getting exception from table
In our code we are first selecting the record from our main table VT_RE_ROLE
and putting it into dto.closing prepared ststement,resultset
opening another preparedststement and now using same dto tryin to insert this record
Sample code snippet is as follows
Some how the dto's name property is lost and therefore in subsequent preparedstatement it throws the error mentioned above
If any one can share some inputs that will be of great help