Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Oracle driver upade to Oracle JDBC driver 12.1.0.2 - ojdbc7.jar - certified for JDK7 and JDK8 appears to have issues working with oracle 9i.
If you connect to oracle 9i and click on the schema node you will notice that a blank schema and the public schema are the only schemas showed. We use the metadata to display the schemas. The metadata of the driver issues the following queries:
NEW ORACLE DRIVER : SELECT username AS table_schem, null as table_catalog FROM all_users ORDER BY table_schem GO OLD ORACLE DRIVER : SELECT username AS table_schem FROM all_users ORDER BY table_schem
The wierd thing is that if you execute these queries in data studio 18, results are correct but in 17 results are showing blanks for the names.
If i downgrade the drivers to the previous drivers in version 17 to ojdbc6.jar and orai18n.jar then this issue goes away.
Oracle drivers must be downgraded by user to connect work with Oracle 8i and 9i. See FAQ from Oracle ...
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_02
Which version of JDBC drivers support which version of Oracle database?
Please refer to the table below for the Oracle database versions supported by JDBC drivers. Best Practice that we recommend is, JDBC driver version should always be either same as or higher than the Oracle database version being used in order to leverage the latest capabilities of the JDBC driver.
| Interoperability Matrix | Database 12.1.0.x | Database 11.2.0.x | Database 11.1.0.x |
| JDBC 12.1.0.x |
Yes
|
Yes
|
Yes
|
| JDBC 11.2.0.x |
Yes
|
Yes
|
Yes
|
| JDBC 11.1.0.x |
Yes
|
Yes
|
Yes
|
Oracle drivers must be downgraded by user to connect work with Oracle 8i and 9i. See FAQ from Oracle ...
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_02
Which version of JDBC drivers support which version of Oracle database?
Please refer to the table below for the Oracle database versions supported by JDBC drivers. Best Practice that we recommend is, JDBC driver version should always be either same as or higher than the Oracle database version being used in order to leverage the latest capabilities of the JDBC driver.
| Interoperability Matrix | Database 12.1.0.x | Database 11.2.0.x | Database 11.1.0.x |
| JDBC 12.1.0.x |
Yes
|
Yes
|
Yes
|
| JDBC 11.2.0.x |
Yes
|
Yes
|
Yes
|
| JDBC 11.1.0.x |
Yes
|
Yes
|
Yes
|
wikidoc page requires updating:
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation18/page/Oracle-JDBC-Drivers/Oracle-JDBC-Drivers
wikidoc page requires updating:
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation18/page/Oracle-JDBC-Drivers/Oracle-JDBC-Drivers
No code changes necessary. We will update our documentation:
No code changes necessary. We will update our documentation:
Issue #14986 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
If i downgrade the drivers to the previous drivers in version 17 to ojdbc6.jar and orai18n.jar then this issue goes away.