Announcement Announcement Module
No announcement yet.
providing automatic utc conversion Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?