Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Programming » Java in the database » Java support in SQL Anywhere

 

Accessing methods in the Java class

To access the Java methods in the class, you must create stored procedures or functions that act as wrappers for the methods in the class.

♦  To call a Java method using Interactive SQL
  1. Create the following SQL stored procedure to call the Invoice.main method in the sample class:

    CREATE PROCEDURE InvoiceMain( IN arg1 CHAR(50) )
    EXTERNAL NAME 'Invoice.main([Ljava/lang/String;)V'
    LANGUAGE JAVA;

    This stored procedure acts as a wrapper to the Java method.

    For more information about the syntax of this statement, see CREATE PROCEDURE statement (web services).

  2. Call the stored procedure to call the Java method:

    CALL InvoiceMain('to you');

    If you examine the database server message log, you see the message "Hello to you" written there. The database server has redirected the output there from System.out.