JDBC Receiver Channel Connection Reset:

[Senthilprakash1]

Dear Team,

I am facing Problem in JDBC Synchronous Receiver Channel.

when ever the JDBC Channel (Synchronous Receiver) is executing i am getting JDBC Conenction reset error in the Channel monitoring.

Why this problem is coming and how to rectify the problem?

In production also we are facing same kind of issue. Please help us find a work around for this Problem.

I have checked the link

[;

but the link which Siv Marani has mentioned in the above forum doesn't exist any more i guess.

Please Advice.

Regards,

Senthilprakash.

Edited by: senthilprakash selvaraj on Jan 28, 2009 4:34 AM

[Senthilprakash1]

Thanks

[Former Member]

Hi,

Check below links.

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

https://www.sdn.sap.com/sdn/collaboration.sdn?contenttype=url&content=https%3A//forums.sdn.sap.com/t...

U need to add the parameter SelectMethod=cursor in your connection parameter,

jdbc:microsoft:sqlserver://<hostname>:1433;DatabaseName=<dbname>;SelectMethod=cursor

Regards,

phani

[Senthilprakash1]

Dear Phani,

I am not able to open the link which you have mentioned. its taking me to SAP Home page.

Please Advice.

Regards,

Senthilprakash.