db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From CHIU YEE WEAY <ywc...@paradigm.com.my>
Subject Re: Problem in <sql> task for Oracle
Date Fri, 21 Nov 2003 16:02:33 GMT
Greetings Dan,

Thanks for your feedback. Will surely try it out.

Chiu Yee Weay
Systems Engineer
Paradigm Systems Sdn Bhd

Quoting Daniel Rall <dlr@finemaltcoding.com>:

> 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
> 
> 
> [ Scanned by JARING E-Mail Virus Scanner ( http://www.jaring.my ) ]
> 



----------------------------------------------------------------
This e-mail has been sent via JARING webmail at http://www.jaring.my

---------------------------------------------------------------------
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