Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of m.v.lunteren@gmail.com
 designates 64.233.166.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=lnVGIWT7HLyP0nDw0ANOOIo5EJzicZMrEnu9xNBnXFY0ZmLJX3Mk83oz+wi7YqGD7ZDCyrU5MGC9kZiiWnqFsvAqLor/3yc2dvx5JjRWBTEIvVj4NlPXLNXPSKNqGkh6bpTX7fHtQZEwSPazpXReuN6WVzUXcUG/W6K+8jlKtcc=
Message-ID: <c25576af0604130717s7aed20ck1128ed575e663216@mail.gmail.com>
Date: Thu, 13 Apr 2006 07:17:55 -0700
From: "Myrna van Lunteren" <m.v.lunteren@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Run Procedure Switch from sqlserver to apache derby !!
In-Reply-To: <416061d0604122238p2882e67need038d25b8d41ec@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_21537_29210992.1144937875738"
References: <416061d0604122238p2882e67need038d25b8d41ec@mail.gmail.com>

------=_Part_21537_29210992.1144937875738
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 4/12/06, Dheeraj Dhiman <dheeraj.dhiman@gmail.com> wrote:
>
>  Hello !!
> I want to switch from sql server to  apache Derby for my project .
> I wanna run a procedure like this in apache derby .
>
> create procedure testProcedure( @personid Integer )
> as
> select fullName , fatherName, age, income, grosssalary from persons where
> personid =3D @personid ;
>
> But it is not working .
> How could i write this procedure in apache derby !!
>
> Thanks & Regards !!
> Dheeraj  Dhiman !!
>

Hi !! Dheeraj !! Dhiman !!

Derby does not currently support sql procedures or functions.

You can write a java function to do what you want, see for instance our
manuals, (see the Documentation tab off the main Derby page.), the
Frequently Asked Questions (
For instance: http://db.apache.org/derby/faq.html#null_args
which points to:
http://mail-archives.apache.org/mod_mbox/db-derby-user/200602.mbox/%3c4404E=
53D.1050605@apache.org%3e
)

Finally, you can search through the derby archives, for instance using
nabble, for examples of issues others have brought up in this area.

Finally, please stop logging jira issues for questions, and please, please
stop the annoying exclamation marks.

Seeing you log a JIRA issue, and seeig those exclamation marks certainly
made me less interested to answer your question, rather than more, so you'r=
e
achieving the opposite from what I assume you want to.

Myrna

------=_Part_21537_29210992.1144937875738
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><span class=3D"gmail_quote">On 4/12/06, <b class=3D"gmail_sendername">=
Dheeraj Dhiman</b> &lt;<a href=3D"mailto:dheeraj.dhiman@gmail.com">dheeraj.=
dhiman@gmail.com</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div style=3D"DIRECTION: ltr">
<p>Hello !!<br>I want to switch from sql server to&nbsp; apache Derby for m=
y project .<br>I wanna run a procedure like this in apache derby . </p>
<p>create procedure testProcedure( @personid Integer ) <br>as<br>select ful=
lName , fatherName, age, income, grosssalary from persons where personid =
=3D @personid ;</p>
<p>But it is not working . <br>How could i write this procedure in apache d=
erby !!</p>
<p>Thanks &amp; Regards !!<br>Dheeraj&nbsp; Dhiman !!</p></div></blockquote=
></div>
<div><br>Hi !! Dheeraj !! Dhiman !!</div>
<div>&nbsp;</div>
<div>Derby does not currently support sql procedures or functions.</div>
<div>&nbsp;</div>
<div>You can write a java function to do what you want, see for instance ou=
r manuals,&nbsp;(see the&nbsp;Documentation tab off the main Derby page.), =
the Frequently Asked Questions (</div>
<div>For instance: <a href=3D"http://db.apache.org/derby/faq.html#null_args=
">http://db.apache.org/derby/faq.html#null_args</a></div>
<div>which points to:</div>
<div><a href=3D"http://mail-archives.apache.org/mod_mbox/db-derby-user/2006=
02.mbox/%3c4404E53D.1050605@apache.org%3e">http://mail-archives.apache.org/=
mod_mbox/db-derby-user/200602.mbox/%3c4404E53D.1050605@apache.org%3e</a>
)</div>
<div>&nbsp;</div>
<div>Finally,&nbsp;you can search through the derby archives, for instance =
using nabble, for examples of issues others have brought up in this area.</=
div>
<div>&nbsp;</div>
<div>Finally, please stop logging jira issues for questions,&nbsp;and pleas=
e, please stop the annoying exclamation marks. </div>
<div>&nbsp;</div>
<div>Seeing you log a JIRA issue, and seeig those exclamation marks&nbsp;ce=
rtainly made me less interested to answer your question, rather than more, =
so you're achieving the opposite from what I assume you want to.</div>
<div>&nbsp;</div>
<div>Myrna</div>

------=_Part_21537_29210992.1144937875738--