I am using spring boot,hibernate,flyway combination with a post gres instance. I have created a Users table inside it.I am able to run my application behaviour while on local which postgres 9.5.But I am unable to do so on preidx database.The error given by hibernate is org.postgresql.util.PSQLException: ERROR: relation "increment_sequence" does not exist
Note increment_sequence is the sequence given to ID which is primay key column in my database. Following are my cloud properties spring.datasource.url=${vcap.services.pdx-postgres-intellistream-rls.credentials.uri} spring.datasource.driverClassName=org.postgresql.Driver spring.datasource.username=${vcap.services.pdx-postgres-intellistream-rls.credentials.username} spring.datasource.password=${vcap.services.pdx-postgres-intellistream-rls.credentials.password} #spring.jpa.hibernate.ddl-auto=validate spring.jpa.hibernate.default_schema =[fly] spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect spring.jpa.show-sql=true
flyway.enabled=true flyway.locations=classpath:migration flyway.baseline-description=BaseLine flyway.schemas=fly
Answer by MIHIR.SHAH1@bhge.com · Aug 02, 2018 at 05:53 AM
Following are my cloud properties
spring.datasource.url=${vcap.services.pdx-postgres-intellistream-rls.credentials.uri} spring.datasource.driverClassName=org.postgresql.Driver spring.datasource.username=${vcap.services.pdx-postgres-intellistream-rls.credentials.username} spring.datasource.password=${vcap.services.pdx-postgres-intellistream-rls.credentials.password} #spring.jpa.hibernate.ddl-auto=validate spring.jpa.hibernate.default_schema =[fly] spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect spring.jpa.show-sql=true
flyway.enabled=true flyway.locations=classpath:migration flyway.baseline-description=BaseLine flyway.schemas=fly
Answer by MIHIR.SHAH1@bhge.com · Aug 02, 2018 at 05:52 AM
I am using spring boot,hibernate,flyway combination with a post gres instance. I have created a Users table inside it.I am able to run my application behaviour while on local which postgres 9.5.
But I am unable to do so on preidx database.The error given by hibernate is org.postgresql.util.PSQLException: ERROR: relation "increment_sequence" does not exist
Note increment_sequence is the sequence given to ID which is primay key column in my database.
Problem in connectiong to postgres database 2 Answers
Predix UAA not redirect to Login page in spring boot 1 Answer
Predix time series client library not reading from properties file 1 Answer
Validate the token using UAA Url 4 Answers
MQTT: Fetch multiple nodes into MQTT adapter from the same MQTT Topic 3 Answers