How to configure JCA connection pool

[Former Member]

We are running NW2004s sp10. We are developing a portal application and we what to make use the JCA as recommened by SAP. The application will authenticate to R3 with common user.

According to <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/36b9ac90-0201-0010-8689-ee8405649ce7">this document</a> (page 15) "Connection pooling is handled automatically in EP6 by using the JCA based SAP Connector and the Connection Framework –please do NOT use jcoclient in EP6 for new components".

So EP automatically creates and manages a connection pool for me, but how do I tell it properties like what the user/password to connect with is, what minimum pool size to start with, and the maximum pool size?

[Former Member]

This may help you:

http://help.sap.com/javadocs/NW04S/current/bi/com/sap/ip/bi/sdk/dac/connector/package-summary.html

[Former Member]

Barry,

Thanks for your reply. I don't see anything in this document related to connection pools.

We were finally able to find were to configure the connection pool. From the admin tool (http://<host>:<port>/ then select SAP Netweaver Administrator) select Configuration and then Application Resources. Choose "Connection Factories" in the Show field and then in the list displayed choose the desired connection factory (in my case SAPFactory). In the details view, select the Pooling tab. From here you can set max connections, max time to wait for connection, and connection expiration options (cleanup interval & connection lifetime).

It doesn't allow me to set number of inital connections nor does it provide for specifing a fixed username and password (I can get close to this using a admin user mapping).