Socket Time Out exception in Transaction

[Former Member]

Hi All,

I have created a transaction which consist of sql query to insert data in oracle table.

when i execute this query i get below error

java.net.SocketTimeOutException : Read Time out

I tried increasing the Row count but it didn't work

Please suggest me how to resolve this problem

[Former Member · Accepted solution]

Dear Anjali Thakur,

Please execute through Schedulers.

Regards,

[Former Member · Accepted solution]

Hi Mandapati Nageswara Rao,

Yes i m executing using schedulars still it is giving same error

Regards,

Anjali

[siriyadav0902]

Hi,

Initially try to insert in SQL Query directly. If its successfully inserted, try to keep this transaction in Xacute query and check the log in "Transaction Manager for log"

Regards,

Srisailam