How do I use Java classes in SQL?

Using Java classes, whether user-defined or from the Java API, is a three-step activity:

1. Write or acquire a set of Java classes that you want to use as SQL datatypes, or as SQL aliases for static methods.

2. Install those classes in the Adaptive Server database.

3. Use those classes in SQL code:

   • Call class (static) methods of those classes as UDFs.

   • Declare the Java classes as datatypes of SQL columns, variables, and parameters. In this book, they are called Java-SQL columns, variables, and parameters.

   • Reference the Java-SQL columns, their fields, and their methods.

   • Wrap static methods in SQL aliases and use them as stored procedures or functions.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF