How to create DataSource and ConnectionPooling in WAS

[Former Member]

hi,

can u please tell me how to create connectionpool and data source in WAS.pls send me step by step procedure

regards

Guru

[Former Member]

NetWeaver administrator (NWA) is the way to do it.

open http://<host>:<port>/nwa

navigate to

System Management>Configuration>Application Resources

Follow the link

http://help.sap.com/saphelp_nw04/helpdata/en/ab/082484173ae045ab8dad8a41d33da3/content.htm

for data sources.

and

http://help.sap.com/saphelp_nw04/helpdata/en/2d/292391fa6745488f3e0e0d4b03c64e/content.htm

for connection pooling.

<b>Mark helpful answers.</b>

[Former Member]

Hi,

Here is the steps to creat a JNDI lookup using Datasource for MSSQL Server. Follow this and use necessary oracle parameters (in bold) as gives by me in the help link above.

//

Click DataSources in the same path i.e. server > services > JDBC connector

Click “new driver or datasource”.

Enter/ Set the following properties:

Main Tab

DataSource Name : KAAR_DS

Add Alias : KAAR

SRI

Driver Name : KaarSQLDriver

JDBC version :2.0 (with XA support)

<b>Object factory : com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory

DataSource Type : ConnectionPoolDataSource

CPDS classname : com.microsoft.jdbcx.sqlserver.SQLServerDataSource</b>

Additional tab

Add the following properties (key-value):

serverName = localhost

databaseName = KA4

portNumber = 1433

user = CV

password =<password>

Save and restart J2EE. The datasource is now ready to use.

Connection Pooling

Initial connection : 0

Maximum connection : 100

Maximum time to wait for connection : 60

Default connection isolation : DEFAULT

SQL Engine

Select, Vendor SQL

DB Initialization Tab

Add a valid sql statement, and execute. If it is successfully executed, a popup window comes up saying Executing “<sql query>” . OK.

////////

It is done. Now you can use the JNDI look up name in your coding to access the database. Get connection and use the queries to fetch data from db.

Regards,

Srinivasan T

<b>Helpful answer=>points</b>

[Former Member]

hi,

Srinivasan

Thanqq for your response.

my problem is,

Now i am using maxdb for entity beans.i used to create dictionry objects and deploy in WAS . in the sameway i want use sql server for deploying dictionary objects and map persistence field to sql data base tables. for this how to configure netweaver to sql server like maxdb.

pls help me .

regards

Guru

[Former Member]

Hi,

The following link is related to "Mapping Persistent Classes to Database Tables"

http://help.sap.com/saphelp_nw04/helpdata/en/f2/e1ce8b21854d7ca8a74db7cd7d3c62/frameset.htm

Also go thru inner links. Hope this solves your problem.

Regards,

Srinivasan T

<b>Helpful answer=>points</b>