List:MySQL and Java« Previous MessageNext Message »
From:pravin kalbhor Date:October 4 2011 5:31am
Subject:executing Java code from database trigger.
View as plain text  
Hi,

I wanted to run java method from trigger. for that i need to write java db
procedure.. as mention in
http://download.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#creating_stored_procedures_java_db
but i am getting sql syntax error at 'AS LANGUAGE' please let me know if you
have th solution for  the same..

my create procedure statement is =

          "CREATE PROCEDURE log_sal(IN idsal float, IN old_sal float, IN
new_sal float) " +
            //"PARAMETER STYLE JAVA " +
          "AS "+
            "LANGUAGE JAVA " +
            //"DYNAMIC RESULT SETS 1 " +
            "EXTERNAL NAME 'com.trigger.DBTrigger.logSal'";

Thread
executing Java code from database trigger.pravin kalbhor4 Oct