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] Updated: (DERBY-4467) Non Java Stored Routines Using Java Scripting API
Date Wed, 09 Dec 2009 09:02:18 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Shazin Sadakath updated DERBY-4467:

    Attachment: DerbyStoredRoutine.zip


> 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
>         Attachments: DDL.sql, DerbyStoredRoutine.zip, ScreenShot.JPG
> 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
> 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.
> There are two approaches for this enhancement. 
> 1. Having this as an external utility component such as ij, dblooks
> 2. Having this as a built in feature.
> I have done this in the former method for demonstration purpose.

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

View raw message