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.
Subject
Written By
Posted
February 18, 2022 01:30AM
February 18, 2022 06:13AM
February 19, 2022 01:48PM
February 21, 2022 04:40AM
Re: How To connect to server root with jdbc driver
February 28, 2022 07:54PM
Sorry, you can't reply to this topic. It has been closed.
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.