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 Brice Copy <br...@cern.ch> on 2003/07/09 18:31:41 UTC
Oracle XMLType support for generation
Hello,
I'm trying to add Oracle 9i's XMLType support in my Torque scripts.
XMLType is in its most basic form a glorified CLOB, with associated API
to manipulate/query the XML document.
I'm not doing anything complex, merely generating a set of SQL scripts,
along with PL/SQL packages etc..
I don't intend to generate an ORM layer or anything of the kind.
I'm not so familiar with Torque (or its underlying libs), and I simply
updated the following files :
- database.dtd to add XMLTYPE
- db.props, dbJavaType.props, dbSizes.props, dbSQLTypes.props to add
XMLTYPE lines very similar to CLOB ones
e.g. XMLTYPE = XMLTYPE (similar to CLOB = CLOB really)
- columns.vm to look like this :
#foreach ($col in $table.Columns)
#set ( $type = $dbprops.get($col.Type) )
#if ( $type == "XMLTYPE" ) #set ( $xmlstorage = "STORE AS CLOB" ) #end
#set ( $size = $col.printSize() )
#set ( $default = $col.DefaultSetting )
#set ( $nullString = $strings.select($col.isNotNull(),
$dbprops.get("NOTNULL"),"") )
#set ( $entry = "$col.Name $type $!xmlstorage $size $default
$nullString," )
$strings.sub($strings.collapseSpaces($entry)," ,",",")
#end
However, when running ANT, I get the following entries in the
Velocity.log :
Wed Jul 09 18:27:46 CEST 2003 [error] Method get threw exception for
reference $dbprops in template bc4j/columns.vm at [2,20]
Wed Jul 09 18:27:46 CEST 2003 [error] Method parse threw exception for
reference $generator in template bc4j/table.vm at [9,16]
Wed Jul 09 18:27:46 CEST 2003 [error] Method parse threw exception for
reference $generator in template bc4j/Control.vm at [35,9]
So basically the db.props file might be invalid. But I'm suspecting that
the problem is in the underlying libraries. It's not a problem of
parsing the props or vm files, because if I remove my schema.xml's
column type to CLOB, it generates fine.
Anybody with a Torque developer take on this ?
Thanks
Brice
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org