May 7th, 2009, 10:09 PM
providing automatic utc conversion
Our application needs to optionally store date/time as UTC based on customer configuration. The application will always just deal with wall clock. The persistence layer needs to understand if date/times should be converted to UTC and do the conversion on the way in and out of the db. Basically we need to :
Provide a way to determine whether the database is UTC or Wall Clock
Change PreparedStatement set() methods to convert values to UTC
Change ResultSet get() methods to convert values to Wall Clock
There are solutions in place for our in-house written c++ and jdbc frameworks but I am recommending we replace the jdbc framework with spring jdbc (favoring COTS over roll your own frameworks) so I need to find a way to meet this requirement in Spring. I am new to spring jdbc and am wondering how to best implement this. We have a solution to determine whether or not a customer will store date/time as UTC, I just need to find the best way to plugin this logic. Any ideas?
Tags for this Thread