How do I provoke a SQLExcetpion in DAO-Layer with JUnit
I have a DAO-Layer which I want to test with JUnit. The test coverage is about 85%, so nearly every line of code is covered except the catch clauses for SQLException. I have no idea how I can provoke a SQLException for the snippet below:
The only conceivable solution for me is to reset the value of the final variable SELECT_ALL_ATTR to something like: SELLLLLECT * FROM ATTRIBUTES; by using java reflection. I know that I can easily test exceptions by using the Mock framework. But I don't want to introduce Mock tests just for exception testing since everything else is tested with JUnit.
Is there a way other than java reflection?
It's not easy to simulate a sql exception in your case because all dependences are initiated by the dao itself. Maybe you can pass a fake Connection which throws a SqlException in some method?
- JUINT test giving error java.lang.reflect.InaccessibleObjectException: Unable to make protected void java.lang.Object.finalize()
- Cannot invoke "com.vaadin.flow.server.RequestHandler.handleRequest
- AutoComplete ComboBox in JavaFX
- Dynamic spring data jpa repository query with arbitrary AND clauses
- dspace import metadata acknowledges changes doesn't apply them
- Could not resolve all files for configuration ':app:androidJdkImage
- Cost of inserting element at 0th position of LinkedHashSet?
- OTEL Agent How to disable logging
- Received fatal alert: bad_certificate
- What is the reason to disable csrf in spring boot web application?
- Input from user in Luaj
- How can I list all the files in folder on tomcat?
- Java Convert negative numbers to 0
- Can Lombok toString() output include newlines?
- Access jdk.unsupported from JUnit doesn't need module require
- Unable to resolve name [org.hibernate.spatial.dialect.postgis.PostgisDialect] as strategy [org.hibernate.dialect.Dialect]
- java.lang.module.FindException: Module not found
- How to process tabular data from Oracle PL/SQL function in JAVA?
- Pass device udid from test parameters to DesiredCapabilities in seperate classes
- What does a "Cannot find symbol" or "Cannot resolve symbol" error mean?
- Spring Boot 2.5.0 generates plain.jar file. Can I remove it?
- Fastest method to define whether a number is a triangular number
- Can I have two the same methods annotated with @RequestMapping with different headers?
- Maximized JFrame's location is [-8,-8]. Can it be fixed?
- HTML/JS app within an Android App
- To compare UUID, can I use == or have to use UUID.equals(UUID)?
- Lombok @Slf4j and interfaces?
- Unable to run jar from cli, poi-ooxml ...xssf.usermodel.XSSFCellSytle ignored
- Using Hibernate UUIDGenerator via annotations
- Calling unmanaged C\C++ DLL methods from Java?