cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laurent Marchal <lmarc...@smausa.com>
Subject Re: Getting 'PRINT' output from Stored Procedures
Date Thu, 04 Feb 2010 20:29:33 GMT
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<lmarchal@smausa.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.
>>>>
>>>>          
>>>        
>>      

Mime
View raw message