From: Matthias G. <Mat...@we...> - 2009-07-31 21:30:27
|
Sorry, I didn't completely understand what you mean. Actually all the operations like DatabaseOperation.INSERT should work within one transaction. You just have to use the same JDBC connection for insert, assert, rollback. Of course you should not commit the data after the insert as you described it initially - otherwise a rollback would not be possible. rgds, matthias > -----Ursprüngliche Nachricht----- > Von: "Karthik Krishnan" <kri...@gm...> > Gesendet: 31.07.09 23:01:01 > An: dbu...@li... > Betreff: Re: [dbunit-user] Transaction management in DBUnit Matthias, > > I looked through some source code. I missed this feature. Let me look > into it and I will let you know how this works. Perhaps, I could > leverage this feature to manage transactions outside of testing > environment. > > Thanks, > > Karthik > > On Fri, Jul 31, 2009 at 1:08 PM, Matthias Gommeringer <Matthias. > Gom...@we...> wrote: > Hi there, > > I think this should already be possible by just setting your jdbc > connection to autocommit=false. Maybe the feature request https:// > sourceforge.net/tracker/index.php?func=detail&aid=564041&group_id= > 47439&atid=449494 also helps you a bit. > > rgds, > matthias > > > -----Ursprüngliche Nachricht----- > > Von: "Karthik Krishnan" <kri...@gm...> > > Gesendet: 31.07.09 02:00:52 > > An: dbu...@li... > > Betreff: [dbunit-user] Transaction management in DBUnit > > Hi, > > > > I have worked with DbUnit and I think it is the best tool to for db > > tests. I have an issue I hope DbUnit addresses this issue. In my > > project, we use Callable Statements to make CRUD calls. Some of the > > calls are complex package calls. To test crud operations, what we > > would like to do is > > > > 1. invoke a CRUD call (Create) and committed > > 2. Test if data exists > > 3. After the test has been executed, roll back all changes > automaticall > > y unconditionally (when the test passes, fails or if an exception is > > thrown). From what I understand is that DatabaseOperation.INSERT > > should followed by DatabaseOperation.DELETE which are two separate > > operations but should be transactional. What I would prefer is that > > the changes were rolled back instead of calling delete. Because a > > successful insert may involve different tables with different > > constraints, it is very difficult for us to delete multiple entries > > from different tables. > > > > Is there a facility for this purpose? > > > > Thanks, > > > > Kartik > > -------------------------------------------------------------------- > -- > > -------- Let Crystal Reports handle the reporting - Free Crystal > > Reports 2008 30-Day trial. Simplify your report design, integration > > and deployment - and focus on what you do best, core application > > coding. Discover what's new with Crystal Reports now. http://p.sf. > net/ > > sfu/bobj-july_______________________________________________ dbunit- > > user mailing list dbu...@li...https://lists. > > > > sourceforge.net/lists/listinfo/dbunit-user > > ______________________________________________________ > GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT! > Jetzt freischalten unter http://movieflat.web.de > > ---------------------------------------------------------------------- > -------- > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > trial. Simplify your report design, integration and deployment - and > focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > dbunit-user mailing list > dbu...@li... > https://lists.sourceforge.net/lists/listinfo/dbunit-user > > ---------------------------------------------------------------------- > -------- Let Crystal Reports handle the reporting - Free Crystal > Reports 2008 30-Day trial. Simplify your report design, integration > and deployment - and focus on what you do best, core application > coding. Discover what's new with Crystal Reports now. http://p.sf.net/ > sfu/bobj-july_______________________________________________ dbunit- > user mailing list dbu...@li... https://lists. > > sourceforge.net/lists/listinfo/dbunit-user ______________________________________________________ GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT! Jetzt freischalten unter http://movieflat.web.de |