Java external procedures have 2 special requirements for creation or replacement that other types of external procedures do not.
- The user who creates a Java external procedure must be the same user who registered its associated JAR file by calling SQLJ.Install_Jar (see JAR Files and SQLJ Database). This means that the jar_name you specify when you create the procedure must refer to a JAR file that you registered. If any other user registered the JAR file you specify, the CREATE/REPLACE PROCEDURE request aborts and returns an error to the requestor.
- The containing database for any Java external procedure you create must match the default database at the time you register its JAR file using SQLJ.Install_Jar.