JPA Query annotation and joining table

Question

I have a sql query like this

Select * from DB1.Table1 a left join DB2.Table2 b on a.dCode = b.dCode where bID = 123;

How can I create jpa code for the above query? what would be the params of JpaRepository

public interface TestRepository extends JpaRepository<???, ???> {

    @Query("???")
    ??? myTestQueryCOde(Integer bID);
}

What would be at ???

Where does the `JpaRepository` class come from? – Bhesh Gurung Jun 05 '13 at 06:00 — Bhesh Gurung, Jun 05 '13 at 06:00
@Bhesh JpaRespository is part of Spring JPA Data. – Scary Wombat Jun 05 '13 at 06:44 — Scary Wombat, Jun 05 '13 at 06:44

score 2 · Answer 1 · edited May 23 '17 at 11:43

2

I am not sure if Spring JPA Data support cross DB queries, but have a look at Cross database joins in JPA

edited May 23 '17 at 11:43

Community

answered Jun 05 '13 at 06:46

Scary Wombat

1 Answers1