SQL Performance Tuning [Electronic resources] نسخه متنی

Parting Shots

If you're using JDBC with applets, define methods with the keyword synchronized. That prevents other synchronized methods from getting in while an object is being accessed.

You can put Java/JDBC routines in JAR files that the DBMS can read. The SQL procedure declaration would look something like this:

CREATE PROCEDURE Sp_proc
READS SQL DATA
DYNAMIC RESULT SETS 1
EXTERNAL NAME <jar:name>
LANGUAGE JAVA
PARAMETER STYLE JAVA

The assumption here is that the DBMS supports SQL Java (SQLJ) routines, can load JARs, and can invoke a Java Virtual Machine (JVM). Some DBMSs (Informix and Sybase are examples) supply copies of Apache Web Server with their installation CD-ROMS. Oracle takes a different approach and loads its own JVM. With a standard Web server installed, it should be easy for the DBMS to access Java routines as servlets.