Hi I want to configure my application to work as OS (filesystem) and DB independent as possible. It should run on Linux, Mac, Windows, support MariaDB, PostgreSQL, H2, etc. Some filesystems are case sensitive, others not. Same with the DBs.
Which combination of RenderNameCase and RenderQuotedNames should I use and how should I format my SQL files for DB initialization? With or without quoted table names, lowercase or uppercase? I tried several combinations. Some work with MariaDB on Linux and Windows fine, but then H2 does not work anymore. Or vice versa. To handle this, I started getting OS- and DB-information programmatically from the system environment and use if-cascades to determine which setting to use. Ugly. Or I implement a configuration option and "outsurce" the trial and error to my users. Ugly, too. Do you have some advice? -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/78d20cc0-ba08-4f00-bbaa-88ead57c8741n%40googlegroups.com.
