Sun Microsystems 820433510 manual Sun GlassFish Jdbc Driver for Microsoft SQL Server Databases

Configurations for Specific JDBC Drivers

Sun GlassFish JDBC Driver for Microsoft SQL Server Databases

The JAR files for this driver aresmbase.jar, smsqlserver.jar, and smutil.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: com.sun.sql.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.

■URL: jdbc:sun:sqlserver://serverName[:portNumber]

Sun GlassFish JDBC Driver for Sybase Databases

The JAR files for this driver aresmbase.jar, smsybase.jar, and smutil.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: Sybase

■DataSource Classname: com.sun.sql.jdbcx.sybase.SybaseDataSource

■Properties:

■serverName - Specify the host name or IP address of the database server.

■portNumber - Specify the port number of the database server.

■databaseName - Set as appropriate. This is optional.

■user - Set as appropriate.

■password - Set as appropriate.

■URL: jdbc:sun:sybase://serverName[:portNumber]

Chapter 3 • JDBC Resources 55