db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by DanDebrunner
Date Fri, 13 Jan 2006 01:14:17 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DanDebrunner:
http://wiki.apache.org/db-derby/DerbySQLroutines

------------------------------------------------------------------------------
  
   * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%3C43415F06.3040601@sun.com%3E
A procedure that drops a table if it exists]
  
+ == The power of Java in SQL ==
+ The ability to write functions and procedures in Java brings the complete set of Java
+ apis into your SQL environment as server side logic. A function or procedure may call
+ any of the standard Java libraries, any of the standard Java extensions, or other third
+ party libraries. Examples are:
+ 
+   * SendEmailRoutine Sending e-mail from a database trigger with !JavaMail API
+   * please add others
+   * or even just ideas of libraries that would be useful in Derby
+ 
  == Are Derby Procedures *Stored* Procedures? ==
  Databases, pioneered by Sybase, initially provided stored procedures that were written in
  a enhanced SQL programming language. The enhanced SQL contained flow control, variables
etc.

Mime
View raw message