× Heads up!

Aqua Data Studio / nhilam

IDE for Relational Databases
SachinPrakash reported 2015-04-04T01:33:01Z  · tariqrahiman last modified 2017-02-28T23:06:59Z

Enhance Generic JDBC schema browser to display schemas specific to DB

customer request
Jenny Nishimura
Tariq Rahiman
Priority Minor
Complexity Moderate
Component App - General
Version 16.0

The JDBC API does support a call to DatabaseMetaData.getSchemas() which takes a DB name as an input parameter. We'll make an enhancement to ADS to invoke this method so that we can display schemas per DB for Generic JDBC connection.

The API call we make today: http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas()

The API call w/ input parameters: http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas(java.lang.String,%20java.lang.String)

In my experimentation, I noticed that not all JDBC driver vendors implement the getSchemas(String, String) call. So if this method throws an exception, we should fallback to getSchemas() w/ no input parameters.

The term "Catalog" refers to the DB name.

3 attachments

Issue #13212

Resolved 2015-12-07T22:59:15Z
No due date
Fixed Build ADS 16.0.10-5
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017