Database tab does not show schemas and tables

Answered

Hi, Guys!

I can't figure out why RubyMine Database tab is not showing the schemas and tables.

I'm pretty sure my database configs are correct because I can do queries using the Console.

Does anybody know what's going on?

Thanks!

0
14 comments

You first need to select the Schemas you want to be synchronized and displayed for the data-source:

See also Showing and hiding schemas and Resolving visualization problems.

6

For me helped to create a duplicate of connection. Invalidation of cashes and restart didn't work, and all previous comments

2

Thank you, Aleksey. Duplicating solved the issue for me as well

2

Thank You, Darius!

I had a similar Issue where a new Table cant open as a Tab.

It is Visible in List, Console can query it, but no tab can be open

=> Invalidate and Restart helped!

 

@PHPStorm-Developers: Need to be fixed!

1

I managed to solve this by selecting "All schemas" under the Schemas tab when adding a DB Source.

This didn't work once the DB Source was already added.

1

Andrey,

I already tried all those things and it is still showing 0 of 8 as you can see in the image below.

 

The schema is selected but nothing is showing and I'm pretty sure that the connection is woking because I can fetch some data form the console.

Do you have any other idea?

Thanks.

0

0 number indicates that there are zero schemas actually selected. Please try explicitly selecting the schema in the popup (so that it has the check-mark). Also try selecting other schemas. Does it work?

Is issue remains, please post the content of idea.log after IDE restart, selecting the schema and selecting the Synchronize action. Thanks.

0

Hey, Andrey.

It didn't work. :(

0

What is the current issue? Are you able to execute the queries but the schemas are not shown in Database tool window? 

Could you please post Details output from Test Connection button for the Data Source, attach the screenshot of Shemas tab for the data source and idea.log after IDE restart and trying to synchronize the data source (if possible please upload it somewhere than posing complete content here). Thank you.

0

Okay, I had this problem and was selecting/deselecting in the tab shown above. Guess what? The filter funnel icon in the Database panel was set not to show schemas. This explains why I was able to see the schemas in one project, but not able to see them in another project even when using an identical connection (or even the same connection, set to be shared globally).

tl/dr click the blue funnel icon in the menu bar of the Database panel. Click 'All'.

0

For me helped invalidate cache and restart

0

I can see from the screenshot Sandro has posted that some filtering is active (green dot beside the funnel icon). I think it's possible that some software upgrades might introduce a filter - I've certainly never opted to 'not see' my schemas! So in addition to other checks, I would definitely suggest checking if the filters are stopping you see the tables.

0

Please sign in to leave a comment.