Page 1 of 1

App server multiDB

Posted: Mon 18 Jan 2021 11:33
by claudio.piffer
HI,

I use last version of Delphi, last version of uniDAC and last version of the EntityDAC.

I need to create a REST server API that work in Oracle or PostgreSQL.

What are the specifications with EntityDAC in order to create a single application (net of the management of the UniDAC connection and related drivers).
Given that the names of the tables will be identical (the two DBs have the same structure but I can managed this with the name of the entities) what can change are the name of the sequences.
I normally use the "Code-Mapped Entity" model. How can I manage the correct model in relation to the type of DB to which I connect? Should I upload the Model.Mapping.xml at run-time?

Thank you very much and best regards

Re: App server multiDB

Posted: Tue 19 Jan 2021 06:38
by MaximG
We will check the workflow of our product according to your description. For this, we need some time. We will inform you
about the results after the end of testing

Re: App server multiDB

Posted: Tue 19 Jan 2021 12:06
by claudio.piffer
Thank you Maxim!

I hope you will be able to check it soon because the product is almost finished (also the porting of the Oracle DB structure on PostgreSQL) and I need to close.

Best Regards!

Re: App server multiDB

Posted: Mon 01 Feb 2021 13:54
by MaximG
We need some more time to conduct testing.