Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; CHARSET=US-ASCII; format=flowed
Date: Tue, 08 Dec 2009 06:26:20 -0800
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: Regarding Stored Procedures
In-reply-to: <22b99aa10912072136h15e3ca92gc37e069a7b9e68d1@mail.gmail.com>
Sender: Richard.Hillegas@Sun.COM
To: derby-dev@db.apache.org
Message-id: <4B1E620C.5060200@sun.com>
References: <22b99aa10912072136h15e3ca92gc37e069a7b9e68d1@mail.gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Macintosh/20090812)

Hi Shazin,

This sounds interesting. If you have a prototype that you are ready to 
share, feel free to attach it to a JIRA. It would be helpful if you 
could fill out a Contributor License Agreement, allowing the community 
to use your contribution. See http://www.apache.org/licenses/#clas

Thanks,
-Rick

Shazin Sadakath wrote:
> Hi All,
>
> 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.
>
> Thanks,
> Shazin
>