Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

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

    Hi George

    Check the following thread,

    JCO Pool Connection - how to determine max_connections?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded