Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-2724

SQL Server 2012 timestamp bug persists after MS driver update

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Environment:

      MS SQL Server 2012
      Windows Server 2008 R2
      Railo 4.1.1.009 final

      Description

      This bug is directly related to the bug that was hastily closed yesterday, https://issues.jboss.org/browse/RAILO-2723. Following the tech's instructions, I updated the ms sql server jdbc driver and confirmed that it was updated from 3.0 to 4.0 using the following:

      <cfset jdbcDriver = CreateObject("java", "com.microsoft.jdbc.sqlserver.SQLServerDriver")>

      <cfoutput>#jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()#</cfoutput>

      After a restart and using the same code from the aforementioned closed bug, I still had an issue with inconsistent milliseconds between the now() value stored in a local variable and the milliseconds stored in sql using cf_sql_timestamp.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                igal-getrailo.org Igal .
                Reporter:
                mpennypacker Mark Pennypacker
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: