JDBC Provider

Class name

org.postgresql.xa.PGXADataSource

com.mysql.jdbc.jdbc2.optional.MysqlXADataSource

com.microsoft.sqlserver.jdbc.SQLServerXADataSource

oracle.jdbc.xa.client.OracleXADataSource

Jar File

postgresql-9.2-1004-jdbc41.jar

mysql-connector-java-5.1.44.jar

sqljdbc42.jar

ojdbc7.jar

JDBC Data Source

URL

jdbc:postgresql://(host):(port)/(database_name)

jdbc:mysql://(host):(port)/(database_name)

jdbc:sqlserver://(server_name):(port)

• jdbc:oracle:thin:@//(host):(port)/(service_name)

• jdbc:oracle:thin:@(host):(port):SID

Validation Query

select 1

select 1

select 1

select 1

Custom Properties

• Name: databaseName; Value: <the database name>

• Name: generateSimpleParameterMetadata; Value: true

• Name: searchpath; Value: <the schema name>

• Name: serverName; Value: <the DB server IP address or FQDN>

• Name: portNumber; Value: <the TCP port number of the DB server>

Name: generateSimpleParameterMetadata; Value: true

• Name: generateSimpleParameterMetadata; Value: true

• Name: instanceName; Value: <the SQL instance name>

• Name: databaseName; Value: <the database name>

Name: generateSimpleParameterMetadata; Value: true