DB test says connected but still get DB "Unable to resolve symbol"
In the view -> Tool Windows -> database I select the schema, click properties and then click the Test Connection to which it says it succeeded. However, I still see all these Unable to resolve symbol for the names of tables and fields which means it's really not using it.
I've followed everything I could find on the Jetbrasins site and web but nothing seems to work.
Please sign in to leave a comment.
Things to check first:
If everything's configured correctly, please try using a simple SQL statement like
SELECT * FROM tableName- will completion also fail there?Thanks for the response.
Changing those fixed some of the problems, mainly when it complained the schema was unresolved. But it still complains about field names within a schema table.
A statement like: SELECT <field name> FROM <schema>.<table>
It no longer complains the schema isn't resolved but now complains the field name isn't resolved.
So it's definitely better but not 100%
Do I get it right that in
SELECT * FROM, you get completion for schemas and tables, but inSELECT <caret> FROM schema.table, you don't?If so, please share screenshots of what you have configured in the SQL Resolution Scopes view (make sure to make the dropdown and everything that is checked in it visible), in SQL Dialects, and a screenshot of what you see in the data source properties after you click Test Connection.
Thank you!
Yesterday it didn't work. Today, after restarting phpStorm, it works. Don't understand the reason why but I'll take it. Thanks for your responses.