Blackdread/sql-to-jdl

InformationSchema and KeyColumnUsage not generate on Oracle DB.

dhaalves opened this issue · 3 comments

dhaalves commented

I got all my entities generated except InformationSchema and KeyColumnUsage classes

image

Kind lost how to get this generated;

dhaalves commented

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.
image

Blackdread commented

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.

  • 👍1
octgsoftware commented

Can be closed as the project no longer uses jOOQ and #142 covers Oracle support.