Thread: Unavailability of Jar for connectivity in Postgres

Unavailability of Jar for connectivity in Postgres

From
"Abraham, Nikhil (COR), Vodafone Idea"
Date:

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.  

 

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.

Re: Unavailability of Jar for connectivity in Postgres

From
Adrian Klaver
Date:
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