Iseries DB2/AS400 database connection don't show tables
已回答
I can connect to the DB and see the schema XXXXX which is the one I'm using but I can not see the tables, I can also query the tables of this schema using the console so I don´t know what is the problem.
I already try to run the refresh button but nothing change.
The problem has come with the upgrade pf pycharm 2021.2.1 Professional edition in the 2020 edition it was working super fine.
I'm using the correct jdbc driver that is jt400.jar
It would be really usefull to fix this bug, can someone help me to find a solution?
请先登录再写评论。
please right-click on schema -> diagnostics -> diagnostic refresh, upload received files here and provide me with upload id.
2021_09_14_2p1XFkLvWk3ZDnNb
ok now please do this - right-click on data source name -> database tools -> force refresh, wait until it finishes and upload IDE logs from
1. Help -> Collect logs and diagnostic data
2. Help -> Show SQL logs (database.log files)
2021_09_14_BtPrin1uFBUePKi8
In the zip logs and diagnostic data i delete all file modified before today.
I guess at the moment the only workaround is to use v.2020.3.5 while we investigating the issue.
Ok, of course i will not use the v.2020.3.5 i will wait until the bug fix.
Thank you very much!
Vittorio could you please check any schema where is no underscore _ in the name? I mean select it and let it be introspected.
Good morning Yuriy, i tried with a schema without underscore and it works great.
You seem to have found the problem!
ok great. we will add an option in next version which will allow to avoid such cases.
Thank you!
When the next version is planned?
Vittorio Looks like the fix will appear in PyCharm 2021.2.3 which is planned for October 6
Good morning Yuriy, are you sure that you have fixed the bug in the new version 2021.2.3?
Could you please upload new logs?
right-click on data source name -> database tools -> force refresh, wait until it finishes and upload IDE logs from
1. Help -> Collect logs and diagnostic data
2. Help -> Show SQL logs (database.log files)
Upload id: 2021_11_12_GsWCytHLGABH7Szb (files: database.0.log, pycharm-logs-20211112-135502.zip)
In the zip logs and diagnostic data i delete all file modified before today.
Up
Please open up data source properties, go to Advanced tab, and add this to the very end of table:
`dont.escape.metadata.calls` with value = `true`. without quotes.
Let me know if it helps.
Done,
nothing has change i add that line and after i make a force refresh but nothing change.
I confirm that i can see only tables and view of schemas without underscore.
You can see the bug from the attachments
Let's do this: close IDE, go <project_root_folder>\.idea, open dataSources.xml, find your data source and after <jdbc-url>..</jdbc-url> node add this:
<jdbc-additional-properties> <property name="dont.escape.metadata.calls" value="true"/> </jdbc-additional-properties>and Run IDE and check.
After editing the dataSources.xml and restart IDE i also made a 'force refresh' and now it works great!
Thank you so much!
Great!
Hello Yuriy,
today the problem is back, but this time the old procedure isn't working....
what can i do?
Is it stopped to work after IDE update?
No, it was working also after the update.
Then suddenly it stopped again.
Please upload fresh IDE logs.
Hello Yuriy, the problem occurs also with new version PyCharm 2022.2.2 (Professional Edition)
here is the log file 2022_09_27_YdmHi5kUxpst7tr5kqE9ZK
UP
Yuriy Vinogradov
Have still not working...
Hello Vittorio,
Could you please create a separate support request via **Help | Contact support** in PyCharm on this matter?