I have an application that uses databases through jdbc API (in fact spring jdbc template). We want to run our unit tests against more type of databases (MS SQL, Oracle, Postgre); Thus to run a test (for example with maven) that will run a unit tests 3x times, for each specified databases.
如何奇怪地解决这一问题?
(我是想自己执行日本歌舞家,但我们也有斯波克试验)
根本问题是,如何在不同的非行环境中多次进行同样的测试。 你们要么可以在试验框架一级执行(例如,与一名客户共同管理,要么作为DBUnit/推广),要么在建筑工具一级实施(如果你的建筑工具有足够的灵活性)。 在这两种情况下,应当能够有一个与Junnit和Spock合作的实施。 (以这种方式,Spock提供将Uniils并入外箱)。
开始Unit
DbUnit公司是一个由数据库驱动的项目(也可用于Ant),这些项目除其他外,使你的数据库在试运行之间成为一个已知的国家。 这是一种极好的方法,可以避免在一例测试案件中贪污数据库,造成随后的测试失败或加剧损害时可能出现的众多问题。
Use a separate JdbcDatabaseTester for each database - the unit tests etc should be coded to IDatabaseTester and so can run with all the databases.
你的测试是什么? 页: 1 您对数据库图示的q言? 根据答案,有两项战略:
In case it is java code you are testing, just mock up JDBC connection with mocking framework of your choice ( I would recommend jMockit ) and see that your code issues proper sql statements
In case it is database schema you can prepare SQL statements and send them to DB of your choice by most convenient means ( DBUnit could be also used for this purpose, or SoapUI, or other DB management tool )
Separating those 2 concerns would provide simpler and more robust tests for each tier.
PS: also consider to use some form of ORM - like JPA
Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...
Check this, List<String> list = new ArrayList<String>(); for (int i = 0; i < 10000; i++) { String value = (""+UUID.randomUUID().getLeastSignificantBits()).substring(3, ...
I am in the middle of solving a problem where I think it s best suited for a decorator and a state pattern. The high level setting is something like a sandwich maker and dispenser, where I have a set ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...
If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...
I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....
I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...
