The following document http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/index.jsp?topic=/com.ibm.wsadapters.620.jca.jdbc.doc/env/doc/rjdb_problemsolutions.html says:
During metadata discovery, the JDBC Enterprise Metadata Discovery (EMD) first retrieves the schema information from the database-specific JDBC driver and then depending on schema selection, the information about other database entities such as tables, procedures, views, and synonyms are retrieved. However, in the case of MySQL, the JDBC driver does not return schema information. This is because MySQL JDBC driver implementation does not return the information about database schemas in versions before version 5.0.4. Hence, you cannot proceed further with the discovery and artifact generation.
Do more recent MySQL JDBC driver implementations support metadata discovery? I read through the ChangeLog and it mentions lots of bug fixes around metadata but I'm still not 100% sure. Has anyone connected up WebSphere to MySQL and had this work/not work?