mpoeschl 2003/08/04 16:20:28
Modified: xdocs changes.xml
src/generator/src/templates/sql/base/db2 columns.vm
Log:
TRQS174: Problems on DB2 with BINARY, VARBINARY and INTEGER.
Revision Changes Path
1.97 +3 -0 db-torque/xdocs/changes.xml
Index: changes.xml
===================================================================
RCS file: /home/cvs/db-torque/xdocs/changes.xml,v
retrieving revision 1.96
retrieving revision 1.97
diff -u -r1.96 -r1.97
--- changes.xml 3 Aug 2003 13:42:40 -0000 1.96
+++ changes.xml 4 Aug 2003 23:20:27 -0000 1.97
@@ -39,6 +39,9 @@
<li>
TRQS152: Oracle DB using Criteria to select by Data doesn't work
</li>
+ <li>
+ TRQS174: Problems on DB2 with BINARY, VARBINARY and INTEGER.
+ </li>
</ul>
</p>
</subsection>
1.2 +5 -2 db-torque/src/generator/src/templates/sql/base/db2/columns.vm
Index: columns.vm
===================================================================
RCS file: /home/cvs/db-torque/src/generator/src/templates/sql/base/db2/columns.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- columns.vm 10 Feb 2003 13:18:45 -0000 1.1
+++ columns.vm 4 Aug 2003 23:20:28 -0000 1.2
@@ -1,15 +1,18 @@
#foreach ($col in $table.Columns)
#set ( $type = $dbprops.get($col.Type) )
#set ( $size = $col.printSize() )
+ #if ( $type == "INTEGER" )
+ #set ( $size = "" )
+ #end
#set ( $rawsize = $col.Size )
#set ( $torquetype = $col.TorqueType )
#set ( $default = $col.DefaultSetting )
#set ( $autoIncrement = $strings.select($col.isAutoIncrement(),
$dbprops.get("AUTOINCREMENT"),"") )
#set ( $nullString = $strings.select($col.isNotNull(),
$dbprops.get("NOTNULL"),"") )
#if ( $torquetype == "BINARY" )
- #set ( $entry = "$col.Name CHAR($rawsize) FOR BIT DATA $type $size $default
$nullString $autoIncrement," )
+ #set ( $entry = "$col.Name CHAR($rawsize) FOR BIT DATA $default $nullString
$autoIncrement," )
#elseif ( $torquetype == "VARBINARY" )
- #set ( $entry = "$col.Name VARCHAR($rawsize) FOR BIT DATA $type $size
$default $nullString $autoIncrement," )
+ #set ( $entry = "$col.Name VARCHAR($rawsize) FOR BIT DATA $default
$nullString $autoIncrement," )
#else
#set ( $entry = "$col.Name $type $size $default $nullString
$autoIncrement," )
#end
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
