Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | PostgreSQL | PostgreSQL JDBC Driver
 
PostgreSQL JDBC Driver
DataSource
Driver jar: for PostgreSQL
Transaction Type
DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION
org.postgresql.ds.PGSimpleDataSource
XA_TRANSACTION
org.postgresql.xa.PGXADataSource
Driver JAR
Use the postgresql-42.2.2.jar driver JAR for PostgreSQL JDBC Driver.
Other Properties
Specify the parameters in the Other Properties field:
Parameter
Description
postgresql.casesensitive
Enclose the table names, column names, and procedure names in quotes if the values are in upper case or camel case. Possible values are:
*true. Default. The table names, column names, and procedure names are enclosed in quotes if the values are in upper case or camel case.
*false. The table names, column names, and procedure names are not enclosed in quotes if the values are in upper case or camel case.
For example:
postgresql.casesensitive=true
Required Connection Property Fields
Driver Name
Server Name
User
Password
Database Name
Port Number
Network Protocol
PostgreSQL JDBC Driver
No
No
No
No
No
No
For more information about limitations, see Limitations.