on 07-17-2006 11:21 AM
hi,
can u pls tell me how to create connection pooling and datasource in WAS
regards
Guru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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>
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>
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>
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.