Advanced PI SQL Client JDBC topics

Multithreading

PI SQL Client JDBC supports query execution from multiple threads. We recommend you reuse connection objects as often as possible because connection open and close operations are expensive. For example, connection objects can be passed as parameter to a new thread and when that thread is finished, it returns that connection to a connection pool.

JDBC Driver extensions

PI SQL Client JDBC supports JDBC extensions, also known as JDBC 2.0 Optional Package, or javax.sql, that allow configuring connections in a directory service through JNDI. It also allows using JNDI connection pooling.

Note: The connection pooling is a simple implementation to support environments that demand that interface. However, there is no performance gain when using this interface. Therefore, OSIsoft recommends you reuse connections in the application itself.