Re: Postgres and Java Microservices Multithreading

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, [email protected] 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: '[email protected]' <
> [email protected]>; '[email protected]' <
> [email protected]>
> 
> 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: '[email protected]' <
> [email protected]>;
> [email protected]
> 
> 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 : [email protected]
skype : peter_m_groen