January 29th, 2014, 05:28 AM
Stored Procedure in Java
With recent versions of PostgreSQL, it seems that stored procedures can be written in Java also. Is there any performance implication of writing stored procedures in Java. Is the feature support equivalent to that of PL/SQL.
January 29th, 2014, 06:50 AM
There was an extension called PL/Java but I don't think it's maintained any more and I don't think it will run on any current Postgres version.
Originally Posted by gusachde
PL/SQL and Java are two completely different things. I don't understand why you are comparing those.
Postgres natively has a procedural language called PL/pgSQL which is very similar to Oracle's PL/SQL. If you want to write stored procedures that is the preferred way.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: