Re: Complete Derby/JDBC Stored Proc Example ?

[Daniel John Debrunner]

Fisher Associates, Inc. wrote:


Does any one have a complete example showing:

* How to define and utilize a Java Class as a Stored Proc within Derby
* How to test same within ij
* How to call from JDBC

Any help and insights greatly appreciated !


In addition to the resources Rick provided, Derby's wiki has some 
information:


http://wiki.apache.org/db-derby/DerbySQLroutines

Feel free to improve it!

Thanks,
Dan.

Re: Complete Derby/JDBC Stored Proc Example ?

[Rick Hillegas]

Hi Joe,

The information you need can be found in the following sections of the 
Derby Developer's Guide:


o "Loading classes from a database"

o "Derby server-side programming"

In addition, the Scores demo, in the codeline, shows you how to declare 
and invoke Java methods as functions and procedures. That demo lives in 
the codeline under java/demo/scores. If you search that subtree for 
"ScoreTestTaking" you will find examples of how to code, declare, and 
use a Derby procedure.


Hope this helps,
-Rick

Fisher Associates, Inc. wrote:
Fisher Associates, Inc.  
 
Hi Folks,
 
Does any one have a complete example showing:


* How to define and utilize a Java Class as a Stored Proc within
  Derby
* How to test same within ij
* How to call from JDBC

Any help and insights greatly appreciated !
 
Thanks,


*/Joe Fisher/
(800) 840-2335
Fisher Associates, Inc.  *

Fisher Associates is celebrating 12 years of exceptional service to 
our clients

Complete Derby/JDBC Stored Proc Example ?

[Fisher Associates, Inc.]

Fisher Associates, Inc.  
 
Hi Folks,
 
Does any one have a complete example showing:

*   How to define and utilize a Java Class as a Stored Proc within Derby


*   How to test same within ij 

*   How to call from JDBC

Any help and insights greatly appreciated !
 
Thanks,


Joe Fisher
(800) 840-2335
  Fisher Associates, Inc. 



Fisher Associates is celebrating 12 years of exceptional service to our
clients 



atta7f0f.gif
Description: GIF image


atta7f1a.gif
Description: GIF image