RE: MS SQL Server Stored Procedure and WebObjects
RE: MS SQL Server Stored Procedure and WebObjects
- Subject: RE: MS SQL Server Stored Procedure and WebObjects
- From: Rünagel, Frank (Telebuch) <email@hidden>
- Date: Wed, 3 Jan 2007 15:11:46 +0100
- Thread-topic: MS SQL Server Stored Procedure and WebObjects
you have to include
set nocount on
at the beginning of your stored procedure.
We heavily use stored procedures with Java/WO and
SQL-Server. I would recommend to call them
directly as a SQL-Query-String and not use the EO-Modeler wrapper.
I can remember various problems with this in the
past.
We also do not use the "rawRowsForSQL"-Method to call the
"exec foo"-SQL. We use a separate pooled connection.
> -----Original Message-----
> From: webobjects-dev-bounces+webobjects=email@hidden
> [mailto:webobjects-dev-bounces+webobjects=symposion.de@lists.a
> pple.com]O
> n Behalf Of Ute Hoffmann
> Sent: Wednesday, January 03, 2007 1:14 PM
> To: email@hidden
> Subject: MS SQL Server Stored Procedure and WebObjects
>
>
> Hallo,
> after looking through numerous WebPages via google I have a simple
> question:
>
> Is there somebody around who has managed to get
> values/result-sets from
> a stored procedure into WebObjects?
>
> I either get null as return or a error message telling me I
> have to use
> a client Cursor or a resut set. But I cannot seem to get at a result
> set or find a how to how to configure a result set correctly
> to be seen
> in WebObjects:-(. I cannot see how to get even a single value
> passed on
> correctly.
>
> So, is there someone around who cann give a simple how to? I
> have read
> the monitor guide and followed the steps there but all how
> tos I found
> in the web either stop where I would need an answer or do not include
> what I look for.
>
> I suppose what I overlook is very very simple.
>
> Thanks,
>
> Ute
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> email@hidden
>
> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden