How to call a SELECT-Stored-Procedure with OJB

[ch...@r-it.at]

Hi all,

I have a stored procedure (in a SQL-Server-DB) which selects some data from
a table in another database (also a SQL-Server-DB) on another server (that
is why it has to be a stored procedure). Certainly it can return a vector
of rows.
I already created the repository-file for the table-data the stored
procedure returns and the according class-file.

Is it possible to call such a stored procedure via OJB and - if possible -
how to do this ? I didn't find anything for this case in the How-Tos of
OJB, only a description how to call insert-, update- and/or
delete-procedures.

Thanks in advance for your help.

Best regards

Christine

Re: How to call a SELECT-Stored-Procedure with OJB

[Armin Waibel <ar...@apache.org>]

Hi Christine,

christine.gerstenmayer@r-it.at wrote:
> Hi all,
> 
> I have a stored procedure (in a SQL-Server-DB) which selects some data from
> a table in another database (also a SQL-Server-DB) on another server (that
> is why it has to be a stored procedure). Certainly it can return a vector
> of rows.
> I already created the repository-file for the table-data the stored
> procedure returns and the according class-file.
> 
> Is it possible to call such a stored procedure via OJB and - if possible -
> how to do this ? I didn't find anything for this case in the How-Tos of
> OJB, only a description how to call insert-, update- and/or
> delete-procedures.

In OJB 1.0.x "select-procedures" are not supported. In OJB 1.x it will 
be possible to use select-by-PK-procedures. Think in your case we need 
something like a "named-select-procedure" or more general: support for 
named queries in OJB with procedure support.

regards,
Armin

> 
> Thanks in advance for your help.
> 
> Best regards
> 
> Christine

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org