Sun Microsystems 820433510 manual Inet Merlia Jdbc Driver for Microsoft SQL Server Databases

Configurations for Specific JDBC Drivers

■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 isMerlia.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.

58 Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008