You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cocoon.apache.org by bu...@apache.org on 2004/08/27 15:28:19 UTC

DO NOT REPLY [Bug 30894] New: - SQLTransformer doesn't support SPs that return a result set

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30894>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30894

SQLTransformer doesn't support SPs that return a result set

           Summary: SQLTransformer doesn't support SPs that return a result
                    set
           Product: Cocoon 2
           Version: 2.1.5
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: blocks
        AssignedTo: dev@cocoon.apache.org
        ReportedBy: ats37@hotmail.com


I'm using the SQLTransformer to call a Sybase stored procedure that returns a
result set; I'm not using any output parameters.  However, when I get the
results back from transformer, all it contains is

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01
Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<accountdetails>
		<rowset xmlns="http://apache.org/cocoon/SQL/2.0"/>
</accountdetails>
</page>

Looking through Query.serializeStoredProcedure(ServiceManager manager)
(SQLTransformer.java lines 1271-1323), it seems to me that when
isstoredprocedure="true" it only handles output that is returned in
outParameters.  Any result sets are not processed, other than those which happen
to be returned in an output parameter (which Oracle obviously supports, judging
by the SQLTransformer documentation, but I don't know if any other DBMSs do).