Oracle thin driver

[peter brews]

has any body tried to set connection pool using Oracle thin driver.What should be the setting for classpath,path etc.. to do so.

Thanks a lot
pete

[Marcos Maia]

Hi, you can use the util.dbping utilitary to help you to get it, to do so navigate to %wl_home%\config\%domain_name% using a console window and run the script setEnv.cmd than you can use:

java utils.dbping ORACLE_THIN  USER PASS HOST :-P	 ORT :mrgreen: BNAME

, if everything goes well you can use the sample codes to configure the connection pool.
regards.
[ June 20, 2002: Message edited by: Marcos Maia ]

[yveso]

hi,
1. Add the path to "classes12.zip" (/weblogic/ext/jdbc/classes12.zip) in your WEBLOGICCLASSPATH
2. Add this to your weblogic.properties file
weblogic.jdbc.connectionPool.my_pool_name=\
url=jdbc racle:thin:@my_oracle_server:1521:my_oracle_alias,\
driver=oracle.jdbc.driver.OracleDriver,\
initialCapacity=5,\
maxCapacity=10,\
capacityIncrement=2,\
props=user=my_oracle_user;password=my_oracle_password
weblogic.allow.reserve.weblogic.jdbc.connectionPool.my_pool_name=everyone
weblogic.jdbc.TXDataSource.jdbc.my_pool_name=my_pool_name
3. Restart your weblogic.
Hope it will help you.