Question
Intel
IN
Last activity: 19 Nov 2018 14:37 EST
Can we add retry feature in connection string
Below are the connection string the context.xml file :
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://abcd.com:3181;databaseName=**********;SelectMethod=cursor;SendStringParametersAsUnicode=false"
username="*********" password="*********"
maxTotal="100"
maxIdle="30"
maxWaitMillis="10000"
/>
Does maxWaitMillis mean connection wait time in ms which is 10seconds?
However I wish to know is there an retry attempt attributes with an interval option (after 10 secons)?
OR can we add any configuration to add the retry attempt after 10 seconds, if in case it fails?
EPAM Systems, Inc.
ES
Q. Does maxWaitMillis mean connection wait time in ms which is 10seconds?
A. Yes.
maxTotal, maxIdle, and maxWaitMillis:
These attributes control the processing of connection in the database connection pool.
Q. Is there an retry attempt attributes with an interval option?
A. No. As per my knowledge.
Q. Can we add any configuration to add the retry attempt after 10 seconds, if in case it fails?
A. I am trying to find if there are any DSS settings for re-attempt in case of failure. I will update you about the same.
Intel
IN
Hi Asif,
Are you able to find the DSS settings ? I found one PDC article "https://community.pega.com/knowledgebase/articles/configuring-number-database-transaction-retries", i followed that, but that is also not working.
Thanks & Regards,
Narhar Dev Sharma
Intel
IN
Hi,
The article "https://community.pega.com/knowledgebase/articles/configuring-number-database-transaction-retries" describe 3 DB's
<env name="database/databases/PegaRULES/retryAttempts" value="3"
<env name="database/databases/PegaDATA/retryAttempts" value="3"
<env name="database/databases/<other database name>/retryAttempts" value="3"
The 2 DB's "PegaRULES" and "PegaData" are predefined DB's ? OR these are Schema Names? What are they?
Also please tell if you are able to find the DSS setting?
Thanks & Regards,
Narhar Dev Sharma
Pegasystems Inc.
IN
Hi Narhar,
In the property,
<env name="database/databases/PegaRULES/retryAttempts" value="3">
PegaRULES refers to the Schema that has been define in the corresponding setting:
<Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="rules" type="java.lang.String" />
Here rules is my rule Schema in Database, so this setting will impact the connection to Rules Schema.
Thanks,
Vibek