Database Connection Lost Error

[Former Member]

Hi,

MyScenario is :

We send a query to database A collect resultset in java mapping and transform it to three more Select queries and send them to Database B So two chanels are there:

Sender JDBC channel, Receiver JDBC Channel.

Now the Output of Database B is converted to IDOC and sent to R/3 System.

This is working fine, but sometime it stuck at Database B saying error "connection Lost". And works fine afterwards.But in that case we miss the records which could not be processed.

What can be the reason for this ? Please suggest the solution at teh earliest. Can overloading be the reason for losing connection. Please suggest...

Thanks & Regards,

Priyanka

[Former Member]

Hi,

Please help me in resolving this issue or any solution you have in mind. It is not working even after checking, Disconnect Database after message Processing.

Please tell if there is any other way out.

Thanks

Priyanka

[sunil_singh13]

Hi Priyanka,

You have to close the connection afte accessing the JDBC "A".

So that it could be accesed by others.

Try to implement the suggetion given by sarvesh.

If it still does not work then i would say you go for JDBC look ups.

It will improve the performance as well.

Thanks

Sunil Singh

[Former Member]

Hi,

In Rec JDBC CC under Advanced Mode have you checked the check box "Diconnect from Database After Processing Each Message"? Select this and then try.

[former_member238007]

priyanka,

what is the amount of data it is returning from B database.. basically jdbc can handle more data, but u need to write stored procedures for that,,

regards

Kishore