Hello Martin,
Monday, May 06, 2002, 6:10:19 PM, you wrote:
MP> did you ty the testbed with your code changes?
well ... i forgot it, but now i try it, and found some minor bugs :-)
(because SAP convert all column+table name to uppercase, unless there
are a "-around them)
So I include the correct patch, with it i can run 'ant test', and all
the table-creator SQL-commands successfully executed.
---------------------
cvs -z9 diff (in directory
C:\progs\cvs\jakarta-turbine-torque\src\templates\sql\base\sapdb\)
cvs server: Diffing .
Index: db.props
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/sapdb/db.props,v
retrieving revision 1.2
diff -r1.2 db.props
14,16c14,16
< CHAR = VARCHAR2
< VARCHAR = VARCHAR2
< LONGVARCHAR = VARCHAR2
---
> CHAR = CHAR
> VARCHAR = VARCHAR
> LONGVARCHAR = LONG VARCHAR
Index: drop.vm
===================================================================
RCS file: /home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/sapdb/drop.vm,v
retrieving revision 1.1.1.1
diff -r1.1.1.1 drop.vm
1c1
< drop table $table.Name cascade constraints;
---
> drop table $table.Name cascade;
Index: foreignkey.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/sapdb/foreignkey.vm,v
retrieving revision 1.2
diff -r1.2 foreignkey.vm
3c3
< ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
---
> FOREIGN KEY $fk.Name ($fk.LocalColumnNames)
Index: primarykey.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/sapdb/primarykey.vm,v
retrieving revision 1.1.1.1
diff -r1.1.1.1 primarykey.vm
0a1
> #if ($table.hasPrimaryKey())
2,3c3,4
< ADD CONSTRAINT ${table.Name}_PK
< PRIMARY KEY ($table.printPrimaryKey());
---
> ADD PRIMARY KEY ($table.printPrimaryKey()) ;
> #end
*****CVS exited normally with code 1*****
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
