I have started investigating the use of SqlUnit with a SQL Server 2000 database.
I am trying to fully understand the transaction-support and why it's working the way it appears to be working.
What I want to do: In the <setup> tag I want to setup the database and after running all tests, have the database restore itself to what it was prior to the tests.
So my first thought was to have a BEGIN TRANSACTION in the <setup> and a ROLLBACK in the <teardown>. This didn't work the way I was expecting, and after a lot of experimentation, I came to this conclusion:
* setting transaction-support to "false" does what I want without a BEGIN TRANSACTION or a ROLLBACK.
Is that a feature? Or is it not supposed to do that?
Am I on the right track?
I am using the Microsoft JDBC drivers.
Thank you,
Jeff
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have started investigating the use of SqlUnit with a SQL Server 2000 database.
I am trying to fully understand the transaction-support and why it's working the way it appears to be working.
What I want to do: In the <setup> tag I want to setup the database and after running all tests, have the database restore itself to what it was prior to the tests.
So my first thought was to have a BEGIN TRANSACTION in the <setup> and a ROLLBACK in the <teardown>. This didn't work the way I was expecting, and after a lot of experimentation, I came to this conclusion:
* setting transaction-support to "false" does what I want without a BEGIN TRANSACTION or a ROLLBACK.
Is that a feature? Or is it not supposed to do that?
Am I on the right track?
I am using the Microsoft JDBC drivers.
Thank you,
Jeff