Sun GlassFishJDBC Driver for Microsoft SQL Server
Databases
TheJAR les for this driver are smbase.jar,smsqlserver.jar, and smutil.jar. Congure the
connectionpool using the following settings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: mssql
■DataSourceClassname: 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 GlassFishJDBC Driver for Sybase Databases
TheJAR les for this driver are smbase.jar,smsybase.jar, and smutil.jar. Congure the
connectionpool using the following settings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: Sybase
■DataSourceClassname: 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]
CongurationsforSpecic JDBC Drivers
Chapter3 • JDBC Resources 55