■DataSourceClassname: 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
Forexample:
jdbc:inetora:localhost:1521:payrolldb
Inthis example,localhost is the host name of the machine running the Oracle server,
1521is the Oracle server’s port number, and payrolldb is the SID of the database. For
moreinformation 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
usedfor CMP,this property must be set to true.
■xa-driver-does-not-support-non-tx-operations- Set to the value true. Optional:
onlyneeded if both non-XA and XA connections are retrieved from the same
connectionpool. Might degrade performance.
Asan alternative to setting this property, you can create two connection pools, one for
non-XAconnections and one for XA connections.
Inet Merlia JDBC Driverfor Microsoft SQL Ser ver
Databases
TheJAR le for the Inet Microsoft SQL Server driver is Merlia.jar. Congure the connection
poolusing the following settings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: mssql
■DataSourceClassname: 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.
CongurationsforSpecic JDBC Drivers
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200858