Re: How To connect to server root with jdbc driver
Posted by: Mx Dog
Date: February 28, 2022 07:54PM

The closest I came up with as a solution was to use information_schema.tables as the connection database and then filter/pick schemas and tables out from their.

Some other Databases have an actual "Catalog" to connect to and the drivers deal with the info from that catalog iirc. For instance I use Pentaho Spoon a lot with Postgres I can connect to the server and use the explore database feature of steps to peruse schemas and pick and choose schemas/tables/columns.

Cannot do the same with this driver you basically have to know what you are after in advance or query the information schema to get a list .

Using the information Schema gets me going thanks for the reply.

Options: ReplyQuote

Written By
Re: How To connect to server root with jdbc driver
February 28, 2022 07:54PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.