Importance of JDBC pooling in JDBC conn

[harishnamdeo]

what is the importance of JDBC POOLS befor configure a jdbc conn in webMethods and how can i configure jdbc pools . pls … any thought.

I am using following
Operating system - Windows XP SP-2
Databse - Oracle 9i (version-9.0.1.0.0)
JVM version - 1.4
driverType -thin

extra:- I have already copied ojdbc14.jar file into
1. C:\Program Files\webMethods61\IntegrationServer\lib\jars\ojdbc14.jar
2. C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.zip

MYJDBC:MYCON Details
Connection _____________JDBC Adapter Connection
Package________________NEWORACLE

Connection Properties
Transaction Type ________NO_TRANSACTION
DataSource Class ________oracle.jdbc.pool.OracleConnectionPoolDataSource
serverName _____________localhost5555
user ___________________system
password _______________******
databaseName __________WMDB
portNumber _____________1433
networkProtocol _________tcp
Other Properties _________driverType=thin

Connection Management Properties
Enable Connection Pooling __true
Minimum Pool Size ________1
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

And last whwn i goes to enable the connection than i find following error

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MYJDBC:MYCON.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.Io exception: The Network Adapter could not establish the connection

Plz help me out from this problem plz …thanx

[sekay]

Double check your server name. localhost5555 doesn’t seem to be right. Try localhost.

Connection pooling

@http://www.webopedia.com/TERM/C/connection_pool.html

A cache of database connections maintained in the database’s memory so that the connections can be reused when the database receives future requests for data.

Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a database connection for each user, especially requests made to a dynamic database-driven Web application, is costly and wastes resources. In connection pooling, after a connection is created, it is placed in the pool and it is used over again so that a new connection does not have to be established. If all the connections are being used, a new connection is made and is added to the pool. Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database.

You have already configured a Connection pool in the Connection Management Properties Section.