Jump to: navigation, search

Difference between revisions of "Jetty/Howto/Configure JNDI Datasource"

< Jetty‎ | Howto
m
m
Line 52: Line 52:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
       <new class="com.mchange.v2.c3p0.ComboPooledDataSource">
+
       <New class="com.mchange.v2.c3p0.ComboPooledDataSource">
         <set name="driverClass">org.some.Driver</set>
+
         <Set name="driverClass">org.some.Driver</Set>
         <set name="jdbcUrl">jdbc.url</set>
+
         <Set name="jdbcUrl">jdbc.url</Set>
         <set name="user">jdbc.user</set>
+
         <Set name="user">jdbc.user</Set>
         <set name="password">jdbc.pass</set>
+
         <Set name="password">jdbc.pass</Set>
       </new>
+
       </New>
     </arg>
+
     </Arg>
     </new>
+
     </New>
 
</source>
 
</source>
  
Line 72: Line 72:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="org.apache.commons.dbcp.BasicDataSource">
+
         <New class="org.apache.commons.dbcp.BasicDataSource">
             <set name="driverClassName">org.some.Driver</set>
+
             <Set name="driverClassName">org.some.Driver</Set>
             <set name="url">jdbc.url</set>
+
             <Set name="url">jdbc.url</Set>
             <set name="username">jdbc.user</set>
+
             <Set name="username">jdbc.user</Set>
             <set name="password">jdbc.pass</set>
+
             <Set name="password">jdbc.pass</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
     </new>
+
     </New>
 
</source>
 
</source>
  
Line 92: Line 92:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
       <arg></arg>
+
       <Arg></Arg>
       <arg>jdbc/DSTest</arg>
+
       <Arg>jdbc/DSTest</Arg>
       <arg>
+
       <Arg>
         <new class="com.atomikos.jdbc.AtomikosDataSourceBean">
+
         <New class="com.atomikos.jdbc.AtomikosDataSourceBean">
             <set name="minPoolSize">2</set>
+
             <Set name="minPoolSize">2</Set>
             <set name="maxPoolSize">50</set>
+
             <Set name="maxPoolSize">50</Set>
             <set name="xaDataSourceClassName">com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</set>
+
             <Set name="xaDataSourceClassName">com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</Set>
             <set name="UniqueResourceName">DSTest</set>
+
             <Set name="UniqueResourceName">DSTest</Set>
             <get name="xaProperties">
+
             <Get name="xaProperties">
               <call name="setProperty">
+
               <Call name="setProperty">
                   <arg>url</arg>
+
                   <Arg>url</Arg>
                   <arg>jdbc:mysql://localhost:3306/databasename</arg>
+
                   <Arg>jdbc:mysql://localhost:3306/databasename</Arg>
               </call>
+
               </Call>
               <call name="setProperty">
+
               <Call name="setProperty">
                   <arg>user</arg>
+
                   <Arg>user</Arg>
                   <arg>some_username</arg>
+
                   <Arg>some_username</Arg>
               </call>
+
               </Call>
               <call name="setProperty">
+
               <Call name="setProperty">
                   <arg>password</arg>
+
                   <Arg>password</Arg>
                   <arg>some_password</arg>
+
                   <Arg>some_password</Arg>
               </call>
+
               </Call>
             </get>
+
             </Get>
         </new>
+
         </New>
       </arg>
+
       </Arg>
     </new>
+
     </New>
 
</source>
 
</source>
 +
  
  
Line 130: Line 131:
  
 
<source lang="xml">  
 
<source lang="xml">  
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
+
         <New class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
           <set name="Url">jdbc:mysql://localhost:3306/databasename</set>
+
           <Set name="Url">jdbc:mysql://localhost:3306/databasename</Set>
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
     </new>
+
     </New>
 
</source>
 
</source>
  
Line 149: Line 150:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
+
         <New class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="ServerName">localhost</set>
+
           <Set name="ServerName">localhost</Set>
           <set name="PortNumber">1433</set>
+
           <Set name="PortNumber">1433</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
     </new>
+
     </New>
 
</source>
 
</source>
  
Line 169: Line 170:
  
 
<source lang="xml">  
 
<source lang="xml">  
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
       <new class="oracle.jdbc.pool.OracleDataSource">
+
       <New class="oracle.jdbc.pool.OracleDataSource">
         <set name="DriverType">thin</set>
+
         <Set name="DriverType">thin</Set>
         <set name="URL">jdbc:oracle:thin:@fmsswdb1:10017:otcd</set>
+
         <Set name="URL">jdbc:oracle:thin:@fmsswdb1:10017:otcd</Set>
         <set name="User">xxxx</set>
+
         <Set name="User">xxxx</Set>
         <set name="Password">xxxx</set>
+
         <Set name="Password">xxxx</Set>
         <set name="connectionCachingEnabled">true</set>
+
         <Set name="connectionCachingEnabled">true</Set>
         <set name="connectionCacheProperties">
+
         <Set name="connectionCacheProperties">
           <new class="java.util.Properties">
+
           <New class="java.util.Properties">
             <call name="setProperty">
+
             <Call name="setProperty">
               <arg>MinLimit</arg>
+
               <Arg>MinLimit</Arg>
               <arg>5</arg>
+
               <Arg>5</Arg>
             </call>
+
             </Call>
 
             <!-- put the other properties in here too -->
 
             <!-- put the other properties in here too -->
           </new>
+
           </New>
         </set>
+
         </Set>
       </new>
+
       </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
Line 200: Line 201:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="org.postgresql.ds.PGSimpleDataSource">
+
         <New class="org.postgresql.ds.PGSimpleDataSource">
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="ServerName">localhost</set>
+
           <Set name="ServerName">localhost</Set>
           <set name="PortNumber">5432</set>
+
           <Set name="PortNumber">5432</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
Line 218: Line 219:
  
 
<source lang="xml">  
 
<source lang="xml">  
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="org.postgresql.ds.PGConnectionPoolDataSource">
+
         <New class="org.postgresql.ds.PGConnectionPoolDataSource">
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="ServerName">localhost</set>
+
           <Set name="ServerName">localhost</Set>
           <set name="PortNumber">5432</set>
+
           <Set name="PortNumber">5432</Set>
 
   
 
   
         </new>
+
         </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
Line 239: Line 240:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="com.sybase.jdbc2.jdbc.SybDataSource">
+
         <New class="com.sybase.jdbc2.jdbc.SybDataSource">
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="ServerName">servername</set>
+
           <Set name="ServerName">servername</Set>
           <set name="PortNumber">5000</set>
+
           <Set name="PortNumber">5000</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
Line 259: Line 260:
  
 
<source lang="xml">  
 
<source lang="xml">  
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="com.ibm.db2.jcc.DB2SimpleDataSource">
+
         <New class="com.ibm.db2.jcc.DB2SimpleDataSource">
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="ServerName">servername</set>
+
           <Set name="ServerName">servername</Set>
           <set name="PortNumber">50000</set>
+
           <Set name="PortNumber">50000</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
Line 277: Line 278:
  
 
<source lang="xml">
 
<source lang="xml">
   <new id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
+
   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <arg></arg>
+
     <Arg></Arg>
     <arg>jdbc/DSTest</arg>
+
     <Arg>jdbc/DSTest</Arg>
     <arg>
+
     <Arg>
         <new class="com.ibm.db2.jcc.DB2ConnectionPoolDataSource">
+
         <New class="com.ibm.db2.jcc.DB2ConnectionPoolDataSource">
           <set name="DatabaseName">dbname</set>
+
           <Set name="DatabaseName">dbname</Set>
           <set name="User">user</set>
+
           <Set name="User">user</Set>
           <set name="Password">pass</set>
+
           <Set name="Password">pass</Set>
           <set name="ServerName">servername</set>
+
           <Set name="ServerName">servername</Set>
           <set name="PortNumber">50000</set>
+
           <Set name="PortNumber">50000</Set>
         </new>
+
         </New>
     </arg>
+
     </Arg>
   </new>
+
   </New>
 
</source>
 
</source>
  
 
}}
 
}}

Revision as of 15:43, 27 January 2012



Introduction

This document provides examples of configuring a JNDI datasource for various databases.

Idea.png
Tip:
Read the generic JNDI instructions for background information about configuring datasources.


These examples all correspond to a <resource-ref> in web.xml:

  <resource-ref>
     <description>My DataSource Reference</description>
     <res-ref-name>jdbc/DSTest</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
  </resource-ref>


These examples assume that all of the datasources are declared at the JVM scope, but you can, of course, use other scopes. You can configure all JNDI resources in a jetty.xml file or in a WEB-INF/jetty-env.xml file, or a context XML file. For more information, see JNDI.

Pooling DataSources

Enables connection pooling. Connection pooling lets you reuse an existing connection instead of creating a new connection to the database.This is highly efficient in terms of memory allocation and speed of the request to the database. We highly recommend this option for production environments.

BoneCP

Connection pooling, available at http://jolbox.com/index.html?page=http://jolbox.com/download.html All configuration options for BoneCP are described here: http://jolbox.com/bonecp/downloads/site/apidocs/com/jolbox/bonecp/BoneCPDataSource.html

  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>jdbc/DSTest</Arg>
     <Arg>
       <New class="com.jolbox.bonecp.BoneCPDataSource">
         <Set name="driverClass">com.mysql.jdbc.Driver</Set>
         <Set name="jdbcUrl">jdbc.url</Set>
         <Set name="username">jdbc.user</Set>
         <Set name="password">jdbc.pass</Set>
         <Set name="minConnectionsPerPartition">5</Set>
         <Set name="maxConnectionsPerPartition">50</Set>
         <Set name="acquireIncrement">5</Set>
         <Set name="idleConnectionTestPeriod">30</Set>
      </New>
    </Arg>
  </New>

c3p0

Connection pooling, available at http://repo1.maven.org/maven2/c3p0/c3p0/0.9.1.2/c3p0-0.9.1.2.jar

  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>jdbc/DSTest</Arg>
     <Arg>
      <New class="com.mchange.v2.c3p0.ComboPooledDataSource">
         <Set name="driverClass">org.some.Driver</Set>
         <Set name="jdbcUrl">jdbc.url</Set>
         <Set name="user">jdbc.user</Set>
         <Set name="password">jdbc.pass</Set>
      </New>
     </Arg>
    </New>


dbcp

Connection pooling, available at http://repo1.maven.org/maven2/commons-dbcp/commons-dbcp/1.2/commons-dbcp-1.2.jar

  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>jdbc/DSTest</Arg>
     <Arg>
         <New class="org.apache.commons.dbcp.BasicDataSource">
            <Set name="driverClassName">org.some.Driver</Set>
            <Set name="url">jdbc.url</Set>
            <Set name="username">jdbc.user</Set>
            <Set name="password">jdbc.pass</Set>
         </New>
     </Arg>
    </New>


Atomikos 3.3.2+

Connection pooling + XA transactions.

   <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
      <Arg></Arg>
      <Arg>jdbc/DSTest</Arg>
      <Arg>
         <New class="com.atomikos.jdbc.AtomikosDataSourceBean">
            <Set name="minPoolSize">2</Set>
            <Set name="maxPoolSize">50</Set>
            <Set name="xaDataSourceClassName">com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</Set>
            <Set name="UniqueResourceName">DSTest</Set>
            <Get name="xaProperties">
               <Call name="setProperty">
                  <Arg>url</Arg>
                  <Arg>jdbc:mysql://localhost:3306/databasename</Arg>
               </Call>
               <Call name="setProperty">
                  <Arg>user</Arg>
                  <Arg>some_username</Arg>
               </Call>
               <Call name="setProperty">
                  <Arg>password</Arg>
                  <Arg>some_password</Arg>
               </Call>
            </Get>
         </New>
      </Arg>
    </New>


Non-pooling DataSources

If you are deploying in a production environment, use the Pooling DataSources instead.

MySQL

Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

 
  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>jdbc/DSTest</Arg>
     <Arg>
        <New class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
           <Set name="Url">jdbc:mysql://localhost:3306/databasename</Set>
           <Set name="User">user</Set>
           <Set name="Password">pass</Set>
        </New>
     </Arg>
    </New>


SQL Server 2000

Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>jdbc/DSTest</Arg>
     <Arg>
        <New class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
           <Set name="User">user</Set>
           <Set name="Password">pass</Set>
           <Set name="DatabaseName">dbname</Set>
           <Set name="ServerName">localhost</Set>
           <Set name="PortNumber">1433</Set>
        </New>
     </Arg>
    </New>

Oracle 9i/10g

Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

 
  <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg></Arg>
    <Arg>jdbc/DSTest</Arg>
    <Arg>
      <New class="oracle.jdbc.pool.OracleDataSource">
        <Set name="DriverType">thin</Set>
        <Set name="URL">jdbc:oracle:thin:@fmsswdb1:10017:otcd</Set>
        <Set name="User">xxxx</Set>
        <Set name="Password">xxxx</Set>
        <Set name="connectionCachingEnabled">true</Set>
        <Set name="connectionCacheProperties">
          <New class="java.util.Properties">
            <Call name="setProperty">
              <Arg>MinLimit</Arg>
              <Arg>5</Arg>
            </Call>
            <!-- put the other properties in here too -->
          </New>
        </Set>
      </New>
    </Arg>
  </New>

For more information please see [http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/conncache.htm#CDEBCBJC