Re: Getting 'PRINT' output from Stored Procedures

From: Laurent Marchal (lmarcha..mausa.com)
Date: Thu Feb 04 2010 - 15:29:33 EST

  • Next message: Aristedes Maniatis: "Cayenne RC2 release"

    Yeah that's a good idea ! I'll note that :)
    Thanks

    Laurent.

    Le 04/02/2010 14:27, Evgeny Ryabitskiy a écrit :
    > You could replace PRINT with SELECT, so it will be in ResultSet and
    > will be returned in DataRow.
    > It could be little bit easy then create output parameter, declare
    > variable before exec and do select after in case you are using simple
    > RowQuery.
    > But it will work only for first SELECT. If you put multiple selects in
    > Stored Procedure, Cayenne took first one and drop others....
    >
    > Evgeny.
    >
    >
    > 2010/2/4 Laurent Marchal<lmarcha..mausa.com>:
    >
    >> Unfortunately I did not find any ways to get PRINTed output from SQL server
    >> with JDBC.
    >> The only way seem to return the text as OUT variable.
    >>
    >> Cheers.
    >> Laurent.
    >>
    >> Le 31/01/2010 08:53, Andrus Adamchik a écrit :
    >>
    >>> Unfortunately no idea. SQLServer docs are somewhat cryptic about the PRINT
    >>> function (does it actually print something to the console, or does it return
    >>> a value to the user?). Maybe something to ask on a SQLServer forum,
    >>> formulating it as a JDBC question (how do I get a value of PRINT function
    >>> via JDBC)...
    >>>
    >>> Andrus
    >>>
    >>> On Jan 30, 2010, at 12:55 AM, Laurent Marchal wrote:
    >>>
    >>>
    >>>> Hi all,
    >>>>
    >>>> I'm trying to get the results of the printed text displayed by a stored
    >>>> procedure in SQL Server using the "PRINT" function. The stored procedure do
    >>>> not have any OUT parameters... If I use a ProcedureQuery like this :
    >>>>
    >>>> ProcedureQuery query = new ProcedureQuery("StoreProc");
    >>>> QueryResponse result = context.performGenericQuery(query);
    >>>>
    >>>> the QueryResponse is empty. Is there a way to get the output with Cayenne
    >>>> (3.0) ?
    >>>>
    >>>> Thanks.
    >>>>
    >>>> Laurent Marchal.
    >>>>
    >>>>
    >>>
    >>



    This archive was generated by hypermail 2.0.0 : Thu Feb 04 2010 - 15:30:07 EST