Re: Unavailability of Jar for connectivity in Postgres

On 7/5/19 5:35 AM, Abraham, Nikhil (COR), Vodafone Idea wrote:
> Dear Team,
> 
> Good Wishes.
> 
> We are planning to migrate one of our critical applications from Oracle 
> to 11.1 Postgresql. The UI of the application calls lots of PL/SQL 
> procedures. In order to have that calling facility there is a jar 
> provided by the respective databases. Currently the ODBS-JDBC 
> connectivity drivers are provided by Oracle in the form of jar. However 
> connectivity from UI to call procedures in Postgresql is currently not 
> possible in absence of such a driver. The reason being no jar is 
> provided for such connectivity for version 11.1 Postgresql.

There is a JDBC driver for Postgres:

https://jdbc.postgresql.org/documentation/head/index.html

and it can call stored functions:

https://jdbc.postgresql.org/documentation/head/callproc.html

If this is not what you are looking for then can you be more specific 
about your needs?


> 
> This challenge has become a show stopper for migration, please let us 
> know whether any alternative are available for the same.
> 
> Regards
> 
> Nikhil
> 
> This E-Mail (including any attachments) may contain Confidential and/or 
> legally privileged Information and is meant for the intended 
> recipient(s) only. If you have received this e-mail in error and are not 
> the intended recipient/s, kindly notify us at 
> mailadmin@vodafoneidea.com and then delete this e-mail immediately from 
> your system. You are also hereby notified that any use, any form of 
> reproduction, dissemination, copying, disclosure, modification, 
> distribution and/or publication of this e-mail, its contents or its 
> attachment/s other than by its intended recipient/s is strictly 
> prohibited and may be unlawful. Internet Communications cannot be 
> guaranteed to be secure or error-free as information could be delayed, 
> intercepted, corrupted, lost, or may contains viruses. Vodafone Idea 
> Limited does not accept any liability for any errors, omissions, viruses 
> or computer shutdown (s) or any kind of disruption/denial of services if 
> any experienced by any recipient as a result of this e-mail.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com