Jump to: navigation, search

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

< Jetty‎ | Howto
Line 120: Line 120:
 
===SQL Server 2000===
 
===SQL Server 2000===
  
Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource\
+
Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource
  
 
<source lang="xml">
 
<source lang="xml">
Line 136: Line 136:
 
     </Arg>
 
     </Arg>
 
     </New>
 
     </New>
</source
+
</source>
  
 
===Oracle 9i/10g===
 
===Oracle 9i/10g===
Line 143: Line 143:
  
 
<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.OracleConnectionPoolDataSource">
+
       <New class="oracle.jdbc.pool.OracleDataSource">
        <Set name="URL">jdbc:oracle:thin:@localhost:1521:orcl</Set>
+
        <Set name="DriverType">thin</Set>
        <Set name="User">user</Set>
+
        <Set name="URL">jdbc:oracle:thin:@fmsswdb1:10017:otcd</Set>
        <Set name="Password">pass</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>
 
       </New>
    </Arg>
+
    </Arg>
</New>
+
  </New>
 
</source>
 
</source>
 +
 +
For more information please follow [http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/conncache.htm#CDEBCBJC|this link].
  
 
===PostgreSQL===
 
===PostgreSQL===
Line 252: Line 265:
 
   </New>
 
   </New>
 
</source>
 
</source>
 
| category = [[Category:Jetty Howto]]
 
 
}}
 
}}

Revision as of 16:01, 28 June 2010



Introduction

Below are examples of setting up a JNDI datasource for various databases.

Idea.png
Tip:
Please read through the generic JNDI instructions for the background to configuring datasources.


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

  <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>

For convenience, we will assume that all of the datasources are declared at the JVM scope, but you can of course use other scopes, as discussed on the page on JNDI.

Don't forget that all JNDI resources can be configured in a jetty.xml file or in a WEB-INF/jetty-env.xml file, or a context xml file. More information on that can be found on the page on JNDI.




Examples

Pooling DataSources

Enables connection pooling. Connection pooling is basically re-using existing connections instead of creating a new connection to the database.This would be highly efficient in terms of memory allocation and speed of the request to the database. In production, this is highly recommended.

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're deploying in 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 follow [http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/conncache.htm#CDEBCBJC