Jason van Zyl <[EMAIL PROTECTED]> writes:
> On 6/12/01 9:45 PM, "Daniel Rall" <[EMAIL PROTECTED]> wrote:
>
> > Hi guys. I'm currently grappling with making a XML schema written for
> > MySQL work with both MySQL and Oracle. I have a feeling that setting
> > my idMethod="autoincrement" for all my tables is not going to do what
> > I want for Oracle. I'm going to need to address this (hopefully in a
> > manner which makes my XML Torque schema compatible with both). Does
> > anyone have any thoughts on this?
>
> Why don't you use the IDBroker? Then all the ids will be retrieved
> by an agnostic third party :-)
>
> I think using the IDBroker is the only real way to make things
> truly portable.
[Jason and I discussed this on IRC, but I might as well post my
response for posterity.]
I'm not especially keen on using the ID broker. I would rather have
the native autoincrement/sequence functionality of the database I'm
using available transparently. Does anyone know of a database which
supports both autoincrement and sequence? If not, I propose that this
be just another property mapped by the database-specific db.props
file. If either "autoincrement" or "sequence" are found in a XML
schema, Torque will resolve them against what is appropriate for the
configured database. Thoughts?
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
