Deep OTK questions

Products

• CA API Gateway

Issue/Introduction

There are a couple of "complicated" questions related to the OTK. Here's the important information:

JDBC Driver = com.l7tech.jdbc.oracle.OracleDriver
JDBC "Addtionnal Properties" = EnableCancelTimeout set to true
JDBC "Addtionnal Properties" = c3p0.idleConnectionTestPeriod set to 600
JDBC "Addtionnal Properties" = c3p0.maxConnectionAge set to 0
JDBC "Addtionnal Properties" = c3p0.maxIdleTime set to 0

1. According to Perform JDBC Query, for the Query Timeout, the gateway will wait X amount of time and then timeout. Does the gateway timeout without telling Oracle or will it send a "cancel"?

2. Is it possible to partition the oauth_token table?

 

Environment

API Gateway 10.1
OTK 4.5.1

Resolution

1. According to Perform JDBC Query, for the Query Timeout, the gateway will wait X amount of time and then timeout. Does the gateway timeout without telling Oracle or will it send a "cancel"?

[ANS] This is handled by the driver which has a property called EnableCancelTimeout which you have set to TRUE.

REF: Progress DataDirect - EnableCancelTimeout

 

2. Is it possible to partition the oauth_token table?

[ANS] Based on our documentation, this is only supported for OTK 4.6 deployed with MySQL.

REF: Partition oauth_token Table and Purge Tokens