From cf2852409c6d7b3fa9981d46335c8028913e4ed6 Mon Sep 17 00:00:00 2001
From: Eike Stepper
Date: Fri, 9 Nov 2012 05:12:29 +0100
Subject: [393917] [DB] change Boolean mapping to use a NUMBER type in Oracle
 DB https://bugs.eclipse.org/bugs/show_bug.cgi?id=393917

---
 .../src/org/eclipse/net4j/db/oracle/OracleAdapter.java               | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

diff --git a/plugins/org.eclipse.net4j.db.oracle/src/org/eclipse/net4j/db/oracle/OracleAdapter.java b/plugins/org.eclipse.net4j.db.oracle/src/org/eclipse/net4j/db/oracle/OracleAdapter.java
index 60e222f37e..26f4517943 100644
--- a/plugins/org.eclipse.net4j.db.oracle/src/org/eclipse/net4j/db/oracle/OracleAdapter.java
+++ b/plugins/org.eclipse.net4j.db.oracle/src/org/eclipse/net4j/db/oracle/OracleAdapter.java
@@ -146,11 +146,10 @@ public class OracleAdapter extends DBAdapter
     case TINYINT:
       return "NUMBER(5)";
     case SMALLINT:
+    case BOOLEAN:
       return "NUMBER(7)";
     case INTEGER:
       return "NUMBER(12)";
-    case BOOLEAN:
-      return "VARCHAR2(5)";
     case DATE:
     case TIME:
       return "DATE";
@@ -167,7 +166,7 @@ public class OracleAdapter extends DBAdapter
   {
     if (type == DBType.BOOLEAN)
     {
-      return DBType.VARCHAR;
+      return DBType.SMALLINT;
     }
 
     return super.adaptType(type);
-- 
cgit v1.2.3