NB: Please read through the generic JNDI instrutions for the background to configuring datasources.

DataSource Examples

Here are some examples of setting up a DataSource in JNDI for various databases.

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

Don't forget that all JNDI resources can be configured in a jetty.xml file (where they are available to all webapps) or in a WEB-INF/jetty-env.xml file where they will be available only to the declaring webapp. The following xml snippets can be inserted into either file. More information on that can be found here.

c3p0 (connection pooling)

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

dbcp (connection pooling)

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

Atomikos 3.3.2+ (connection pooling + XA transactions)

MySQL

implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

SQL Server 2000

implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

Oracle 9i/10g

implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource

PostgreSQL

implements javax.sql.DataSource

implements javax.sql.ConnectionPoolDataSource

Sybase

implements javax.sql.DataSource

DB2

implements javax.sql.DataSource

implements javax.sql.ConnectionPoolDataSource