Need help with C# SOAP Apache Client on Tomcat

Question

Hi,

I am newbie to C# SOAP programming.I have a C# SOAP Apache Client that is calling a java webservice on Apache Tomcat 5.5.9 using SOAP (2.2.3) protocol. 
The webservice works fine when I use a java client to call it. However i do not get a response back 
from the C# client. Can someone help me out with this.

Here is the example that I have been trying to run http://www.c-sharpcorner.com/Code/2002/April/CSSoapApacheClient.asp

The only error that I see is  An exception occurred while trying to create an instance of System.Web.Services.Protocols.SoapHttpClientProtocol. The exception was "WebServiceBindingAttribute is required on proxy classes.". in the design view of the proxy. My source code does have this declaration.

Answer 1

Gaurav,

Would like to understand few things.

Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.

Below link has the sample stored procedure to delete the records (result of search query) from the table.

https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx

Hope it will solve your issue.

Answer 2

Another approach you can take is schedule the deletion of rows during a time when database is not used.

Example during Night.

Then you would not need to implement any extra logic.

But use this, only if deletion can be done later.

Answer 3

CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO

Answer 4

https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes