How we use connectionpool facility of weblogic server..

Hi himanshu1979,

Here iam giving you two alternative solution for connection pooling while using jsp

Here you can do this way:

1)

weblogic.allow.execute.weblogic.servlet.classes=everyone

#

# Servlet reload properties

# weblogic.httpd.servlet.classpath=/freetaxprep/classes

weblogic.httpd.servlet.reloadCheckSecs=-1

#

# File servlet registration

weblogic.httpd.register.file=weblogic.servlet.FileServlet

weblogic.httpd.initArgs.file=defaultFilename=index.html

#

# ServerSideInclude servlet registration

weblogic.httpd.register.*.shtml=weblogic.servlet.ServerSideIncludeServlet

#

# Default servlet registration

weblogic.httpd.defaultServlet=file

#

weblogic.system.listenPort=1080

weblogic.security.ssl.enable=false

#weblogic.system.SSLListenPort=6643

weblogic.httpd.documentRoot=/freetaxprep/products/

#

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

# WEBLOGIC JSP PROPERTIES

weblogic.httpd.register.*.jsp=\

weblogic.servlet.JSPServlet

weblogic.httpd.initArgs.*.jsp=\

pageCheckSeconds=1,\

compileCommand=/opt/Solaris_JDK_1.2.2_05a/bin/javac,\

workingDir=/weblogic/ftp/compiled_jsp,\

verbose=true,\

keepgenerated=true

#

weblogic.jdbc.connectionPool.oraclePool=\

url=jdbc:weblogic:oracle,\

driver=weblogic.jdbc.oci.Driver,\

loginDelaySecs=0,\

initialCapacity=10,\

maxCapacity=100,\

capacityIncrement=5,\

allowShrinking=true,\

shrinkPeriodMins=10,\

refreshMinutes=10,\

props=user=TAX2000;password=xxxxxxxx;server=TAX

# Set up ACLs for this connection pool with the following:

weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=everyone

weblogic.allow.reset.weblogic.jdbc.connectionPool.oraclePool=everyone

weblogic.allow.shrink.weblogic.jdbc.connectionPool.oraclePool=everyone

2)While using the DBConnectionBroker, it will work

http://www.javaexchange.com

I hope this will help you out.

Regards,

Tirumalarao

Developer TechnicalSupport,

Sun MicroSystem,India.

rao_indts at 2007-6-29 0:42:49 >