On 3/13/06, Joachim Wackerow <[EMAIL PROTECTED]> wrote: > I just started to try DdlUtils. I encountered following problem: > > A default NULL results in 'NULL' in the SQL code not in NULL without the > quotes. > > <column name="organisation" type="VARCHAR" size="50" default="NULL"/> > results in SQL code > organisation VARCHAR(50) DEFAULT 'NULL', > > How can I define the NULL value in the XML file, so it does not get > interpreted as a string value? Does exist some escape character? I > looked thru the documentation, in some source files, and searched the > mailing list, but didn't find anything. Did I overlook something?
SQL NULL is the default value if you do not specify one - there is no other to specify it except by not specifying it. > Same problem with CURRENT_TIMESTAMP > > <column name="timestamp" type="TIMESTAMP" default="CURRENT_TIMESTAMP"/> > results in SQL code > timestamp TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP', In general the default value is expected to be a string value that can be converted to the Java type corresponding to the JDBC type (as defined by the JDBC spec). What you need in this case would be a nativeDefault attribute which is not interpreted by DdlUtils at all. This is currently not possible, but you could add a feature request to DdlUtils' JIRA. cheers, Tom
