Scott Tavares [[EMAIL PROTECTED]] wrote:
>
> ----- Original Message -----
> From: Christopher Elkins <[EMAIL PROTECTED]>
> To: Turbine <[EMAIL PROTECTED]>
> Sent: Tuesday, January 25, 2000 1:02 AM
> Subject: Re: OPaL XML Schema: First Crack at it...
>
>
> > Scott Tavares [[EMAIL PROTECTED]] wrote:
> > > <type name="ColumnMap">
> > > <attribute name="Name" type="string"/>
> > > <element name="TableMap" type="cm:TableMap" minOccurs="1"
> > > maxOccurs="1"/>
> > > </type>
> > >
> > Doesn't the schema need to specify the SQL data type of the column? This
> way
> > a user could force a column to be interpreted as a double even if silly
> JDBC
> > drivers (i.e., Oracle) want to call it a BigDecimal. I bring this up
> because
> > Castor expends a great deal of code on just this problem, and I don't see
> how
> > OPaL (in its current form) makes any provision for it.
> >
>
> well my knowledge of XML schema is still pretty slim at this point so i
> really do not know how to respond to this. could you elaborate a bit more?
>
>
> -scott-
>
Sure. In opl/mapping/ColumnMap.java, there is field called 'type'. I
_presume_ this is one of the SQL types defined in java.sql.Types. Somehow
this field needs to be set when the ColumnMap is created. While OPaL
could probably grok it from the JDBC metadata, some drivers (e.g., Oracle)
perform less than ideal type conversion. It would be useful if a
user-specified type conversion could be used based on an attribute in
the XML schema.
--
Christopher Elkins
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
