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.
--
Open Systems Development B.V.
Peter M. Groen
Managing Director
Rooseveltstraat 18-P
2321 BM Leiden
+31 6 12 08 95 62
skype : peter_m_groen
On Thu, 2019-12-05 at 12:22 +0000, soumik.bhattacharjee@kpn.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 data
- Application 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@lists.postgresql.org' <pgsql-admin@lists.postgresql.org>; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.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.
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..