Forexample:
jdbc:oracle:thin:@localhost:1521:customer_db
■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.
Note– You must set the oracle-xa-recovery-workaround property in the Transaction
Servicefor recovery of global transactions to work correctly. For details, see “Workarounds
forSpecic Databases” on page 145.
Whenusing this driver, it is not possible to insert more than 2000 bytes of data into a
column.To circumvent this problem, use the OCI driver (JDBC type 2).
OCI OracleType 2 Driver for Oracle 8.1.7 and 9.x
Databases
TheJAR le for the OCI Oracle driver is ojdbc14.jar. Make sure that the shared library is
availablethrough LD_LIBRARY_PATHand that the ORACLE_HOME property is set.
Congurethe connection pool using the following settings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: Oracle
■DataSourceClassname:Specify one of the following:
oracle.jdbc.pool.OracleDataSource
oracle.jdbc.xa.client.OracleXADataSource
■Properties:
■user- Set as appropriate.
■password- Set as appropriate.
■URL- Specify the complete database URL using the following syntax:
jdbc:oracle:oci:[user/password]@host[:port]/service
Forexample:
jdbc:oracle:oci:@localhost:1521:customer_db
CongurationsforSpecic JDBC Drivers
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200860