You can view the issue detail at the following URL:
<http://nagoya.apache.org/scarab/issues/id/TRQS53>
Type : Defect
Issue Id : TRQS53
Reported by: Alexander Gusev
[EMAIL PROTECTED] - ([EMAIL PROTECTED])
Details:
Summary: DB2 SQL generation -> DATE, TIME, TIMESTAMP default values -> CURRENT DATE
Description: There are special registries for DATE, TIME, TIMESTAMP data types in
DB2 SQL. They are CURRENT DATE/TIME/TIMESTAMP.
If set default value for DATE field (TIMESTAMP type) to CURRENT
TIMESTAMP in "project-schema.xml", TORQUE generates invalid quoted
statement -> DATE TIMESTAMP default 'CURRENT TIMESTAMP' NOT NULL.
Valid statement should be unquoted.
I have edited next java-source for valid SQL statements generation:
org.apache.torque.engine.database.model.TypeMap.java ->lines 134-137:
private static final String[] TEXT_TYPES =
{
CHAR, VARCHAR, LONGVARCHAR, CLOB, DATE, TIME, TIMESTAMP,
BOOLEANCHAR
};
But I don't use TORQUE generated java-classes yet. So I don't know how
affect this edition to generated java-classes behaviour.
Status: New
Database: DB2
Operating system: Windows
Priority: Undecided
--
To unsubscribe, e-mail: <mailto:turbine-torque-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-dev-help@;jakarta.apache.org>
