----- Original Message -----
From: Christopher Elkins <[EMAIL PROTECTED]>
To: Turbine <[EMAIL PROTECTED]>
Sent: Tuesday, January 25, 2000 11:27 AM
Subject: Re: OPaL XML Schema: First Crack at it...
> 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.
>
sounds good to me, so far what we/i have for an XML Schema file for OPaL is
dreadfully broken. you can get it from here:
http://www.sctdatasystems.com/XMLSchema/ feel free to do what you will with
it and post any changes.
-scott-
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
