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.

   


SQL Performance Tuning
SQL Performance Tuning
ISBN: 0201791692
EAN: 2147483647
Year: 2005
Pages: 125

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net