ps:I'm using MS sql server 2000, and master..xp_cmdshell execute a bcp command,copy from table to a file
If the user did not have permit to access the database, how did the tables update in the first place?
Anyway, if you're getting a checked exception (application exception) and catching it, you need to setRollbackOnly() on the EJB context to roll back the transaction.
Thank you for reply.
basicly,this stored procedure update current database,then use xp_cmdshell which is in master database to export table to a file.I'm using MS sql server 2000.the data in current database updated but use has no access to master database.
I'm using container managed transaction,
I think the application server should be able to control transactions,transaction control is one of benefit using EJB?why I have explicate say setRollbackOnly()?
Because the spec says application exceptions are not automatically rolled back.