Sun Microsystems GLASSFISH ENTERPRISE 820433510 - Manual (Page 55)

Sun GlassFish JDBC Driver for Microsoft SQL Server
Databases
The JAR files for this driver are smbase.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 are smbase.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]
Configurations for Specific JDBC Drivers
Chapter 3 • JDBC Resources 55