Add the database Catalog to all csvs

[adriens]

Add the database Catalog to all csvs

[sualeh]

In that case you will need to write some custom code for those databases, @adriens

[sualeh]

I will build this into SchemaCrawler.

[adriens]

Done.

[sualeh]

What do you intend here? What value will be added to the CSV?

[adriens]

I mean the name of the database.

• On Oracle the SID
• On Postgres the 'database'
• On SQL Server the 'catalog`

[adriens]

For now, i did not yet found how to get this from connectin Metadatas...

[adriens]

@sualeh , when on Oracle, a schema is not the databasename, in a word : schema != SID, same on psql.

[adriens]

Yep, looks like 😄 ...or would it possible to implement a schemacrawler interface on each database product ?

[adriens]

For postgres :

SELECT current_database();

[adriens]

For Oracle :

select * from global_name;

[adriens]

Excellent !!!

[adriens]

Waiting for schemacrawler/SchemaCrawler#230

[sualeh]

See https://stackoverflow.com/questions/7942520/relationship-between-catalog-schema-user-and-database-instance

[sualeh]

Use schemacrawler.schema.DatabaseInfo.getServerInfo()

[adriens]

See schemacrawler/SchemaCrawler#238

[adriens]

Hi @sualeh , just gave it a try... unfortunately it did not change the actual behavior, the catalogName is still not retrieved ;-(

I've added this just after your code in the execute section :

System.out.println("FOUND DB NAME SID : <" + getDbCatalogName() + ">");

...and it remains empty.

[adriens]

Thhanks to #23 things are now possible ! 🎆

[adriens]

Working on psql.

[adriens]

Now validating on Oracle 12.x...

[adriens]

Not able to connect to Oracle @sualeh see schemacrawler/SchemaCrawler#240

[adriens]

Connection OK, now focusing on getting the service_name from a standard sql user see schemacrawler/SchemaCrawler#241

[adriens]

Done with the sclint-catalogName column.