intellij idea data sources doesn't see existing table in the database

database intellij-idea schema database-connection datasource
WebComer picture WebComer · Sep 6, 2012 · Viewed 7.8k times · Source

intellij idea data sources doesn't see existing table in my mysql database, while Netbeans see it. i've created a table in the database. When i create connection in intellij idea data sources, it sees my scheme, i do select it in "schemas and tables" but then i don't see it in the list. every schema, but mine's. When i try to connect to it with netbeans or mysql workbench, it's just ok. same story with several databases, with root access, too. any table, but mine's. what could be wrong?

i see question like mine's here, related to visual studio, no answer. please, give a good clue

Answer

Kevin Van Ryckegem picture Kevin Van Ryckegem · Nov 30, 2015

I had the same problem in IntelliJ IDEA 15.

I fixed it by right clicking the data source -> Properties -> Schemas -> Use legacy introspector.

Related questions

IntelliJ IDEA 10 generate entity (POJO) from DB model

How can I generate entity (POJO) from database model using IntelliJ IDEA 10. I create "Data source" in IntelliJ but I have not any idea how can I generate the POJO.

Read More
Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually

My Intelij IDE wont connect to my database server of MySQL Workbench, it specifies it as a timezone problem and wants me to go to advanced tab and set serverTimezone property manually. I tried looking if there where a similar …

Read More
DataGrip added value compared to IntelliJ IDEA

So, I was wondering if there is really some new features coming from JetBrains DataGrip software. So far, I didn't find anything that is not already there in IntelliJ IDEA (Ultimate). I didn't spend much time using it though.

Read More