How to remove data source warnings in Spring Jpa and Intellij Idea?

Question

After new update Intellij, I have red warnings in entity classes. For example:

@OneToMany(fetch = FetchType.LAZY)
    @JoinTable(name = "poll_answers", joinColumns = @JoinColumn(name = "poll_id"))
    private Set<String> answers;

I have warning lines under "poll_answers" and "poll_id" "cannot resolve table/column" and offers me press "assign data source".

Please mention the __version of IntelliJ__ (after and before update)! Which plugin (or source) does send this warning? — hc_dev, Dec 01 '19 at 17:36
Does this answer your question? [Intellij IDEA: specify datasource for JPA validation](https://stackoverflow.com/questions/14356148/intellij-idea-specify-datasource-for-jpa-validation) — hc_dev, Dec 01 '19 at 17:54
@P.J.Meisch I use application.properties to connect to database — andrew17, Dec 02 '19 at 10:47
IntelliJ has a database tools window, there you can set up the connection and IntelliJ can then check the table and columns — P.J.Meisch, Dec 02 '19 at 11:33
@P.J.Meisch but if I used to use just app.properties + database ? without intellij tools — andrew17, Dec 03 '19 at 13:43
the IntelliJ shows you the warning. You can configure the corresponding inspection to not mark this — P.J.Meisch, Dec 03 '19 at 17:48

score 4 · Answer 1 · answered Feb 20 '21 at 19:23

If you want to ignore such warnings without having to configure a data-source inside IntelliJ you can do that by removing the particular inspection in Settings under : Editor > Inspections.

The proper selector should be under: JPA > Unresolved database references in annotations

Source: IDEs Support (IntelliJ Platform)

score 2 · Accepted Answer · edited Jan 23 '20 at 20:12

Your setup: Spring, JPA, ORM

Since your Spring project uses JPA and you are defining object-relational-mappings (ORM) using annotations:

@JoinTable(name = "poll_answers", joinColumns = @JoinColumn(name = "poll_id"))

IntelliJ is intelligent and tries to validate the specified tables and columns against the database.

You can get an idea of the magic from this tutorial, although the topic is slightly going into another direction.

You did not really provide the settings/setup (JPA Facet, etc.) that you are using within your IntelliJ project. It would be ideal if you can provide more information or a screenshot.

Warning issue

Since you apparently have no database/data-source assigned within your IntelliJ Database Tools window, the above explained validation fails and the reported warning is shown:

cannot resolve table/column

Possible solution and further help

A solution may be, to add the Data Source as the warning popup suggests already.

Maybe this tutorial can help you to setup a new Data Source within IntelliJ Database Tools. You can use your JDBC connetion-string (starting with jdbc://) from your mentioned application.properties to configure your database-connection.

In my comment to your question I also pointed you to this answer here, which pictorally describes how to Assign Data Sources via the IntelliJ menu: View -> Tool Windows -> Persistence.

Do so, if you want to learn how to take advantage of these warnings! As [P.J. Meisch commented](https://stackoverflow.com/questions/59127293/spring-jpa-intellij-entity-class-red-warns-under-fields-types-sources/59146149#comment104549677_59127293) you can also ignore or disable warnings and your application will compile and run anyway. — hc_dev, Dec 03 '19 at 20:23
it compiles fine even with them. But i dont like to see that red warning. If that was yellow... . — andrew17, Dec 03 '19 at 21:53

How to remove data source warnings in Spring Jpa and Intellij Idea?

2 Answers2

Your setup: Spring, JPA, ORM

Warning issue

Possible solution and further help