cocoon + MS SQL Server Stored Procedure

["Haas, Holger" <Ho...@CommerzbankIB.com>]

> 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:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>