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

SQL Anywhere 17 » SQL Anywhere Server - Programming

Java in the database

The database server supports a mechanism for executing Java classes from within the database environment. Using Java methods from the database server provides powerful ways of adding programming logic to a database.

Java support in the database offers the following:

  • Reuse Java components in the different layers of your application (client, middle-tier, or server) and use them wherever it makes the most sense to you.

  • Java provides a more powerful language than the SQL stored procedure language for building logic into the database.

  • Java can be used in the database server without jeopardizing the integrity, security, or robustness of the database and the server.

The SQLJ standard

Java in the database is based on the SQLJ Part 1 proposed standard (ANSI/INCITS 331.1-1999). SQLJ Part 1 provides specifications for calling Java static methods as SQL stored procedures and functions.