Default schema for database console in Idea 2016.2.4
Answered
After upgrading to Idea 2016.2.4 my DB2 zos data source
a] There is an error when executing set current schema <> command
b] Setting currentSchema property in advanced tab caused console to produce error after each statement
[42612][-142] THE SQL STATEMENT IS NOT SUPPORTED. SQLCODE=-142, SQLSTATE=42612, DRIVER=3.57.82
1. Is described behavior an issue or it can be configured to eliminated this error?
2. Is there a different way to set default schema for the data source?
Please sign in to leave a comment.
There is an open issue: https://youtrack.jetbrains.com/issue/DBE-2004.
I'll ping the responsible developer.
This issue should be fixed in 2017.1: https://www.jetbrains.com/idea/nextversion/.
The problem seems to be back in 2018.2. Every SQL statement I execute gives me console output in IntelliJ that looks like this:
[2018-07-26 14:55:16] [01000][4474] [jcc][t4][10217][10310][3.64.104] Connection read-only mode is not enforceable after the connection has been established.
[2018-07-26 14:55:16] To enforce a read only connection, set the read-only data source or connection property. ERRORCODE=4474, SQLSTATE=01000
sql> values (current_schema)
[2018-07-26 14:55:17] [42612][-142] THE SQL STATEMENT IS NOT SUPPORTED. SQLCODE=-142, SQLSTATE=42612, DRIVER=3.64.104
[2018-07-26 14:55:17] [26501][-514] THE CURSOR SQL_CURLH200C1 IS NOT IN A PREPARED STATE. SQLCODE=-514, SQLSTATE=26501, DRIVER=3.64.104
sql> select ... and the rest of the perfectly fine SQL statement.
I get correct results from the SQL, but it puts up the error message on the UI.
My "About" screen says
IntelliJ IDEA 2018.2 (Ultimate Edition)
Build #IU-182.3684.101, built on July 24, 2018
Licensed to *************************
JRE: 1.8.0_152-release-1248-b8 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Windows 7 6.1
Hello,
Please try to update your driver version and check the issue again.
Please follow this issue for updates: https://youtrack.jetbrains.com/issue/IDEA-196367.