Predix_Logo
  • Categories
    • Questions
    • Predix | Updates
      • Pricing
      • Product
    • Deloitte - Private
    • How-To
    • Accenture-Private
  • Explore
    • Topics
    • Questions
    • Articles
    • Feedback or Feature Requests
  • Sign in
  • Home /
  • Questions /
avatar image
0
Question by MIHIR.SHAH1@bhge.com · Aug 02, 2018 at 05:31 AM · spring-bootflyway

unable to find sequence in postgres

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

Comment
Add comment
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

2 Replies

  • Sort: 
avatar image
0

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

Comment
Add comment · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image
0

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.

Comment
Add comment · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow this Question

Answers Answers and Comments

90 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

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

GE Monogram
  • Legal
  • Cookies
  • Forum Terms
  • Contact Us
  • Copyright © 2017 General Electric Company. All rights reserved.


Enterprise
Social Q&A

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Submit your feedback or feature request
  • Categories
  • Questions
  • Predix | Updates
    • Pricing
    • Product
  • Deloitte - Private
  • How-To
  • Accenture-Private
  • Explore
  • Topics
  • Questions
  • Articles
  • Feedback or Feature Requests