Sorry I can't reply to the same thread. I rely on the archives as the traffic is too high for me to stay subscribed. This is in reply to: http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=101423330019994&w=2
I use the JDBC escape syntax as Christian Haul suggested in his reply, but I also had to modify SQLTransformer.java to handle the ResultSets returned by SQL Server stored procedures. I've tried to make it handle multiple returned ResultSets, but can't test with more than one because my MS JDBC driver only handles the first one then says there are no more. SQLTransformer.java only handled ResultSets as OUT parameters (as used by Oracle, Postgres etc.) not those returned implicitly as by SQL Server. I posted the patch to cocoon-users on 2002-02-08 This might take you there: http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=101316887401395&w=2 Please share any improvements you may have. Cheers, Neil. Subject: Calling MS SQL stored procedure From: "Miller, Grant" <[EMAIL PROTECTED]> Date: 2002-02-20 15:45:47 Hi, I'm having a problem calling an ms sql server stored procedure with the sql transformer (using cocoon 2.0.1 and tomcat 4). The code is: <sql:execute-query> <sql:query isstoredprocedure="true" name="testformike"> begin dbo.testformike('hi'); end; </sql:query> </sql:execute-query> The error message is: Invalid call syntax: begin dbo.testformike('hi'); end; I always get this with isstoredprocedure="true". Also, I'm not sure what the qualifier before the function name should be (dbo is the owner in this example). Another thing we have tried is: This query: <sql:execute-query> <sql:query> exec DBO.TESTFORMIKE 'hi' </sql:query> </sql:execute-query> but this gives: A server cursor is not allowed on a remote stored procedure or stored procedure with more than one SELECT statement. Use a default result set or client cursor We are completely stuck and do not want to use esql. Thanks for any help, Grant Miller --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
