Until recently, we had to support a very old MS SQL Server database. To do so, we used a very old JDBC driver. It's filename is sqljdbc4.jar
. I'm not 100% sure what JDBC release that is, but I'm guessing it's at least as old as version 6; it could be older. After updating to version 12.4 (latest), most features work correctly. There is one oddity regarding how time(7) data is returned to Ignition.
When querying data in a time(7) column, the old JDBC driver appears to return a string. The new JDBC returns a date (Jan. 1, 1900 + selected time).
I tried adding sendTimeAsDatetime=false
to the extra connection properties of the database connection. I also tried setSendTimeAsDatetime=false
. Neither of these appeared to change the behavior.
Is there any way to get the old behavior back, or do I need to go through and re-write the application logic to expect a different data type?
Old JDBC behavior:
New JDBC behavior:
Ignition Version: 8.1.17
Java version: 11.0.15+10-LTS