db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Run Procedure Switch from sqlserver to apache derby !!
Date Thu, 13 Apr 2006 17:34:56 GMT
Derby supports creating procedures/functions using Java. You can
implement a procedure like this using JDBC.

Please see Derby documentation...
Satheesh

Dheeraj Dhiman 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 = @personid ;
>
> But it is not working .
> How could i write this procedure in apache derby !!
>
> Thanks & Regards !!
> Dheeraj  Dhiman !!
>


Mime
View raw message