Microsoft SQL Server Database Type 4 Sun GlassFish/DataDirect JDBC Driver

The JAR file for the Sun driver is smsqlserver.jar; the JAR file for the DataDirect driver is sqlserver.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: Microsoft SQL Server

• DataSource Classname: com.sun.sql.jdbcx.sqlserver.SQLServerDataSource

  DataDirect DataSource Classname: com.ddtek.jdbcx.sqlserver.SQLServerDataSource

• Properties:

  • serverName – Specify the host name or IP address and the port of the database server.

  • portNumber – Specify the port number of the database server.

  • user – Set as appropriate.

  • password – Set as appropriate.

  • selectMethod – Set to cursor.