Thread: Support for procedures call
Hello,
Can you tell me if in the near future the JDBC driver will support Postgresql procedures call?
Our company is migrating a large product from Oracle to Postgresql and it will be a great help to keep the procedures instead of transforming them into functions.
Thank you,
Roxana.
| Roxana Tolosi | Work: | +40212428720 |
Hello,
Do you have any news on an updated JDBC driver that can call procedures?
Thank you,
Roxana.
Roxana Tolosi
Project Manager
Advantage Software FactoryWork:
Fax:
Mobile:+40212428720
+40212428722
+40 728 306 339
From: Dave Cramer <pg@fastcrypt.com>
Sent: Sunday, November 17, 2019 4:16 PM
To: Roxana Tolosi <roxana.tolosi@asf.ro>
Subject: Re: Support for procedures call
Are you aware you cannot use procedures in a transaction ?
There is a pull request to allow them with a connection parameter. I suspect it will be merged for the next version
On Thu, 14 Nov 2019 at 10:39, Roxana Tolosi <roxana.tolosi@asf.ro> wrote:
Hello,
Can you tell me if in the near future the JDBC driver will support Postgresql procedures call?
Our company is migrating a large product from Oracle to Postgresql and it will be a great help to keep the procedures instead of transforming them into functions.
Thank you,
Roxana.
Roxana Tolosi
Project Manager
Advantage Software FactoryWork:
Fax:
Mobile:+40212428720
+40212428722
+40 728 306 339
Thank you very much for your answer!
Roxana.
| Roxana Tolosi | Work: | +40212428720 |
From: Dave Cramer <pg@fastcrypt.com>
Sent: Monday, April 27, 2020 1:48 PM
To: Roxana Tolosi <roxana.tolosi@asf.ro>; pgsql-jdbc@lists.postgresql.org
Subject: Re: Support for procedures call
Hello Roxana,
The driver already supports it and has for a while. See
There is a property escapeSyntaxCallMode which controls how the driver deals with procedures
Regards,
On Mon, 27 Apr 2020 at 05:19, Roxana Tolosi <roxana.tolosi@asf.ro> wrote:
Hello,
Do you have any news on an updated JDBC driver that can call procedures?
Thank you,
Roxana.
Roxana Tolosi
Project Manager
Advantage Software FactoryWork:
Fax:
Mobile:+40212428720
+40212428722
+40 728 306 339
From: Dave Cramer <pg@fastcrypt.com>
Sent: Sunday, November 17, 2019 4:16 PM
To: Roxana Tolosi <roxana.tolosi@asf.ro>
Subject: Re: Support for procedures call
Are you aware you cannot use procedures in a transaction ?
There is a pull request to allow them with a connection parameter. I suspect it will be merged for the next version
On Thu, 14 Nov 2019 at 10:39, Roxana Tolosi <roxana.tolosi@asf.ro> wrote:
Hello,
Can you tell me if in the near future the JDBC driver will support Postgresql procedures call?
Our company is migrating a large product from Oracle to Postgresql and it will be a great help to keep the procedures instead of transforming them into functions.
Thank you,
Roxana.
Roxana Tolosi
Project Manager
Advantage Software FactoryWork:
Fax:
Mobile:+40212428720
+40212428722
+40 728 306 339