Executing Java External Procedures

SQL> CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "JavaExtproc" AS
     public class SimpleMath {
         public static int findMax(int x, int y) { 
             if (x >= y) return x;
             else return y;
         }
     }
     /

SQL> CREATE OR REPLACE AND RESOLVE Java SOURCE NAMED "JavaExtproc" AS
     public class SimplePrint {
         public static void printMax(int x, int y) { 
         if (x >= y) System.out.println("Max="+x); 
         else System.out.println("Max="+y);
         }
     }
     /
Java Source 'JavaExtproc' created.

SQL> CREATE OR REPLACE PROCEDURE print_max(x pls_integer, y pls_integer) IS 
     LANGUAGE JAVA NAME 'SimplePrint.printMax(int, int)';
     /
Procedure 'PRINT_MAX' created.

SQL> set serveroutput on
SQL> call dbms_java.set_output(2000); 

PSM called.

SQL> BEGIN print_max(1, 2); END;
     / 
Max=2

PSM completed.

SQL>

Connection conn = DriverManager.getConnection("jdbc:tibero:localhost:9999:tibero",
                                              "tibero", "tibero");

Connection conn = DriverManager.getConnection("jdbc:default:connection:");

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "TestInternal" as
import java.sql.*; 
import java.io.*;

public class POManager
{
   public static void addCustomer (int custNo, String custName, String city) 
   throws SQLException
   {
       String sql = "INSERT INTO Customers VALUES (?,?,?)"; 
       try
       {
         Connection conn = DriverManager.getConnection("jdbc:default:connection:");
       
         PreparedStatement pstmt = conn.prepareStatement(sql); 
         pstmt.setInt(1, custNo);
         pstmt.setString(2, custName); 
         pstmt.setString(3, city); 
         pstmt.executeUpdate(); 
         pstmt.close();
       }
       catch (SQLException e) { 
          System.err.println(e.getMessage());
       }
   }
}