Yep. That's why I think (and I think that was Martins' idea, too) of a
closure list which contains all the words from all adapters. But Jons
idea of keeping database-specific list would help IMHO because an Oracle
guru knows best which words are reserved in Oracle and a MySQL expert
knows this for MySQL. So let each of them be able to work on their word
lists and the pull them into one large "forbidden words" list at startup
time.
However, IMHO (and my experience), developing on one and deploying on
another database is a bad idea anyway. :-)
I will definitely take a peek at OJB soon. It seems to address some
concerns that I have with Torque quite nicely.
Regards
Henning
On Mon, 2002-12-09 at 15:44, Lach, Thierry wrote:
> Making the list database specific would run the risk of allowing
> development against one database but not allowing deployment against a
> different one.
>
> -----Original Message-----
> From: Henning P. Schmiedehausen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 09, 2002 9:42 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Reserved words
>
>
> Martin Poeschl <[EMAIL PROTECTED]> writes:
>
> >Jon Scott Stevens wrote:
>
> >>I always see us make commits for fixing reserved words in databases.
> >>
> >>Why not come up with a .properties file of reserved words for each
> >>database and then as part of the initial load of the .xml file, simply
>
> >>query that file and see if one of the column/table names conflicts
> >>with the database of reserved words...we can have a property which
> >>turns this feature on or off (for example, some people might not that
> >>db2 conflicts with oracle or something like that...)
> >>
> >>-jon
> >>
> >how will this work if i want to make sure my app runs with different
> >databases?? (e.g. jetspeed)
>
> As I understood jon, this list would be as database specific as e.g. the
> SQL dialect understood be the engine. So the wordlist would be tied to
> the adapter for the database.
>
> I'm definitely +1 on this. We might even have some sort of closure (set
> of all words forbidden in all databases, which will help your problem).
>
> Regards
> Henning
>
> --
> Dipl.-Inf. (Univ.) Henning P. Schmiedehausen -- Geschaeftsfuehrer
> INTERMETA - Gesellschaft fuer Mehrwertdienste mbH [EMAIL PROTECTED]
>
> Am Schwabachgrund 22 Fon.: 09131 / 50654-0 [EMAIL PROTECTED]
> D-91054 Buckenhof Fax.: 09131 / 50654-20
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen -- Geschaeftsfuehrer
INTERMETA - Gesellschaft fuer Mehrwertdienste mbH [EMAIL PROTECTED]
Am Schwabachgrund 22 Fon.: 09131 / 50654-0 [EMAIL PROTECTED]
D-91054 Buckenhof Fax.: 09131 / 50654-20
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
