Re: [Modeling-users] MySQL Adapter

[Sebastien B. <sbi...@us...>]

        Hi,

> Hi,=20
>   I'd like to know what I should put in the ZModeling interface, in
> the field "adaptorName" to use a MySQL database.
>=20
> I tried "Modeling.DatabaseAdaptors.MySQLAdaptorLayer.MySQLAdaptor",
> "Modeling.DatabaseAdaptors.MySQLAdaptorLayer.MySQLAdaptor.MySQLAdapto=
r",
> "DatabaseAdaptors.MySQLAdaptorLayer.MySQLAdaptor",
> "DatabaseAdaptors.MySQLAdaptorLayer.MySQLAdaptor.MySQLAdaptor",
> "MySQLAdaptorLayer.MySQLAdaptor.MySQLAdaptor",
> "MySQLAdaptorLayer.MySQLAdaptor", and "MySQLAdaptorLayer".
>=20
> When I validate my model I alway have 2 warnings :=20
>    - adaptorName 'NameOfAdaptor' is not one of the framework's, maybe=
 one of=20
> yours
>    - Couldnt find concrete Adaptor for 'NameOfAdaptor'
>=20

  This is described in the User's Guide paragraph 2.2.2.,
  cf.http://modeling.sourceforge.net/UserGuide/model-props.html

      adaptorName: the name of the database-adaptor, i.e. back-end, you
          want to use for the entities in the model. Currently only
          Postgresql and MySQL (exact typo.) are valid adaptorNames ;
          the former corresponds to the package PostgresqlAdaptorLayer,
          the latter, to package MySQLAdaptorLayer.
=20=20=20=20=20=20
  But okay, I agree this could be stated as well on the TTW interface,
  if it was you would not have been bitten... Sorry for that, I'll add
  this hint in the next release. However when designing a model you
  might find it useful to keep an eye on the UserGuide's section 2.2
  which describes the xml-format, since everything found there can be
  applied to every single parameter exposed in the ZModeler.

> I'm a bit clueless right now, what are the legal adaptor names in the
> ZModeling interface ?

  Postgresql and MySQL are the 2 legal adaptor names for the moment. For
  the curious, you were heading in the right direction when trying to
  feed it with the name of the package ; you were just unlucky |: legal
  names are derived from DatabaseAdaptor's package names with
  'AdaptorLayer' omitted, hence: Postgresql and MySQL.

        Regards,


-- S=E9bastien.