Spring dynamic JPA repository type

Question

I have about 30 tables that I need to fill from an XML file. And I want to use JPA for that purpose.

Now I have 30 classes annotated with @Entity, config that scans entities and repositories;

Also I have:

@Repository public interface MyRepository extends JpaRepository<MyEntity1, Long> { }

And (some controller):

@Autowired public MyRepository myRepository; ... ... MyEntity1 entity = new MyEntity(...); myRepository.save(entity);

It works fine with one @Entity but should I define 30 repositories for that?

I thought I could do something like this:

@Repository public interface MyRepository<T> extends JpaRepository<T, Long> { }

and then:

@Autowired public MyRepository<MyEntity1> myRepository1; @Autowired public MyRepository<MyEntity2> myRepository2;

but that gave an error:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'myRepository1': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Not a managed type: class java.lang.Object

Don't forget to accept/upvote answers that helped you...

Cepr0
– Cepr0

2017-12-25 09:21:23 +00:00
Commented Dec 25, 2017 at 9:21 — Cepr0
– Cepr0, Commented Dec 25, 2017 at 9:21

Cepr0 · Accepted Answer · 2017-07-19 11:36:34Z

Try this approach:

Base class for all entities:

@Entity @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) public abstract class BaseEntity { @Id @GeneratedValue(strategy = GenerationType.TABLE) private Long id; }

Entities:

@Entity public class Entity1 extends BaseEntity { private String name; } @Entity public class Entity2 extends BaseEntity { private String name; }

A common repo:

public interface BaseEntityRepo extends JpaRepository<BaseEntity, Long> { }

Usage:

public class BaseEntityRepoTest extends BaseTest { @Autowired private BaseEntityRepo repo; @Test public void baseEntityTest() throws Exception { BaseEntity entity1 = new Entity1("entity1"); BaseEntity entity2 = new Entity2("entity2"); repo.save(entity1); repo.save(entity2); List<BaseEntity> entities = repo.findAll(); assertThat(entities).hasSize(2); entities.forEach(System.out::println); } }

Plog · Accepted Answer · 2017-07-19 09:39:57Z

Unfortunately you can't do this and you will have to write 30 separate repositories. You can however write generic repositories when the entities share a single table inheritance. (See the answer to Using generics in Spring Data JPA repositories)

What your code is trying to do is make a repository where the shared inheritance is on the class Object which isn't an @Entity hence the exception.

Also an additional minor note, you don't need to annotate your repositories with @Repository. Spring data automatically registers these as beans if it is configured correctly.

Thanks. I added @Repository annotation when I tried to fix that I wasn't able to autowire repository, but error was that I misspelled package with repos to scan =). Anyway, you cleared my mind, thanks)

shazin · Accepted Answer · 2017-07-19 09:36:59Z

As far as I am aware what you are trying is not possible. Spring Data JPA needs an interface per Entity type for its repositories, Because Spring Data JPA will be creating the query implementations.

So it is advised that you have a Repository per Entity as it will allow you to add complex findByXXX methods in the future also.

Collectives™ on Stack Overflow

Spring dynamic JPA repository type

3 Answers 3

1 Comment

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Linked

Related