postgresqlspring-bootintellij-ideaspring-data-jpa
Intellij Jpa console db schema
When I want make query in Intellij JPA console I get error that relation "topic" does not exist. Jpql query select t from Topic t. I'm using spring boot, I added jpa to module, persistence toolbar works well, but jpa console doesn't. My thougs that JPA Console not find in right db schema, but datasource selected corect.
JPA console print: [2019-07-19 12:49:59] [42P01] ERROR: relation "topic" does not exist [2019-07-19 12:49:59] Position: 60
Solution
I found my mistake in connection to database. I had in field Database value postgres, I replace by chatapp - it is correct schema, and now it works well
- How to show full definition of function or procedure?
- Repeated execution of PL/pgSQL function triggers error "could not open relation with OID ..."
- error: password authentication failed for user "postgres" drizzle migration
- Alembic migration for GeoAlchemy2 raises NameError: name 'geoalchemy2' is not defined
- Get the top N rows by row count in GROUP BY
- Postgres unique constraint vs index
- Postgres caseinsensitive unique key constraint: What is the fast option?
- Fixing all sequences in PostgreSQL 15 after migrating with logical replication from PostgreSQL 11
- PostgreSQL `aws_s3` Extension: SSL Certificate Verification Failed with Self-Signed Certificate
- Get fatal error: server could not be contacted when running pgAdmin4. 'NoneType' object has no attribute 'value'
- Find a value based on all its present combinations with a value in another field in Postgres
- SSLmode in FireDac for connection to Postgres
- Why is postgres container ignoring /docker-entrypoint-initdb.d/* in Gitlab CI
- Query failed: collation "numerickn" for encoding "UTF8" does not exist
- How does a Recursive CTE know to only process records added during the last iteration (and not looking at all of them)?
- Directly return Postgres jsonb binary bytes
- Combine two tables doing row count based on hour value in timestamp
- Execute function from procedure, the name of function stored in table column
- Node.js, PostgreSQL error: no pg_hba.conf entry for host
- ERROR: cannot execute CREATE TABLE in a read-only transaction
- How can I write a trigger and function to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- count difference in seconds between values from table and some moment in time using PostgreSQL
- Postgres Permissions violated by before-insert trigger function
- Update query not working with Celery and FastAPI
- nodejs query postgres using WHERE
- PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
- Group multiple events for ID in postgreSQL data
- Blazor App in Docker Occasionally Fails to Connect to PostgreSQL Database
- Table constraint for range and null values
- Fixtures are not loaded and says they are not found, although they are there