AnsweredAssumed Answered

[PIOLEDB] Timeout has expired

Question asked by ChenZhuo_siemens on May 27, 2017
Latest reply on May 29, 2017 by Kenji Hashimoto

Hi:

 

          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 com.osisoft.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:191)

  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

  at com.xxx.xxx.data.HistoricalReadExecutor.run(HistoricalReadExecutor.java:71)

  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

Outcomes