Oracle Schema names not loading correctly? : DbVis Software

a

anonymous

started a topic over 9 years ago

[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.

SELECT
    username AS TABLE_SCHEM
FROM
    all_users
UNION
SELECT
    'PUBLIC' AS TABLE_SCHEM
FROM
    dual
ORDER BY
    TABLE_SCHEM


Database details:
Version: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production
Driver: Oracle JDBC driver 12.1.0.2.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!

Roger Bjärevall

said over 9 years ago

[This reply is migrated from our old forums.]

Re: Oracle Schema names not loading correctly?

Hi,

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.

http://www.dbvis.com/temp/oracle.zip

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.

Regards

Roger

a

anonymous

said over 9 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.

Thanks!

How can we help you today?

Oracle Schema names not loading correctly?

anonymous

Roger Bjärevall

anonymous