Problem with SQLException: IO Exception : Connection Time Out

[Former Member]

Hello,

I am try to connect a database Oracle 10g using the Receiver JDBC adapter.

I am getting the exception like,

JDBC API method executeQuery threw an exception: java.sql.SQLException: Io exception: Connection timed out#

Can any one help me out in solving this issue?

Is the issue related to Reveiver JDBC side or it is with DB side?

Thanks,

Soorya

[Former Member · Accepted solution]

Hi,

Check this for Timed out Errors

/people/michal.krawczyk2/blog/2006/06/08/xi-timeouts-timeouts-timeouts

Regards

Seshagiri

[Former Member]

Hi,

In your Receiver JDBC adapter there is an option Disconnect From Database After Processing Each Message.

Select this option and you will not face the issue further.

If this will not solve your problem then follow below things

please refer below discussion and try to follow those settings to aviod the time out

set parameters

- make sure the parameter resource_limit = false in

init<sid>.ora , in order to switch off the idle time limit. Afterwards restart the

database. OR

- if you want to set resource_limit = true, then set IDLE_TIME = unlimited

Thanks

Swarup

[Former Member]

HEllo,

I have Selected this option ,

"Disconnect From Database After Processing Each Message".

Its solved my issue.

But as per the option in the notes says that it has some impact on performance when we try to send large messages.

Can you please explain on this option and please tell me what shud i do when i still get the problem while trying with larger messages?

Thanks,

Soorya

[Former Member]

Hello,

Can you please help me on this issue?

its solved my problem like marking that DB disconnect after process of each message.

but i want to know what is reason behind and how it got solved.

It is ok if i rely on tat option as it has some performance issues whn i try to send larger messages.

Please reply ASAP.

Thanks,

Soorya.

[Former Member]

Hi Surya,

First check whether external database is running. If it is running then check whether port is open for that database server.

-Pinkle

[prateek]

1. Please provide ur connection url. There might b some error in it.

2. Is there firewall between XI and the receiver system. If yes, recheck if the ports are open.

Is the issue related to Reveiver JDBC side or it is with DB side

I think both means the same. The issue is related of connection of XI to the database system

Regards,

Prateek

[Former Member]

Hello,

URL : jdbc:oracle:thin:@abcd:1521:DBTEST

jdbcDriver : oracle.jdbc.driver.OracleDriver

I wans to ask whether the issue is from DB side that means is there any timoue problem at DB level which is to be set or is it in th configuration of Receiver JDBC Commuication channel.

Thanks,

Soorya.