Connection Timeout with SAP Web AS

[Former Member]

Hello,

we are developing a web Dynpro application against SAP Web AS with MaxDB.

Sometimes during testing we seem to loose the connection to the server, i.e. a request times out. The only way to resolve this seems to be to stop and restart the server process.

Also every time this happens we get a NullPointerException in our Java classes because the Connection object becomes null.

We are looking for answers to the following questions:

1) Why does the connection sometimes get lost? Is this behavior known? Are there ways to deal with it?

2) Does the connection pool test whether a connection is still valid before handing it out? Is it possible to influence this via the JDBC settings in the visual administrator?

3) Are the settings for the expiration duration of a connection reset once a connection is returned to the pool?

Thanks for helping out.

Regards,

Jan

[Benny]

>

> Also every time this happens we get a

> NullPointerException in our Java classes because the

> Connection object becomes null.

>

> We are looking for answers to the following

> questions:

>

> 1) Why does the connection sometimes get lost? Is

> this behavior known? Are there ways to deal with it?

I'm not aware of this and it seems to be strange.

>

> 2) Does the connection pool test whether a connection

> is still valid before handing it out? Is it possible

> to influence this via the JDBC settings in the visual

> administrator?

WHAT are you doing there? You're not using JDBC, do you?

>

> 3) Are the settings for the expiration duration of a

> connection reset once a connection is returned to the

> pool?

Wrong path. How do you try to use those connections? What kind of connections are they? How do you access them from WD?

I recommend to go through tutorials immediately!

Regards,

Benny