db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Question concerning stored procedures
Date Thu, 03 Dec 2009 13:41:53 GMT
Hi Oliver,

Here is an old email thread on this topic: 
http://old.nabble.com/SQL-functions%2C-procedures-and-PSM---a-possible-approach-to1047689.html#a1047689

I think that the short answer to your question is that no-one has 
volunteered to implement the standard SQL procedural language. There is 
very little pressure to start this very big project because the 
alternative Derby approach (writing a Java static method) seems to 
satisfy our users.

Personally, I believe that Java is a better procedural language than SQL 
for several reasons: Java is more expressive, more portable, easier to 
debug, and backed by a larger ecosystem of re-usable code.

However, you are welcome to build SQL/PSM support into Derby. I believe 
that the community would welcome such a contribution.

Hope this helps,
-Rick



Oliver Böhme wrote:
> Hello,
>
> why can't I create "normal" SQL stored procedures for a Derby DB?
> I thought building a string like "create procedure name as select * from ..." and pass
it to Statement.execute (or .executeUpdate) would work but it doesn't.
> Instead of this I can only declare those cryptic java stored procedures...
>
> Am I missing some point or what is the reason for that?
>
> Regards
> ___________________________________________________________
> Preisknaller: WEB.DE DSL Flatrate für nur 16,99 Euro/mtl.! 
> http://produkte.web.de/go/02/
>
>   


Mime
View raw message