[393917] [DB] change Boolean mapping to use a NUMBER type in Oracle DB drops/I20121109-0410

https://bugs.eclipse.org/bugs/show_bug.cgi?id=393917

1 files 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);