| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Migration of DB2 java stored procedures to PostgreSQL |
| Date: | 2020-08-24 17:31:36 |
| Message-ID: | dc73d0285cc5905c27f5931a3b5ee58fe065e45a.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2020-08-24 at 16:32 +0000, Dirk Krautschick wrote:
> for a potential migration from DB2 on DB2/z to PostgreSQL I have to take care of a whole
> bunch of java stored procedures. Would that be a show stopper here or is a migration
> somehow possible or is it anyway the same because Java = Java?
>
> Any experiences/recommendations or helpful ressources?
There is PL/Java, but it is not part of the core PostgreSQL distribution, so you'd
have to build it yourself.
If performance is important or you don't want to depend on third-party modules,
post the code to PL/Python or PL/Perl. If the code is just glue around some SQL,
PL/pgSQL might be the best choice.
Yours,
Laurenz Albe
--
+43-670-6056265
CYBERTEC PostgreSQL International GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Clarke | 2020-08-24 18:08:42 | Re: Migration of DB2 java stored procedures to PostgreSQL |
| Previous Message | Dirk Krautschick | 2020-08-24 16:32:32 | Migration of DB2 java stored procedures to PostgreSQL |