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

mssql.sql file has invalid schema

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 0.9.28
    • logback-classic
    • None
    • 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

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

            Dates

              Created:
              Updated: