on 10-17-2008 8:12 AM
HI
I am using JDBC as Receiver and my req is getting file(FTP) and (delete * from tables ) then (insert * into tables) using JDBC) /multiple tables.
Its like this.Part of data from file into one table and 2nd part into other table,but remember before inserting data from file to DB i have to delete all from DB.
My question is ...In this process,after deletion and before inserting if some thing happens do we have an option to rollback everything in DB.
Please let me know
Thanks
Prabhakar
Thanks Alex.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Prabhakar
Using BPM you can hold back data if any error happend, you can raise the alert as well.
Another thing that you can do is Make the scenario File - Java proxy and from proxy you insert the data. There you can use Heirarcial SQL statement and even check at every state if the data is inserted/updated/deleted or not and can rollback
Thanks
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any more Ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey just to give you some confirmation on the above proposal of using a stored procedure.
I have worked with a similar requirement in the past and after looking at a few options, I ended up going for the stored procedure.
It was better as the logic is encapsulated on the DB side, this way it guarentees the data is treated correctly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can achieve it by using database stored procedure.
you just write stored procedure and write delete and insert statement in that , there you can also handle the rollback .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prabhakar,
chk the below link
http://help.sap.com/saphelp_nw04/helpdata/en/c7/af82229747c346bd92cc54b2cf6858/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think there is nothing specific for rollback, but i think using BPM you can use Exceptions to avoid a mistake.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.