In CVS-head we see the following in databases/lookup.xml:
<!-- mysql with jdbc version 2.0 works with relational -->
<filter database-config="relational">
<database-product-name>MySQL</database-product-name>
<driver-class>org.gjt.mm.mysql.</driver-class>
<driver-major-version condition="equals">2</driver-major-version>
<driver-minor-version condition="equals">0</driver-minor-version>
</filter>
<!-- mysql with jdbc version 2.0 works with relational -->
<filter database-config="relational">
<database-product-name>MySQL</database-product-name>
<driver-class>com.mysql.</driver-class>
<driver-major-version condition="equals">2</driver-major-version>
</filter>
<!-- left over jdbc-drivers for mysql -->
<filter database-config="mysql">
<driver-class>org.gjt.mm.mysql.</driver-class>
</filter>
<!-- newer version of mysql uses relational? -->
<filter database-config="mysql">
<driver-class>com.mysql.</driver-class>
</filter>
In other words, some versions of the mysql-driver lead to the
'relational' database scheme. This used to work fine.
But, with the advent of the SearchQuery Project we see in
relational.xml the following:
<sqlhandler>org.mmbase.storage.search.implementation.database.BasicSqlHandler</sqlhandler>
While there also exist a MySqlSqlHandler. So, it does not make much
sense any more to use 'relational.xml' for mysql.
I want to propose to completely go to 'storage' implementation for the
mmbase mysql driver, in MMBase 1.7. Lots of people use MySql, so we
can be sure that it will be well tested before the release of 1.7.
The other option would be to completely go back to 'support'. The
current situation seems to be too half-hearted.
I do not dare to suggest defaults for other databases, so I propose to
say something about that only after proving that it worked out well for mysql.
[ ] Yes, lets go for 'storage' implementation for mysql
[ ] No, lets stick to 'support'
Perhaps Gomez can ellaborate a little about the obvious advantages of
the 'storage' implementation.
Michiel
--
mihxil' Michiel Meeuwissen
Mediapark C101 Hilversum
+31 (0)35 6772979
[]()
