Question
1
Replies
136
Views
Incessant Technologies Pvt Ltd.
AU
Posted: January 12, 2016
Last activity: January 12, 2016
Last activity: 12 Jan 2016 23:02 EST
Closed
selectMethod custom property in datasource in Websphere for Pega 7.1.8
Pega 7.1.8 installation guide (Websphere / MS SQL) recommends to keep the value as "cursor" for the custom property "selectMethod" in the Websphere data source.
What is the reason for keeping this value as "cursor"?
Posted: 7 years ago
Pegasystems Inc.
US
This is a property specific to Microsoft Sql server jdbc driver, see this link for details: Setting the Connection Properties. For pega PRPC, this property needs to be set to cursor as long as the database is sqlserver, independent of app servers.