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 - 12:14:23 EST