You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by Chiu Yee Weay <yw...@paradigm.com.my> on 2003/11/06 14:40:06 UTC
Problem in task for Oracle
Greetings,
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.
Chiu Yee Weay
Systems Engineer
Paradigm Systems Sdn Bhd
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: Problem in task for Oracle
Posted by CHIU YEE WEAY <yw...@paradigm.com.my>.
Greetings Dan,
Thanks for your feedback. Will surely try it out.
Chiu Yee Weay
Systems Engineer
Paradigm Systems Sdn Bhd
Quoting Daniel Rall <dl...@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
Re: Problem in task for Oracle
Posted by Daniel Rall <dl...@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