Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Jetty/Howto/Configure JNDI Datasource"
Line 30: | Line 30: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 49: | Line 49: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 68: | Line 68: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 105: | Line 105: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 123: | Line 123: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 143: | Line 143: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 161: | Line 161: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 179: | Line 179: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 200: | Line 200: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 220: | Line 220: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> | ||
Line 238: | Line 238: | ||
<source lang="xml"> | <source lang="xml"> | ||
− | <New id="DSTest" class="org.eclipse.jetty.plus. | + | <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> |
<Arg></Arg> | <Arg></Arg> | ||
<Arg>jdbc/DSTest</Arg> | <Arg>jdbc/DSTest</Arg> |
Revision as of 23:21, 20 June 2010
Contents
Introduction
Below are examples of setting up a JNDI datasource for various databases.
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> </source ===Oracle 9i/10g=== Implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource <source lang="xml"> <New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="oracle.jdbc.pool.OracleConnectionPoolDataSource"> <Set name="URL">jdbc:oracle:thin:@localhost:1521:orcl</Set> <Set name="User">user</Set> <Set name="Password">pass</Set> </New> </Arg> </New>
PostgreSQL
Implements javax.sql.DataSource
<New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="org.postgresql.ds.PGSimpleDataSource"> <Set name="User">user</Set> <Set name="Password">pass</Set> <Set name="DatabaseName">dbname</Set> <Set name="ServerName">localhost</Set> <Set name="PortNumber">5432</Set> </New> </Arg> </New>
Implements javax.sql.ConnectionPoolDataSource
<New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="org.postgresql.ds.PGConnectionPoolDataSource"> <Set name="User">user</Set> <Set name="Password">pass</Set> <Set name="DatabaseName">dbname</Set> <Set name="ServerName">localhost</Set> <Set name="PortNumber">5432</Set> </New> </Arg> </New>
Sybase
Implements javax.sql.DataSource
<New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="com.sybase.jdbc2.jdbc.SybDataSource"> <Set name="DatabaseName">dbname</Set> <Set name="User">user</Set> <Set name="Password">pass</Set> <Set name="ServerName">servername</Set> <Set name="PortNumber">5000</Set> </New> </Arg> </New>
DB2
Implements javax.sql.DataSource
<New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="com.ibm.db2.jcc.DB2SimpleDataSource"> <Set name="DatabaseName">dbname</Set> <Set name="User">user</Set> <Set name="Password">pass</Set> <Set name="ServerName">servername</Set> <Set name="PortNumber">50000</Set> </New> </Arg> </New>
Implements javax.sql.ConnectionPoolDataSource
<New id="DSTest" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg></Arg> <Arg>jdbc/DSTest</Arg> <Arg> <New class="com.ibm.db2.jcc.DB2ConnectionPoolDataSource"> <Set name="DatabaseName">dbname</Set> <Set name="User">user</Set> <Set name="Password">pass</Set> <Set name="ServerName">servername</Set> <Set name="PortNumber">50000</Set> </New> </Arg> </New>