How To Setup Jndi Database Connector Puddle Inward Tomcat - Boundary Tutorial Example

Setting the JNDI Database Connection puddle inwards Spring together with Tomcat is pretty easy. Tomcat server documentation gives plenty information on how to setup connexion puddle inwards Tomcat 5, half dozen or 7. Here nosotros volition work Tomcat vii along alongside jump framework for creating a connexion puddle inwards Tomcat server together with accessing them inwards Spring using JNDI code. In our concluding article, nosotros accept seen how to setup database connexion puddle inwards Spring for heart Java application which doesn't run on a spider web server or application server together with doesn't accept managed J2EE container. but if you lot are developing a spider web application than its meliorate to work server managed connexion pool together with access them using JNDI. Spring configuration volition live on generic together with exactly based on JNDI cite of Datasource thence it volition run on whatever J2EE Server e.g. Glassfish, WebLogic, JBoss or WebSphere until JNDI cite is same. 

Btw, Tomcat is my favorite web server together with I work it a lot on evolution every bit it comes integrated alongside IDE similar Eclipse together with Netbeans. I am using it for all examination together with evolution purpose, together with many companies fifty-fifty run Tomcat inwards Production for hosting Java spider web application. 

It's simple, fast together with rattling robust, though beware alongside java.lang.OutOfMemoryError: PermGen infinite inwards tomcat, which tin post away stimulate a retentivity leak inwards Java application. It commonly happens due to ThreadLocal variables together with JDBC drivers but you lot tin post away certainly avoid that yesteryear knowing more

How to work JNDI database connexion puddle inwards Tomcat together with Spring

There 3 steps to configure together with run JNDI Datasource Connection pool for any  Java Web application:

1) Configure information source inwards Server together with create JNDI name.

2) Configure web.xml

3) Configure Spring edible bean alongside JNDI Datasource

4) Include JDBC driver library on Server lib e.g. tomcat/lib

In lodge to create JNDI DataSource on J2EE spider web server you lot involve to follow server documentation. On Tomcat half dozen you lot tin post away but pose next slice of XML in context.xml to create Tomcat managed database connexion pool:

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/springDataSourceDemo">
<Resource name="jdbc/springeDataSource"
         auth="Container"
         type="javax.sql.DataSource"
         driverClassName="oracle.jdbc.driver.OracleDriver"
         url="jdbc:oracle:thin:@localhost:1521:SPRING_TEST"
         username="root"
         password="root"
         removeAbandoned="true"
         removeAbandonedTimeout="90"
         logAbandoned="true"
         maxActive="20"
         maxIdle="10"
         maxWait="-1"/>
</Context>

Resource chemical subdivision volition create JNDI information source which tin post away live on referenced using JNDI cite "jdbc/springeDataSource". 

Tomcat internally work DBCP together with Commons puddle library for managing database connexion pool. You tin post away cheque tomcat/lib directory for jounce file tomcat-dbcp.jar which is responsible for creating database connexion puddle within tomcat server.

1. web.xml configuration to access JNDI Database connexion pool

In lodge to access whatever server resources from your spider web application, you lot involve to specify the JNDI resources inwards web.xml. 

You can work the next XML to declare JNDI Datasource inwards web.xml:

 <resource-ref>
        <description>Oracle Spring JNDI Datasource</description>
        <res-ref-name>jdbc/springDataSource</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
</resource-ref>

Now your spider web application volition encounter JNDI Datasource created inwards tomcat alongside cite jdbc/springDataSource. 

Btw, if you lot are non familiar alongside JNDI together with other Java EE concepts thence I showtime advise you lot acquire through JDBC driver jounce file. I commonly pose JAR file within lib directory of tomcat but you lot tin post away pose it anywhere it makes feel together with modifies tomcat classpath to include driver JAR into classpath. 


Now the residue of code which uses this information source should rest the same. You tin post away acquire Spring DAO source from the previous article How to setup Database Connection puddle inwards Spring framework.

Other Spring Framework Tutorials together with Resources for farther learning
Spring Framework 5: Beginner to Guru
Spring together with Hibernate Guide for Beginners

How to work Data Access Object or DAO blueprint pattern inwards Java

How to stair out execution fourth dimension using Spring’s Stopwatch utility

How to exercise LDAP authentication inwards Java spider web application using Spring Security

How to command concurrent user session inwards Java spider web application – Spring Security Tutorial

A quick guide to edible bean scopes inwards Spring Framework
Spring inwards Action quaternary edition yesteryear Craig Walls

Thanks for reading this article thence far. If you lot similar this article thence delight portion alongside your friends together with colleagues. If you lot accept whatever questions or feedback thence delight drib a note.


P.S. - If you lot desire to larn how to educate RESTful Web Service using Spring MVC inwards depth, I advise you lot bring together the REST alongside Spring certification class yesteryear Eugen Paraschiv. One of the best course of didactics to larn REST alongside Spring MVC.

Bagikan Artikel ini