[power-architect] r3146 committed - Forward engineer INTEGER columns to NUMBER(38) on Oracle to get a cons...

Thu, 03 Sep 2009 13:58:28 -0700 


Revision: 3146
Author: [email protected]
Date: Thu Sep  3 13:57:37 2009
Log: Forward engineer INTEGER columns to NUMBER(38) on Oracle to get a consistent behaviour, as this is what Oracle does when using INTEGER as a datatype directly in SQL 
http://code.google.com/p/power-architect/source/detail?r=3146

Modified:
 /trunk/src/ca/sqlpower/architect/ddl/Oracle9PlusDDLGenerator.java
 /trunk/src/ca/sqlpower/architect/ddl/OracleDDLGenerator.java

=======================================
--- /trunk/src/ca/sqlpower/architect/ddl/Oracle9PlusDDLGenerator.java Thu Jul 23 14:49:49 2009 +++ /trunk/src/ca/sqlpower/architect/ddl/Oracle9PlusDDLGenerator.java Thu Sep 3 13:57:37 2009 
@@ -57,7 +57,7 @@
typeMap.put(Integer.valueOf(Types.DECIMAL), new GenericTypeDescriptor("NUMBER", Types.DECIMAL, 38, null, null, DatabaseMetaData.columnNullable, true, true)); typeMap.put(Integer.valueOf(Types.DOUBLE), new GenericTypeDescriptor("NUMBER", Types.DOUBLE, 38, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.FLOAT), new GenericTypeDescriptor("FLOAT", Types.FLOAT, 38, null, null, DatabaseMetaData.columnNullable, false, false)); - typeMap.put(Integer.valueOf(Types.INTEGER), new GenericTypeDescriptor("NUMBER", Types.INTEGER, 38, null, null, DatabaseMetaData.columnNullable, true, false)); + typeMap.put(Integer.valueOf(Types.INTEGER), new GenericTypeDescriptor("NUMBER", Types.INTEGER, 38, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.LONGVARBINARY), new GenericTypeDescriptor("LONG RAW", Types.LONGVARBINARY, 2000000000L, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.NUMERIC), new GenericTypeDescriptor("NUMBER", Types.NUMERIC, 38, null, null, DatabaseMetaData.columnNullable, true, true)); typeMap.put(Integer.valueOf(Types.REAL), new GenericTypeDescriptor("NUMBER", Types.REAL, 38, null, null, DatabaseMetaData.columnNullable, false, false)); 
=======================================
--- /trunk/src/ca/sqlpower/architect/ddl/OracleDDLGenerator.java Thu Jan 29 12:02:55 2009 +++ /trunk/src/ca/sqlpower/architect/ddl/OracleDDLGenerator.java Thu Sep 3 13:57:37 2009 
@@ -195,7 +195,7 @@
typeMap.put(Integer.valueOf(Types.DECIMAL), new GenericTypeDescriptor("NUMBER", Types.DECIMAL, 38, null, null, DatabaseMetaData.columnNullable, true, true)); typeMap.put(Integer.valueOf(Types.DOUBLE), new GenericTypeDescriptor("NUMBER", Types.DOUBLE, 38, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.FLOAT), new GenericTypeDescriptor("FLOAT", Types.FLOAT, 38, null, null, DatabaseMetaData.columnNullable, false, false)); - typeMap.put(Integer.valueOf(Types.INTEGER), new GenericTypeDescriptor("NUMBER", Types.INTEGER, 38, null, null, DatabaseMetaData.columnNullable, true, false)); + typeMap.put(Integer.valueOf(Types.INTEGER), new GenericTypeDescriptor("NUMBER", Types.INTEGER, 38, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.LONGVARBINARY), new GenericTypeDescriptor("LONG RAW", Types.LONGVARBINARY, 2000000000L, null, null, DatabaseMetaData.columnNullable, false, false)); typeMap.put(Integer.valueOf(Types.NUMERIC), new GenericTypeDescriptor("NUMBER", Types.NUMERIC, 38, null, null, DatabaseMetaData.columnNullable, true, true)); typeMap.put(Integer.valueOf(Types.REAL), new GenericTypeDescriptor("NUMBER", Types.REAL, 38, null, null, DatabaseMetaData.columnNullable, false, false));

Reply via email to