AnsweredAssumed Answered

[PIOLEDB] Timeout has expired

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



          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(

  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(


  at 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