JDBC Aadptor problems with high volume data

[swatantra_vijay3]

Hi ,

We are implementing Oracle DB to SAP integration using XI for high volume of data , I want to know what kind problem can come with JDBC adaptor. Can anyone share his/her experience with this kind of integration

Thanks in advance

Regards

Vijay

[bhavesh_kantilal]

1. If the Datbase is going to be brought down once a while manually for maintenance etc, the Sender JDBC adapter will error out as the connection would be terminated from the Database side.

If this is going to happen then in the JDBC adapter ,select Advaced Mode --> Disconnect From DB after Each message processing.

Ifthe DB is always going to be On, then no need to do this.

2. Try to selectively restrcit the number of rows selected by the select queryt every polling interval to make sure that the size of the payload is not huge.

Regards

Bhavesh