[prev in list] [next in list] [prev in thread] [next in thread] 

List:       logback-dev
Subject:    [logback-dev] [JIRA] Created: (LBCLASSIC-266) mssql.sql file has
From:       "Sumit Khanna (JIRA)" <noreply-jira () qos ! ch>
Date:       2011-05-12 13:07:51
Message-ID: 1230373992.1305205671261.JavaMail.ceki () pixie
[Download RAW message or body]

mssql.sql file has invalid schema 
----------------------------------

                 Key: LBCLASSIC-266
                 URL: http://jira.qos.ch/browse/LBCLASSIC-266
             Project: logback-classic
          Issue Type: Bug
          Components: appender
    Affects Versions: 0.9.28
         Environment: Java 1.6 / Apache Tomcat 6 / SuSE Enterprise / Microsoft SQL \
Server 2005 - 9.00.4035.00 (x64 Enterprise Edition)  Reporter: Sumit Khanna
            Assignee: Logback dev list


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.
 


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: \
                http://jira.qos.ch/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        
_______________________________________________
logback-dev mailing list
logback-dev@qos.ch
http://qos.ch/mailman/listinfo/logback-dev


[prev in list] [next in list] [prev in thread] [next in thread]