> Hi! > > How can I execute Stored Procedures (SP) of a MS SQL Database > by the use of the COCOON SQL-Transformer? > > My Environment: > JAVA-Version: j2sdk1.4.0_01 > JDBC-Driver: jtds-0.4.jar > Database: MS SQL Server 7.0 > and Cocoon 2.0.4 > > My Cocoon configuration: > > SiteMap: > <map:match pattern="sql-page.xml"> > <map:generate src="sql-page.xml"/> > <map:transform type="sql"> > <map:parameter name="use-connection" > value="DatabaseServer"/> > </map:transform> > <map:serialize type="xml"/> > </map:match> > > cocoon.xconf: > <jdbc name="DatabaseServer"> > <pool-controller min="5" max="10"/> > <dburl>jdbc:jtds:sqlserver://Databaseserver/DatabaseName</dburl> > <user>Username</user> > <password>Password</password> > </jdbc> > > Input-file "sql-page.xml": > <document> > <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <sql:use-connection>DatabaseServer</sql:use-connection> > <sql:query isstoredprocedure="true"> > StoredProcedureName > </sql:query> > </sql:execute-query> > </document> > > Problem: > > I'm able to launch all kinds of SQL-Statements successfully, > however I don't get any result out of launched Stored Procedures with or > without > in or output parameters! > I couldn't find any example for the use of a MS SQL Database. > > Thanks in advance, > Holger Haas >
--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
