Sun Microsystems GLASSFISH ENTERPRISE 820433510 - Manual (Page 58)

■ DataSource Classname: com.inet.ora.OraDataSource
■ Properties:
■ user - Specify the database user.
■ password - Specify the database password.
■ serviceName - Specify the URL of the database. The syntax is as follows:
jdbc:inetora: server:port:dbname
For example:
jdbc:inetora:localhost:1521:payrolldb
In this example,localhost is the host name of the machine running the Oracle server,
1521
is the Oracle server’s port number, and payrolldb is the SID of the database. For
more information about the syntax of the database URL, see the Oracle documentation.
■ serverName - Specify the host name or IP address of the database server.
■ port - Specify the port number of the database server.
■ streamstolob - If the size of BLOB or CLOB data types exceeds 4 KB and this driver is
used for CMP, this property must be set to true.
■ xa-driver-does-not-support-non-tx-operations - Set to the value true. Optional:
only needed if both non-XA and XA connections are retrieved from the same
connection pool. Might degrade performance.
As an alternative to setting this property, you can create two connection pools, one for
non-XA connections and one for XA connections.
Inet Merlia JDBC Driver for Microsoft SQL Server
Databases
The JAR file for the Inet Microsoft SQL Server driver is Merlia.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.inet.tds.TdsDataSource
■ Properties:
■ serverName - Specify the host name or IP address and the port of the database server.
■ port - Specify the port number of the database server.
■ user - Set as appropriate.
Configurations for Specific JDBC Drivers
Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008 58