Advantages of Java in the database

 

 

 

Adaptive Server provides a runtime environment for Java, which means that Java code can be executed in the server. Building a runtime environment for Java in the database server provides powerful new ways of managing and storing both data and logic.

• You can use the Java programming language as an integral part of Transact-SQL.
  
• You can reuse Java code in the different layers of your application—client, middle-tier, or server—and use them wherever makes most sense to you.
  
• Java in Adaptive Server provides a more powerful language than stored procedures for building logic into the database.
  
• Java classes become rich, user-defined data types.
  
• Methods of Java classes provide new functions accessible from SQL.
  
• Java can be used in the database without jeopardizing the integrity, security, and robustness of the database. Using Java does not alter the behavior of existing SQL statements or other aspects of non-Java relational database behavior.