db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shazin Sadakath (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4467) Non Java Stored Routines Using Java Scripting API
Date Wed, 09 Dec 2009 08:15:18 GMT
Non Java Stored Routines Using Java Scripting API
-------------------------------------------------

                 Key: DERBY-4467
                 URL: https://issues.apache.org/jira/browse/DERBY-4467
             Project: Derby
          Issue Type: Improvement
          Components: Network Server
         Environment: Windows XP, Java 1.6
            Reporter: Shazin Sadakath
            Priority: Minor


I have been working on an idea that lets you create Stored Procedures using languages other
than Java with a perspective of Apache Derby as a Network Server. I tried this by using Sun
Java Scripting API for JRE 1.6+ and Apache BSF http://jakarta.apache.org/bsf/ for JRE 1.4+.

This has certain advantages when it comes to compiled java stored routines.

1. It is dynamic.
2. Requires no configuration of classpath.
3. Requires no use of SQLJ.INSTALL_JAR and SQLJ.REPLACE_JAR.
4. Very easy to maintain
5. Allows the use of Sun Java Runtime Library via Object Binding.
6. Supports JavaScript, Jython, Dynamic Java and many more scripting languages. https://scripting.dev.java.net/
7. No need of introducing a new SQL/PSM grammar to the current SQLParser.

Just an idea in its very early stage. Would like to hear your responses.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message