Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [stellation-res] Indexes in SQL databases

Hi,

To use MySQL you have to create an Access Point for it. In your implementation you can override BasicDatabase.renderForeignKey() and add a couple of lines to create the necessary indices.

Off topic: I am immersed on a large project and will be unable to help at least for a month. I wanted to do the ACL stuff proposed by Mark but I can't right now.

Regards,

Rodolfo

On Thu, 2002-09-19 at 21:15, Jonathan Gossage wrote:
Unlike the other databases supported by Stellation, MySql does not support
the implicit creation of indexes for foreign keys and references. It
requires that these indexes be explicitly specified.

Can anyone see a reasn why these indexes cannot always be explicitly
specified? If there are reasons for not doing this there is a reasonably
simple workaround but it will make the code a bit more complicated.

Regards

Jonathan

Personal Email
jgossage@xxxxxxxx

Business Email
jonathan@xxxxxxxxxxxxxx

_______________________________________________
stellation-res mailing list
stellation-res@xxxxxxxxxxxxxxx
http://dev.eclipse.org/mailman/listinfo/stellation-res
-- 

 MAXPROGRAMS
 IBM Business Partner
 Microsoft MSDN Business Connection Partner
 rmraya@xxxxxxxxxxxxxxx
 http://www.maxprograms.com

Back to the top