JDBC Adapter 601 Stored Procedure

Guest · April 3, 2003, 8:26pm

I am trying to execute a MS SQL 2000 stored procedure from the webMethods JDBC adapter. I’ve set up the connection to the database, I’ve created the Adapter Service for the stored procedure.

The catalog name seems to populate with the database, the schema name populates with the user and the procedure name populates with the stored procedure and that is where I am stuck.

Does webMethods not query the procedure to look for the parameters, results sets, and return set fields? Do I have it input those myself? Is anyone out there executing a stored procedure that can give me some help?

Thanks

hugo2 · April 7, 2003, 6:15am

Yep…

You have to input the parameter manually. At least for Oracle I have to set the inputs and output by myself.

Sometimes when you have a lot of field to fill it is boring…

Topic		Replies	Views
JDBC Adapter v602 Introspection on Stored Procedure webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1920	April 2, 2021
Calling a stored prodedure from a JDBC adapter webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	4	1603	April 2, 2021
Autocreation of adapter services via JDBC to SQL 2000 webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1356	April 2, 2021
JDBC adapter and OracleCursor problem webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	9	4975	April 2, 2021
Sql server stored proc returns empty array w/ JDBC adapter webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1779	April 2, 2021

JDBC Adapter 601 Stored Procedure

Related topics