Hi Christine,
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
