PostgreSQL

Advanced Server JDBC Connector Driver

Transaction Type	DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION	`com.edb.ds.PGSimpleDataSource`
XA_TRANSACTION	`com.edb.xa.PGXADataSource`

For information about the specific version of the client driver JARs to use, see IBM webMethods Adapters System Requirements.

Driver Name	Server Name	User	Password	Database Name	Port Number	Network Protocol
Advanced Server JDBC Connector Driver	Yes	Yes	Yes	Yes	Yes	No

For more information about limitations, see Limitations.

Transaction Type	DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION	`org.postgresql.ds.PGSimpleDataSource`
XA_TRANSACTION	`org.postgresql.xa.PGXADataSource`

For information about the specific version of the client driver JARs to use, see IBM webMethods Adapters System Requirements.

Specify the parameters in the Other Properties field:

Parameter Description

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`

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

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.

Driver	Database/ Adapter IS Operating System/ Platform Affected	Limitation Description
Advanced Server JDBC Connector Driver	Postgres Plus Advanced Server 9.0/ Any supported operating system	This driver does not support Query timeout.
PostgreSQL JDBC Driver	PostgreSQL	This driver does not support: Services: StoredProcedure, StoredProcedureWithSignature Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, and OrderedNotifications

Driver

Database/

Adapter IS Operating System/

Platform Affected

Limitation Description

Advanced Server JDBC Connector Driver

Postgres Plus Advanced Server 9.0/

Any supported operating system

This driver does not support Query timeout.

PostgreSQL JDBC Driver

PostgreSQL

This driver does not support:

Services: StoredProcedure, StoredProcedureWithSignature
Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, and OrderedNotifications