|Re: [CDO] Using the DB Mapping to populate queries [message #991374 is a reply to message #991334]
||Tue, 18 December 2012 20:11
|| Eike Stepper
Registered: July 2009
Am 18.12.2012 15:46, schrieb Christophe Bouhier:|
> Is there a way to access the DBStore MappingStrategy, so I can find out the column names in the DB? I know have to
> deal with column names which are sometimes case-incensitive, and sometime are CamelCased:
> For example: Same code, different DB setup gives this:
> MySQL setup 1: Table name => metrics_MetricValueRange_metricValues_list
> MySQL setup 2: Table name => metrics_metricvaluerange_metricvalues_list
I don't follow. Are you saying something in CDO causes these differences?
> This would require to different SQL query text, to be succesful in both setups.
I think something in the particular Mysql configurations causes case insensitive identifiers. In that case the case in
the queries wouldn't matter, either.
> Additionally MySQL, likes to know the DB name to prefix the table. Can I fetch the DB/Schema name this from CDO somehow?
All these informations should be accessible on the server side through IDBStore, IMappingStrategy, IClassMapping, etc.
If you need them at the client side, it would be possible to implement and contribute a custom IQueryHandler that
returns these mapping informations (or any other server information).
Powered by FUDForum
. Page generated in 0.01383 seconds