我使用的是Spring Boot、JPA和Postgres,我有一个带有多个模式的数据库。我使用JPA实现了一个web服务,我收到了这个错误:
o.h.engine.jdbc.spi.SqlExceptionHelper:错误:未实现跨数据库引用:"kaloudia_db_v2.enumeration.unit"
你知道克服这个错误的方法吗?
我的课是
@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
JPA函数的调用为:
public Object getAllUnits() {
List<Unit> units = unitRepository.findAll();
return units;
}
正如Jack所说,我看到了应用程序属性文件,发现我忘记更改spring.datasource.url属性!!
对不起我的问题!它现在运行良好!