cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Stored Procedure For Web Service in Visual Composer 7.1

Former Member

on ‎07-01-2008 8:56 AM

0 Kudos

Hello,

I want to use stored procedure for Webservice in Visual Composer 7.1

I can find this Web service but not supported. ( ex) prcreleased_test - Not supported )

Log.

Message: Error in connection - Can' t execute Web service.

Date: 2008-07-01

Time: 16:41:43:906

Category: com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent

Location: com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.processExecution:

Application: sap.com/test~kmshim_wf_impl

Thread: HTTP Worker [1]

Data Source: j2ee\cluster\server0\log\defaultTrace_00.trc

Correlator ID: 240496500000034715

Argument Objects:

Arguments:

DSR Component: n.a.

DSR Transaction: cb4b3560473711dd9fb4001e4f3b8fcb

Log2

Message: Stopped further execution since the interpreter is unusable

Date: 2008-07-01

Time: 16:41:43:906

Category: com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent

Location: com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.XGLInterpreter

Application: sap.com/test~kmshim_wf_impl

Thread: HTTP Worker [1]

Data Source: j2ee\cluster\server0\log\defaultTrace_00.trc

Correlator ID: 240496500000034715

Argument Objects:

Arguments:

DSR Component: n.a.

DSR Transaction: cb4b3560473711dd9fb4001e4f3b8fcb '

Help me^^ plz..

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎07-01-2008 12:54 PM
0 Kudos

Hi Kang,

JDBC is not supported in VC 7.1. You would have to create the web service, that access your stored procedure in that way, you would able to use it.

Should you have any further queries, just feel free to ask.

Best regards,

Dharmi

Show replies
Show replies
Former Member
‎07-02-2008 4:04 AM
0 Kudos

Hi Tanna.

Thanks for your reply^^

I create webservice that access my stored procedure.

But not supported.

http://dmp.humaxdigital.com/HumaxCmdwService/Service1.asmx?wsdl

There are two service. (Hello World - Test, prcrelease_test - Stored Procedure )

'Hello World' is supported but prcrelease_test is not supported. I can't drag to storyboard.

Our company's DB is MSSQL2005.

please help me^^

Former Member
‎07-02-2008 5:41 AM
0 Kudos

Hi Kang,

Can you tell me, on what platform or using which tool have you created your webservice? e.g:

1. Did you expose your stored procedure directly from MS SQL as web service?

2. Did you create it using NWDS or .NET or something else?

Also, did you try to test prcrelease_test with other Web Service testing tools [Strike Iron|http://www.strikeiron.com/tools/tools_analyzer_windows.aspx]?

Best regards,

Dharmi

p.s. I created a Web service from the stored procedure (MS SQL 2005), using NWDS and it works perfectly fine with VC.

Former Member
‎07-02-2008 7:58 AM
0 Kudos

Hi Tanna.

Thanks for your reply.

1. Yes I expose my stored procedure MSSQL2005.

2. I use .NET to create web service

And I tested webservice (prcreleased_test) in strikeIron, result is displayed.

p.s. How to create web service for stored procedure in NWDS?

help me^^

Former Member
‎07-02-2008 11:33 AM
0 Kudos

Hi Kang,

[Here is the link on How to create WS for stored procedures in NWDS.|https://wiki.sdn.sap.com/wiki/x/FYDzAQ ]

Good luck,

Dharmi

Former Member
‎07-02-2008 1:11 PM
0 Kudos

Thank you! Tanna^^

I will try to create Web service for stored procedure.

If I will success, send mail for you. ^^

Ask a Question