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

How to size a JCo Connection Pool

We are about to go live with a custom developed employee self-service site. All of the SAP connectivity was developed using the JCo and the site could run on just about any web server.

We've used JCo for background agent processing connecting directly to SAP, but for this we will be using connection pooling.

Does anybody have any advice on figuring the max number of connections to allow in the pool?

We have about 1100 employees - all in the US. More than 900 of them are in the same time zone. I can imagine a scenario where just about all of those people could hit the site in a three or four hour window.

Thanks in advance for the help.

- George

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2005 at 11:04 PM

    Hi George

    Check the following thread,

    JCO Pool Connection - how to determine max_connections?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2005 at 11:22 AM

    Hi George,

    The classes JCO.Pool and JCO.PoolManager will help you to size the Connection Pools.

    Using JCO.addClientPool(<Pool_Name>,<Max_Connection>,<Logon_Properties>); will do the trick. Refer the JCo tutorial (that comes with jar file) for more information.

    Hope this solve your problem. Please let me know if this did not solve your problem.

    Thanks

    Kathirvel.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2005 at 08:57 PM

    Hi,

    The following document talks about best practices on maintaining the JCO destinations. You can use those same principles to define the parameters for your custom JCO connections.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/webdynpro/how to configure the jco destination settings.pdf

    Thanks & Regards,

    Renjith

    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.