W
WitnessTruth
Guest
I have a Spring Boot Application which connects to a Progress Open Edge Database (NOT postgree).
But I am having some issues when trying to get data from Progress Table, it returns the following error when I call methods such "findAll()" or "findById()":
But, "INTEG_TABLE_003C" does exist in "EMS2ESP" database. When running the select directly it works correctly.
I am trying with the following properties in my application.properties:
And this is one of my entities:
I would like to make Spring remove the "EMS2ESP" schema from the generated query because I saw some online posts saying that this could cause the error above.
How can I do that? Thank you
Continue reading...
But I am having some issues when trying to get data from Progress Table, it returns the following error when I call methods such "findAll()" or "findById()":
Code:
Table/view/synonynm "EMS2ESP.INTEG_TABLE_003C" cannot be found. (15814) (-210083)
But, "INTEG_TABLE_003C" does exist in "EMS2ESP" database. When running the select directly it works correctly.
I am trying with the following properties in my application.properties:
Code:
spring.datasource.url=jdbc:datadirect:openedge://HOM-DB-01:25475;databaseName=ems2esp
spring.datasource.username=sysprogress
spring.datasource.password=sysprogress
spring.datasource.driver-class-name=com.ddtek.jdbc.openedge.OpenEdgeDriver
spring.datasource.database-platform=org.hibernate.dialect.SQLServerDialect
And this is one of my entities:
Code:
@Entity
@Table(name = "INTEG_TABLE_003C")
@Data
public class Progress003c extends IntegTable003c {
// Class properties and etc...
}
I would like to make Spring remove the "EMS2ESP" schema from the generated query because I saw some online posts saying that this could cause the error above.
How can I do that? Thank you
Continue reading...