[This topic is migrated from our old forums. The original author name has been removed]
In 9.1.X DBVisualizer versions (just tested on 9.1.13), the following query (which is used, per the debug log, for loading schema names in the Connections left menu) returns correctly.
However, in 9.2.X versions (tested on 9.2.3-9.2.7), this query returns the correct number of results (e.g.- 1,474), but as empty/blank names.
username AS TABLE_SCHEM
'PUBLIC' AS TABLE_SCHEM
Version: Oracle9i Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 22.214.171.124.0 - Production
Driver: Oracle JDBC driver 126.96.36.199.0
This seems to cause issues with other queries with references to those schemas.
Is there any workaround or setting change to fix this? Thanks!
In DbVisualizer 9.2 the JDBC driver for Oracle was updated to the most recent version. You probably need to use an older version of the driver that is compatible with your version of Oracle.
If you used versions of DbVisualizer before 9.2 successfully with Oracle 9 then you can download and unpack the following driver.
Now open DbVisualizer and the Tools->Driver Manager. Create a new custom driver entry and then select it. In the User Specified right pane tab click the Open button and load all of the .jar files in the folder. Wait until the custom driver is displayed with a green icon in the list. Close the driver manager.
Then in the connection tab for your Oracle 9 connection, choose the new custom Oracle driver.
I hope this helps.
almost 5 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Oracle Schema names not loading correctly?
Thank you- that worked! I also like this solution because it should persist as I upgrade versions of DBVis.