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(at)vodafoneidea(dot)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(dot)klaver(at)aklaver(dot)com