Io exception: Connection reset

[former_member182416]

Hi

I have created a webdynpro java applciation connected to Custom Oracle Database.

for this in Visual Admin ,in the JDBC Connector Service , i have created DataSource.

Details:

Driver Name: SYSTEM_DRIVER

JDBC Version 1.x

Driver Class: oracle.jdbc.driver.OracleDriver

The Connection works fine.

But after some time has elapsed it throws errors.

java.sql.SQLException: Io exception: Connection reset

java.sql.SQLException: Closed Connection

if i login to visual admin and test the connection,in first attempt it fails but in second attemp it succeeds.

and then it works fine for siome time.

and again same problem appears.

my Portal Server is EP7 sp18.

and Custom Oracle Database is 9i.

what can be the reason?

Regards

Rajendra

[Former Member · Accepted solution]

Hi,

Reason could be session time out, i mean connection object session expires for a period of time if your system is ideal,

when you invoke the first time it checks the Connection Sessions, if Connection object session expires it throws error and when you trying to invoke second time it creates another connection object

Thanks,

Sreeni.

[former_member182416 · Accepted solution]

well, if that is the case then what is the solution?

Any specific settings in the DataSource in Visual Admin for JDBC Connector service ?

Regards

Rajendra

[Former Member · Accepted solution]

You need to session expire settings with Webdynpro application, i mean to say session expire time to 30 min,

if the system is idel for 30 mins then you need to relogin to webdynpro application once again, then new connection object will create and it serve for your app

Thanks,

Sreeni.

[former_member182416 · Accepted solution]

Setting the Connection Expiration Properties in DataSource solved the Problem.

Cheers!

Regards

Rajendra