Microsoft SQL Server JDBC Driver

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]