OSISOFT Pi JDBC timestamp


I am getting data from Pi with Ignition 8.1.11 using a JDBC connector.

My issue is when I select data from picomp2 (value and time), the returned dataset cannot be written in a dataset tag.

It seems the datetime format returned by Pi is not compatible with the datetime format used by Ignition. I could convert it to string, but then I won’t be able to show the data in a trend chart…

Any idea?

That is a known bug–the datatype whitelist omitted java.sql.Timestamp. It has been fixed, but I don’t recall what version.

Is there a workaround?

Not for storage in a dataset tag, no. Upgrade is the only option.

Edit: well, you could reprocess the dataset instantiating a java.util.Date wherever you have a java.sql.Timestamp.