beautypg.com

Sample configuration, Transaction management – HP Integrity NonStop H-Series User Manual

Page 68

background image

Enabling container pooling enables to manage the connections through CLI.

Statement caching can be enabled in the datasources/datasource/statement
element. For more information, see tables 5.15 Pool settings and 5.20 Statement settings
at the

http://docs.jboss.org/ironjacamar/userguide/1.0/en-US/html/

deployment.html#deployingds_descriptor

site that explains all the attributes that can be

configured while defining the connection pool and statement caching.

Sample Configuration

The subsequent subsection explains certain DataSource configurations that are relevant to
SQL/MX.

The following are some salient features of this configuration:

1.

Connection pooling and statement caching are enabled at the driver’s DataSource level.

2.

Although the configuration defines a DataSource which is a non-XA DataSource element,
it can still participate in an XA transaction.

1.0" encoding="UTF-8"?>

enabled="true" use-java-context="true”>
jdbc:t4sqlmx://15.154.116.220:21001/:

eapcat


eapsch


eap.user


pass123


3


5


10


50

com.tandem.t4jdbc.SQLMXDataSource