Re: procedure using SQL in apache derby possible?
- From: Dyreatnews@xxxxxxx
- Date: Wed, 02 May 2007 10:53:37 +0200
"tony_se" <tonywinslow1986@xxxxxxxxx> writes:
I've only known that we can create a procedure or function in Apache
Derby only in the language of Java, and I think it is not very
convenient for easy and frequent data query tasks. Can anyone tell me
whether it is possible to use SQL language rather than Java in
defining a procedure or function? Thank you!!!
First of all, you'll probably get an answer to such questions much
quicker if you send them to the derby-user mailing list, see
http://db.apache.org/derby/derby_mail.html
The issue of adding support for SQL/PSM was raised on the derby
development mailing list back in 2005.
http://www.nabble.com/SQL-functions%2C-procedures-and-PSM---a-possible-approach-tf379377.html#a1047689
Seems like many people back then felt that it wasn't worth the extra
work and that Java was better language for stored procedures, for a
number of reasons. That said, maybe that view would change if enough
people like yourself were to ask for it...
--
dt
.
- Prev by Date: Re: BOLB in apache derby
- Next by Date: Can I use an array with an IN clause?
- Previous by thread: Re: BOLB in apache derby
- Next by thread: Can I use an array with an IN clause?
- Index(es):
Relevant Pages
|
|
