Enhanced postgres persistence configuration - avoid public schema as default

[lefebsy]

Is your feature request related to a problem? Please describe.

Hello,

Polaris tests of deployment with eclipseLink and Postgres : I would like to be able to declare the name of the schema in the persistence.xml config file.

• Today the tables are stored in the 'public schema' of configured database.

• At least, if not configurable from persistence.xml, please set default schema as something related to Polaris, but really not public.

Describe the solution you'd like

Not storing Polaris tables in public schema of Postgres when using eclipselink.

Describe alternatives you've considered

• hardcoded default schema related to Polaris
• configurable schema from persistence.xml

Additional context

Tested with eclipseLink getting started and Polaris v1-incubating

[eric-maynard]

cc @singhpk234

[singhpk234]

Thanks @eric-maynard !

@lefebsy this makes sense, let me see how we can handle this in current eclipse link, presently i am working on a JDBC impl, which will give user much more flexibility to configure this.

[singhpk234]

@lefebsy i realized you had some changes to support "configurable schema from persistence.xml", this approach seems reasonable to me, do you wanna go ahead and submit your changes ? I am happy to review

[lefebsy]

@lefebsy i realized you had some changes to support "configurable schema from persistence.xml", this approach seems reasonable to me, do you wanna go ahead and submit your changes ? I am happy to review

Hello,

No no, I have no working solution available.
I have effectively tested many settings and tips related to eclipseLink persistence.xml found on the internet, but nothing working as is with Polaris.

Sorry, I would have been happy to contribute. I will spend more time to dig this a little more.