Software Development

How to Configure a JDBC Resource in SAP NetWeaver AS

Background

[wp_ad_camp_1]

SAP NetWeaver AS, like other Application Servers for Java, has a facility to configure JDBC resources that can be used by Web Dynpro for Java applications running within it

Turreta.com recommends using the latest available version of the product.

Hardware Environment

n/a

Software Environment

  • Windows 7 Professional SP1
  • Microsoft IE 11
  • SAP NetWeaver Application Server
    • ​sap.com/SAP-JEECOR  – 7.00 SP26 (1000.7.00.26.1.20120307143343)
    • sap.com/SAP-JEE – 7.00 SP26 (1000.7.00.26.0.20120109175405)

Configure JDBC Resource

[wp_ad_camp_2]

1. Log in to SAP NetWeaver AS (https://<host_name>:<port>/nwa)

01-sap_netweaver_admin_jdbc_resource_001_wm

2. Go to Configuration

02-sap_netweaver_admin_jdbc_resource_002_wm

3. Go to Application Resources

03-sap_netweaver_admin_jdbc_resource_003_wm

4. On the Show filter, choose “JDBC Data Services”

04-sap_netweaver_admin_jdbc_resource_004_wm

5. Choose MyDataSource

05-sap_netweaver_admin_jdbc_resource_005_wm

 6. Choose the Connectivity tab to change the JDBC resource connectivity
06-sap_netweaver_admin_jdbc_resource_006_wm
7. Choose the Connection Pooling to modify pool-related settings
07-sap_netweaver_admin_jdbc_resource_007_wm
8. Choose the Aliases tab
08-sap_netweaver_admin_jdbc_resource_008_wm
9. Choose the Properties tab to see database user/pass, and connection string
09-sap_netweaver_admin_jdbc_resource_009_wm
 [wp_ad_camp_3]

351 total views , 1 views today

Got comments or suggestions? We disabled the comments on this site to fight off spammers, but you can still contact us via our Facebook page!.


You Might Also Like