Sample configuration for database providers

Last Updated : Nov 23, 2017 |
Prolog information
Metadata
Keywords:
Field name
PostgreSQL
My SQL
MS SQL
Oracle
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
Note:
The jar file names and versions mentioned in the table are examples. When configuring JDBC provider for external database, refer to database documentation and select correct JDBC driver jar version.
Related links
JDBC resource providers and data source