When I query PI database using JDBC with large amount of data, it throws the exception as shown below:
java.sql.SQLException: [PIOLEDB] Timeout has expired.
at java.lang.Thread.run(Unknown Source)
The same issue happens when I use PI SQL Commander to query the same amount of data.
Time out happens after querying for about 60 seconds. But the time out limit in PI-SDK (on both client and server side) has been set to be long enough (600 on server and 100000000 on client).
I wonder where I can configure the time out limit of PIOLEDB? Or should I need to simply add the string like "Connect Timeout=xxxx;Command Timeout = xxxx" in the jdbc connection url??
Thank you for your kind help