There is no reason why it shouldn't work as long as you use the
database only as a data storage and all the java-stuff is as a separate
layer in your software.Conversion problems can happen on data-types,
constraints and/or triggers. If you use stored-procedures, those should
be converted / rewritten as well..
A bit of a strange question as this is basic datbase knowledge.... ??/
Esp. if you're working at KPN.
On Thu, 2019-12-05 at 12:22 +0000, soumik(dot)bhattacharjee(at)kpn(dot)com wrote:
> Hi Experts,
>
> Few more details as discussed with application team.
>
> In parallel processing Application will create multiple threads
> towards our PG database to retrieve/ update data.
>
>
>
>
> Application will send multiple parallel requests to DB on same table
> to SELECT data.Application will send multiple parallel requests to DB
> on same table to UPDATE dataApplication will send multiple parallel
> requests to DB on same table to INSERT data
>
>
>
> Thanks..
>
>
>
> From: Bhattacharjee, Soumik
>
>
> Sent: donderdag 5 december 2019 10:48
>
> To: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <
> pgsql-admin(at)lists(dot)postgresql(dot)org>; 'pgsql-admin(at)postgresql(dot)org' <
> pgsql-admin(at)postgresql(dot)org>
>
> Subject: RE: Postgres and Java Microservices Multithreading
>
>
>
> Hi Experts,
>
> Please let me know if you have some use cases or documentations
> around this.
>
> Any response will help me a lot in this context.
>
> Thanks in advance.
>
>
>
>
> From: Bhattacharjee, Soumik
>
>
> Sent: woensdag 4 december 2019 14:34
>
> To: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <
> pgsql-admin(at)lists(dot)postgresql(dot)org>;
> pgsql-admin(at)postgresql(dot)org
>
> Subject: Postgres and Java Microservices Multithreading
>
>
>
> Hi Experts,
>
> To set the context we are operating in Oracle 11g R2 and our
> applications are deployed in private cloud and all 15 + Java micro
> services are multithreaded.
>
> And we are doing database migration from Oracle 11gR2 to
> Postgres 12.
>
> So if anyone can share your experience
> or share some documentations/use cases if we can maintain the same
> configurations for Java micro services with multithreading as we are
> using in
> Oracle and same works in Postgres too? – (We just plan to switch the
> data source from Oracle to Postgres- will that work? )
>
>
> Thanks..
>
>
>
>
--
Open Systems Development B.V.
Peter M. Groen
Managing Director
Rooseveltstraat 18-P
2321 BM Leiden
+31 6 12 08 95 62
email : peter(at)osdev(dot)nl
skype : peter_m_groen