ASA Programming Guide
Introduction to Java in the Database
The runtime environment for Java in the database
Java syntax works as you would expect it to, and SQL syntax is unaltered by the presence of Java classes. This is true even if the same SQL statement contains both Java and SQL syntax. It's a simple statement, but with far-reaching implications.
Java is case sensitive. The Java class FindOut is a completely different class from the class Findout. SQL is case insensitive with respect to keywords and identifiers.
Java case sensitivity is preserved even when embedded in a SQL statement that is case insensitive. The Java parts of the statement must be case sensitive, even though the parts previous to and following the Java syntax can be in either upper or lower case.
For example, the following SQL statements successfully execute because the case of Java objects, classes, and operators is respected even though there is variation in the case of the remaining SQL parts of the statement.
SeLeCt java.lang.Math.random();