ClassCastException with spring-data JPA delete method

Question

In my test class, I insert a test product in setUp and delete it in tearDown. During mvn package, I get the following error:

java.lang.ClassCastException: java.lang.Integer cannot be cast to com.myproject.app.entity.Product
at com.myproject.app.MyProjectProductTests.tearDown

This is my service method to remove product by name, which uses JPA:

public Product remove(String productName) {
    return repository.removeByName(productName);
}

In my repository I define removeByName as follows:

@Transactional
Product removeByName(String name);

and this is the tearDown in my test class:

....
@Autowired
private ProductServiceImpl productService;
....

@After
public void tearDown() {
    this.productService.remove(productNameToTest);
}

Why do I get that error for this tearDown?

It's a transactional method in repository. My aim is to remove the product by the given name. — tolga
– tolga, Commented Sep 10, 2019 at 21:29
removeByName method has either declared Integer as a return type, and/or has declared query or native query which returns int (e.g. it returns number of items deleted (int) instead of the deleted Product item). Just guessing. — zolv
– zolv, Commented Sep 10, 2019 at 21:47
does your removeByName() work at all? I mean, outside unit tests? it doesn't sound like this problem relates to teardown at all, but faulty service method — eis
– eis, Commented Sep 10, 2019 at 22:01

eis · Accepted Answer · 2019-09-11 06:18:49Z

2

This:

@Transactional
Product removeByName(String name);

to me looks like a faulty signature. You can choose return value between an integer (return count of deleted entries) or list of VO:s (return all deleted objects). However, one object is not an acceptable return value. This should work:

@Transactional
long removeByName(String name);

and

@Transactional
List<Product> removeByName(String name);

and even

@Transactional
void removeByName(String name);

but not the thing you have.

edited Sep 11, 2019 at 6:18

answered Sep 10, 2019 at 22:10

eis

53.7k14 gold badges159 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tolga Over a year ago

This is the answer thank you. I'm new to java but I should have known about type casting.

Suraj · Accepted Answer · 2019-09-10 21:47:33Z

0

Try updating query Product removeByName(String name); to Product deleteByName(String name);

answered Sep 10, 2019 at 21:47

Suraj

7677 silver badges21 bronze badges

1 Comment

tolga Over a year ago

Same error. May be I shouldn't try to add a transactional method but write a custom repository method to delete instead.

Collectives™ on Stack Overflow

ClassCastException with spring-data JPA delete method

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related