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.

View raw message