cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evgeny Ryabitskiy <>
Subject Re: Getting 'PRINT' output from Stored Procedures
Date Thu, 04 Feb 2010 20:27:15 GMT
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
But it will work only for first SELECT. If you put multiple selects in
Stored Procedure, Cayenne took first one and drop others....


2010/2/4 Laurent Marchal <>:
> 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.

View raw message