cancel
Showing results for 
Search instead for 
Did you mean: 

How to create datasource and connection pooling in WAS

Former Member
0 Kudos

hi,

can u pls tell me how to create connection pooling and datasource in WAS

regards

Guru

Accepted Solutions (0)

Answers (1)

Answers (1)

suresh_krishnamoorthy
Active Contributor
0 Kudos

Hi Guru

Go to this thread

Regards

Suresh

suresh_krishnamoorthy
Active Contributor
0 Kudos

Hi Guru,

Go 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.

Regards

Suresh

Former Member
0 Kudos

hi,

can i configure oracle data base with WAS .if it possible pls tell me the way

regards

Guru

Former Member
0 Kudos

Hi,

You can configure oracle with WAS by creating a Driver followed by Datasource in the Visual Administrator->JDBC Connector Service.

Enter the configuration parameters as per the help doc,

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

If you need any other help, do revert.

Srinivasan T

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

Former Member
0 Kudos

hi,

Srinivasan

i have mysql data base ,how to configure and how to use that data base in my entity bean programms.pls tell me

regards

Guru

Former Member
0 Kudos

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
0 Kudos

hi,

Srinivasan

i am using maxdb for entity persistence.but now i want use mysql database for entity persistence. how to configure mysql to netweaver like maxdb. that means i can map persistence fields to mysql database tables. pls help me to do this.

regards

Guru

Former Member
0 Kudos

Hi,

The following help link is on 'Mapping Persistent Classes to DB Tables'.

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

May be helpful.

Srinivasan T

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