search

CloverETL / CloverETL-Engine

http://www.cloveretl.com
GNU Lesser General Public License v2.1
49 stars 35 forks source link

BasicSqlConnection use of Catalog #4

Open sbogrett opened 7 years ago

sbogrett commented 7 years ago

I have a generic JDBC driver that talks to a WebService. The DatabaseMetaData indicates that catalogs are not used by returning false for all of the appropriate supportsCatalogs methods. The driver returns no catalogs from the getCatalogs(). The driver returns a list of schemas from the getSchemas() call. The BasicSqlConnection calls getTables with a catalog parameter with the name of a schema even though no catalogs are listed in getCatalogs() but there are schemas listed in getSchemas().

urbanj commented 7 years ago

Hi,

you can override the behavior of BasicSqlConnection and define your own behavior. See for example MySQLConnection, it overrides the getTables method. Your new implementation will have to be registered in plugin.xml, and then selected in the connection in the graph.