Sun Microsystems Sun GlassFish Enterprise Server 2.1, Administration Manual

Page: 55 / 256

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