Skip to Content
author's profile photo Former Member
Former Member

Portal dies when connection to mssql fails

Can anyone help us?

We have an nw2004s portal and a mssql 2000 server containing some data. We have a couple of webdynpro's which get some data from mssql when they are called in an iview. The portal connects through jdbc with the mssql server. We are using dataservices and get the connection via jndi lookup. We are using connection pooling on Microsoft's driver.

We have made these settings in the datasource;

logintimeout: 2

initial connections: 4

maximum connections: 30

maximum time to wait for connection: 2

expiration: unchecked

sql engine: vendor sql.

We are trying to get the portal to gracefully degradate when the connection to this server is lost (pull the plug). What happens now is that it takes a really long time for the portal to find out that there is no more connection and everything comes to a grinding halt. When trying to stop the datasource, the visual admin hangs.

we are astounded that failure of the connection causes such a horrid application hang. Our question is: can we somehow fix this so that our portal resource manager quits after a predefined number of seconds (30 for instance).

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 01:50 PM

    Hi Arie,

    did you solve this issue? I have the same problem now.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.