-
1. Re: transaction problem
zhangj May 13, 2004 10:35 AM (in response to zhangj)ps:I'm using MS sql server 2000, and master..xp_cmdshell execute a bcp command,copy from table to a file
-
2. Re: transaction problem
juha May 14, 2004 4:10 AM (in response to zhangj)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. -
3. Re: transaction problem
zhangj May 14, 2004 12:44 PM (in response to zhangj)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,
<transaction-type>Container</transaction-type>
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()? -
4. Re: transaction problem
juha May 15, 2004 12:31 AM (in response to zhangj)Because the spec says application exceptions are not automatically rolled back.