InformationSchema and KeyColumnUsage not generate on Oracle DB.

[dhaalves]

I got all my entities generated except InformationSchema and KeyColumnUsage classes

Kind lost how to get this generated;

[dhaalves]

Nevermind, just dig in and checked that your code won't be compatible with Oracle and DBs that don't provide a information_schema... Maybe this issue can be treated as a feature request...

A also did a simple smoke test with POSTGRES and although it has a information_schema, it also fail for me, some constants were not present (optional?). Check the image above.

[Blackdread]

Thanks for this issue.

I have modified the README to help better understand this project and how to make it work with other databases. Changes needed should be very easy, I am not taking the taking to implement; Big thanks if you get something working and send a PR.

This implementation works with mysql 5.7.

Only few changes are required to make it work with mysql 8+, oracle db, POSTGRES, etc; Changes should be made on Repository used, probably remove jooq maven generation, use pure SQL with jdbc and have one repository implementation per database type supported then define the appropriate bean based on connection string or other.

[octgsoftware]

Can be closed as the project no longer uses jOOQ and https://github.com/Blackdread/sql-to-jdl/issues/142 covers Oracle support.