Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 983
Andrew Sneck Avatar asked Dec 22 '22 22:12

Andrew Sneck


2 Answers

Did you do all those steps?:

enter image description here

(The IDEA version is 2019.1)

like image 61
Cepr0 Avatar answered Dec 26 '22 11:12

Cepr0


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

Database settings

like image 34
Andrew Sneck Avatar answered Dec 26 '22 11:12

Andrew Sneck