Running SQL server for java

Question

I have a Java application that uses an MSSQL server through the JDBC driver. Is there some kind of stub that I can use for testing? For example, I want to check how my application handles cases of connection errors, an off-disk SQL server, and other exceptions. It is quite complicated and difficult to simulate it using a real SQL server.

thank

Answer 1

You can write unit tests using DAOor repositories that return mock objects Connectionusing a mock library such as https://mocquer.dev.java.net/ .

, .

Answer 2

( , , ) ( , / ), , , .

- .

Answer 3

, - . /LAN.

, , , :

• freeSQL
• db4free

MySQL, MS-SQL. , . , , MS-SQL db.

Answer 4

, , . HyperSQLDB - , Java. HSQLDB , . , , ..

, ? ?

Answer 5

, MS-SQL, - (, ), . - .

, .

, , , , Mockito (docs) PowerMock. , , . - ( ) ? . /mock JDBC ResultSet Java 5 6?

Answer 6

sp_who2 db, spid, db. : kill <<spid>> , . spid 50, , . . ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK_IMMEDIATE, db.

Select @@MAX_Connections as Max_Connections , ( , ).

. - .

to create an error on disk just redraw the db file size and don't let it grow ... then paste the data into the database (you will get an exception).

altert database xxx (file= maxsize= filegrowth=)