Ben Nadel • 10/5/2025

Telling My ColdFusion Connector/J JDBC MySql Connection String To Use UTC

Read Original

The author details a problem where date/time values stored from ColdFusion into a MySQL database were 5 hours off, despite using UTC conversions. After investigation, the issue was traced to the Connector/J JDBC driver's timezone handling. The solution involved modifying the JDBC connection string with specific parameters like `connectionTimeZone` and `preserveInstants` to ensure proper UTC time synchronization between the application and the database.

0 Comments
#coldfusion #jdbc #mysql
Telling My ColdFusion Connector/J JDBC MySql Connection String To Use UTC

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

No top articles yet