Tools for regression testing / test automation of database centric java application?

Question

I'm looking for a good, preferably free tool for automating tests of a java (EJB3) application without any kind of GUI.

Tool should be capable of at least:

Inserting / updating / deleting data on database
Querying and comparing data on database
Reading and writing to FTP server
Initializing test environment, launching EJB3 bean, cleaning up test environment after the test
Reporting
Some kind of scripting interface is enough, no GUI required

Naturally this could be done using Java & JUnit but it would be pretty tedious. I would appreciate any hints of such tools.

[Here is a HUGE list of open sources solutions.](http://www.manageability.org/blog/stuff/open-source-automated-test-tools-written-in-java) — amischiefr, Jul 09 '09 at 18:20

score 3 · Answer 1 · answered Jul 09 '09 at 18:25

3

It sounds like you are looking for a combination of DBUnit and Cactus (the FTP stuff might require Commons-NET or Commons-VFS). Use ANT, with its scripting support, to get the reporting on the test results and the scripting.

That hits the checklist. If you want to test those EJB's out of the container, there is EJB3Unit.

answered Jul 09 '09 at 18:25

Yishai

90,445
31
189
263

I'm looking for something a bit more higher level. Some kind of script based system. – tputkonen Jul 13 '09 at 13:16

score 0 · Accepted Answer · answered Jul 24 '09 at 11:33

0

Robot framework, Fitnesse and Concordion seem currently the most interesting candidates.

answered Jul 24 '09 at 11:33

tputkonen

5,579
16
60
88

Tools for regression testing / test automation of database centric java application?

2 Answers2

Linked