From 29beda167202bebddb4f7e09e8e4e6f0a12295a3 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Tue, 13 Dec 2016 13:01:18 +0100 Subject: SONAR-5471 fix type of INTEGER columns on Oracle Correct type is NUMBER(38,0) but not INTEGER Signed-off-by: Simon Brandhof --- sonar-db/src/main/java/org/sonar/db/version/IntegerColumnDef.java | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sonar-db/src/main/java/org/sonar') diff --git a/sonar-db/src/main/java/org/sonar/db/version/IntegerColumnDef.java b/sonar-db/src/main/java/org/sonar/db/version/IntegerColumnDef.java index c0420dbdf37..af26630785c 100644 --- a/sonar-db/src/main/java/org/sonar/db/version/IntegerColumnDef.java +++ b/sonar-db/src/main/java/org/sonar/db/version/IntegerColumnDef.java @@ -46,12 +46,13 @@ public class IntegerColumnDef extends AbstractColumnDef { public String generateSqlType(Dialect dialect) { switch (dialect.getId()) { case PostgreSql.ID: - case Oracle.ID: case MySql.ID: case H2.ID: return "INTEGER"; case MsSql.ID: return "INT"; + case Oracle.ID: + return "NUMBER(38,0)"; default: throw new IllegalArgumentException("Unsupported dialect id " + dialect.getId()); } -- cgit v1.2.3