Spring Boot - JPA - Postgres ERROR: cross-database references are not implemented:

Question

I am using Spring Boot, JPA and Postgres and I have one database with multiple schemas. I implement a web service using JPA and I receive this error:

o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: cross-database references are not implemented: "kaloudia_db_v2.enumeration.unit"

Do you know any way to overcome this error?

My class is

@Entity
@Table(name = "unit", schema = "enumeration", catalog = kaloudia_db_v2")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "Unit.findAll", query = "SELECT u FROM Unit u"),
    @NamedQuery(name = "Unit.findById", query = "SELECT u FROM Unit u WHERE u.id = :id"),
    @NamedQuery(name = "Unit.findByNameEn", query = "SELECT u FROM Unit u WHERE u.nameEn = :nameEn"),
    @NamedQuery(name = "Unit.findByNameEl", query = "SELECT u FROM Unit u WHERE u.nameEl = :nameEl")})
public class Unit implements Serializable {
private static final long serialVersionUID = 1L;
@Id

and call of JPA function is:

public Object getAllUnits() {
    List<Unit> units = unitRepository.findAll();
    return units;
}

Postgres does not support catalogs (=database) as port of an identifier. You should remove the catalog=... attribute from the annotation. — user330315
– user330315, Commented Jan 5, 2016 at 23:40
@a_horse_with_no_name If I remove the catalogo=... , I receive this error ERROR: relation "enumeration.unit" does not exist — pik4
– pik4, Commented Jan 6, 2016 at 9:00
@jackk You are right my friend!! I forgot to change this property: spring.datasource.url=jdbc:postgresql://127.0.0.1:5432/kaloudia_db_v2 It works now!! Thank you and I am sorry. — pik4
– pik4, Commented Jan 6, 2016 at 9:03

pik4 · Accepted Answer · 2017-11-01 10:44:36Z

1

As Jack said, I saw the application properties file and I found out that I forgot to change spring.datasource.url property!!

I am sorry for my question! It works fine now!

edited Nov 1, 2017 at 10:44

answered Jan 6, 2016 at 9:05

pik4

1,3734 gold badges23 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

Spring Boot - JPA - Postgres ERROR: cross-database references are not implemented:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related