#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0

    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by gusachde
    With recent versions of PostgreSQL, it seems that stored procedures can be written in Java also.
    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.

    Is there any performance implication of writing stored procedures in Java. Is the feature support equivalent to that of PL/SQL.
    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.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo