How to setup and use connection pool in Web AS 7.0?

[former_member186148]

Hello SDN!

I'm developing a Web Dynpro Java application on SAP Web AS 7.0 My app using a couple of DAO classes as model instead of EJBs. These classes perform direct requests to database using JDBC drivers.

I've read that many of web-servers use their own connection pools. So I want to know:

1) how I can setup connection pool in SAP Web AS ?

2) how I can call this pool in my application?

Could you please give me some examples?

Regards, Lev.

[Former Member · Accepted solution]

hi Lev,

I guess this blog will be useful for you.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00b895cb-7148-2c10-e599-81501451f7e8

Regards,

Vivek Nidhi

[former_member186148]

Information about connection pool settings for Web AS 7.0 can be found at http://help.sap.com/saphelp_nw70/helpdata/en/2d/292391fa6745488f3e0e0d4b03c64e/frameset.htm

[ravindra_bollapalli2]

hi lev,

check this document for jco pools

http://www.winfobase.de/lehre/lv_materialien.nsf/intern01/FB09D79A41930E34C125709F0046180C/$FILE/Tip...

ravindra

[former_member186148]

Hi!

As I know JCo used for calling functional modules from SAP systems, but I'm working with Oracle so I can't use JCo.