Uploaded image for project: 'logback'
  1. logback
  2. LOGBACK-360

mssql.sql file has invalid schema

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.9.28
    • Fix Version/s: None
    • Component/s: logback-classic
    • Labels:
      None
    • Environment:

      Java 1.6 / Apache Tomcat 6 / SuSE Enterprise / Microsoft SQL Server 2005 - 9.00.4035.00 (x64 Enterprise Edition)

      Description

      In the file logback-0.9.28\logback-classic\src\main\java\ch\qos\logback\classic\db\dialect\mssql.sql, the type of DECIMAL(40) is invalid in SQL Server 2005. I had to change it to 38 to create the table.

      I apologize if this is a duplicate. I did a search and couldn't find any relevant bugs, but noticed in the source file the following commnet:

      – The event_id column type was recently changed from INT to DECIMAL(40)
      – without testing.

        Attachments

          Activity

            People

            • Assignee:
              logback-dev Logback dev list
              Reporter:
              djsumdog Sumit Khanna
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: