Hi I'm working with cocoon2 and trying to access MSSQL stored procedures and having not so much luck. I tried The SQLTransformer which works great with queries, but stored procedures return nothing. Looking around the archives this appears to be the SQLTransformer doesn't expect result sets from Stored Procedures and should just be out parameters. And there is a patch even for a really old version of SQLTransformer.java.
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=101316887401395&w=2 So from what I had read it seems people should use esql, so I tried the esql logicsheet, and more specifically I tried it with the j-netdirect JSQLConnect jdbc driver and the MS jdbc driver (beta2). Now with esql I can get ouput from stored procedures just fine, but when having to supply parameters the ms jdbc driver gives org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing prepared statement: usp_Report_CustomerReport(?): java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'usp_Report_CustomerReport'. But if I change the datasource to the JSQLConnect driver, it works fine until the second to last row (there is about 1600 rows returned) and then I get a NullPointerException. Not trying other stored procedures , I get mixed results, or none where there should be some has anyone had any luck with mssql stored procedures (that return resultsets) and cocoon2 ? Any input would be appreciated. Thanks. Darrell. --------------------------------------------------------------------- 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]>
