112 Create JDBC Connection Pool for Oracle in Tomcat Server| Advance Java Servlet Tutorial

preview_player
Показать описание
Procedure to #create #JDBC #Connection #Pool for #Oracle in #Tomcat #Server: Advance Java #Servlet #Tutorial

Step 2) Add (copy and paste) follwing jar files to lib directory of tomcat
C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib

JDBC Driver details to create Connection object:

Pool Parameters:
initialSize="4" maxActive="20" maxIdle="10" minIdle="5" maxWait="100"

Step 4) if server is in running mode, then need to restart the Tomcat server to reflect Connection pool changes.

Procedure to use the above created #Tomcat #server managed #Connection #pool in PoolApp Web application:
Рекомендации по теме
Комментарии
Автор

Super Explanation Kindly Make All Servlet Video

abhi
Автор

Maxactive is not millisec it is the count of threads or connections.

suryapabolu
Автор

Nice article, but I have one question is the same thing possible with xa driver, assuming I am using atomikos as transaction manager.

sachinchandra
Автор

No practical implementation on IDE. Disappointing tutorial. How can we access the tomcat lib folder on a production environment and make such interference in the context.xml ?

srivastavarun
Автор

this would have been a 3 minute video if you knew how to type.

johnnynephrite