Datasource

In this example, I am going to try and set-up a Microsoft SQL Server connection pool and JDBC resource.

Setup

Copy your JDBC driver (in this example jtds-1.2.jar) to the domain-dir/lib folder. On a default GlassFish 2 installation:
```
C:\tools\glassfish-v2ur2\domains\domain1\lib\
```
Re-start the GlassFish server.

Log into the admin interface.
Resources, JDBC, Connection Pools, New (or Common Tasks, Create New JDBC Connection Pool).
Give the connection pool a name. Possibly best to append the work pool to make it clear e.g. integration_test_pool.
Choose a Resource Type. Choices include javax.sql.XADataSource (global transactions), java.sql.ConnectionPoolDataSource (local transactions, possible performance improvements), and javax.sql.DataSource (local transactions only).
Choose a Database Vendor and click Next.
If the JDBC driver has a Datasource class for the resource type and database vendor specified in the previous page, then the value of the Datasource Classname field is provided. If not, enter it e.g. net.sourceforge.jtds.jdbcx.JtdsDataSource.
If you would like to, enter a description of the connection pool.
Fill in Pool Settings details as required (see the Help file for detailed information).
Fill in Connection Validation as required (see the Help file for detailed information).

Note: If you are deploying a Spring within GlassFish and it will need access to this resource, make sure you tick Allow Non Component Callers.
Fill in Transaction details as required (see the Help file for detailed information).

Fill in the properties as required for your database driver:

../../images/howto/glassfish/connection-pool-properties.gif