[logback-user] MS SQL Server script error

[Paul Krause]

DECIMAL(38) is what we used. No issues so far.

Thanks,
Paul

On Nov 27, 2014, at 11:44, D?rio Abdulrehman <dario.rehman at gmail.com<mailto:dario.rehman at gmail.com>> wrote:

Hi,

The change that is documented in the mssql.sql script
https://github.com/qos-ch/logback/blob/edc0fe2340782a592f9fd8329287d8ea5557b09c/logback-classic/src/main/resources/ch/qos/logback/classic/db/script/mssql.sql

as "The event_id column type was recently changed from INT to DECIMAL(40) without testing."
does not work in MS SQL Server 2008 R2.

It issues the following error:

Column or parameter #15: Specified column precision 40 is greater than the maximum precision of 38.

Changing the mentioned fields to DECIMAL(38) fixes the problem but perhaps it is better to revert back to INT?

Thanks,
D?rio


_______________________________________________
Logback-user mailing list
Logback-user at qos.ch<mailto:Logback-user at qos.ch>
http://mailman.qos.ch/mailman/listinfo/logback-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qos.ch/pipermail/logback-user/attachments/20141127/c22d3f3c/attachment.html>