The JAR file for this driver is sqljdbc.jar. Configure the connection pool using the following settings:
Name: Use this name when you configure the JDBC resource later.
Resource Type: Specify the appropriate value.
Database Vendor: mssql
DataSource Classname: Specify one of the following:
com.microsoft.sqlserver.jdbc.SQLServerDataSource com.microsoft.sqlserver.jdbc.SQLServerXADataSource
Properties:
serverName - Specify the host name or IP address and the port of the database server. This is optional. This could be a DNS or IP address, or it could be localhost or 127.0.0.1 for the local computer.
instanceName - Specify the instance to connect to on serverName. This is optional. If not specified, a connection to the default instance is made.
portNumber - Specify the port number of the database server. This is optional. The default is 1433. For optimal connection performance, set the portNumber when connecting to a named instance. This avoids a round trip to the server to determine the port number.
user - Set as appropriate.
password - Set as appropriate.
selectMethod - Set to cursor.
Additional properties - For additional optional properties you can set, see Setting the Connection Properties.
URL: jdbc:sqlserver://[serverName][\instanceName][:portNumber][;property=value]