db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Rall <...@finemaltcoding.com>
Subject Re: Problem in <sql> task for Oracle
Date Wed, 19 Nov 2003 23:18:17 GMT
Chiu Yee Weay wrote:
...
> When we generate Oracle scripts from XML schema, says :
> 
>     <column name="ABC" size="2147483647" type="LONGVARCHAR"/>
> 
> The output is :
> 
>     AC01UREMARKS VARCHAR2 (2000) (2147483647)
> 
> , which causing error. I suppose this is caused by the Oracle templates,
> where it says in db.props :
> 
>     LONGVARCHAR = VARCHAR2 (2000)
> 
> , and in columns.vm, it says :
> 
>     #set ( $entry = "$col.Name $type $size $default $nullString," )
> 
> Thus, I suppose we need to update the file db.props to remove the
> VARCHAR2 size for LONGVARCHAR, or otherwise, make changes to the file
> columns.vm, by putting some condition to avoid the size to reappear.
> 
> I think the latter is better.

This sounds reasonable.  Martin recently introduced some Platform classes to CVS 
HEAD which changes -- and might even address -- this.  Chiu, would you take a 
look at those and see if it handles this situation?

Thanks, Dan



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message