Connections to MSSQL database

[Former Member]

Hi SDN.

A long time ago some had developed a jspdynpage application on a MSSQL database using a jdbcconnector. Sometimes we get a connection error, and we have to restart the portal. We think that it might be that there are to many open connections.

Is there anywhere that I can see these open connections?

Where do I set up how many connections are allowed?

Our portal is 6.0.2.41

Thanks

Peter

[Former Member]

Hi Peter,

please check SAP Library section <a href="http://help.sap.com/saphelp_nw70/helpdata/en/44/5f977756624cc484811d9dd903dc99/frameset.htm">DataSource Monitoring</a>. There you will find detailed instructions how to monitor free and used connections.

Best regards,

Martin

[Former Member]

Hi Martin.

Thanks for trying to help me.

The J2EE is 6.20, and I think the link you gave me is referring to a newer version. At least I couldn't find what it mentioned.

Do you know for this old J2EE?

Thanks

Peter

[Former Member]

Hi Peter,

check the SAP Library section <a href="http://help.sap.com/saphelp_nw70/helpdata/en/2d/292391fa6745488f3e0e0d4b03c64e/frameset.htm">Managing Connection Pooling</a>. There you will find detailed instructions how to set maximum number of connections.

Best regards,

Martin