Problem in creating a CMP bean with MySql

Hi,

I am using lomboz eclipse, jboss 4.0.2, xdoclet 1.2.3 & DB as MySql 5.0. I am encountering a very strange problem when I try to create a CMP with MySql as DB. After entering relevant information about the datasource & testing the connection & finding it to be successful, I get the error in lomboz eclipse as :CMP has no attributes. Moreover, I donot even get the table names from the schema, that was given in the datasource, with which the mapping of my CMP will be done.

I tried using Oracle 9i. But to my wonder, I didnot experience this issue, as it gave me all the CMP atttributes mapped & also created the CMP with Oracle DB. Can anyone help me in getting this issue resloved with MySql DB?

[737 byte] By [RahulNimbargia] at [2007-11-27 5:32:17]
# 1
in your connection test, did you attempt to query the table? are db user permissions ok in mysql?
developer_jbsa at 2007-7-12 14:58:15 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...
# 2

Yeah, the DB User permissions are found to be ok, as the test connection was successfull. I have tried for MySql 4.1 & Myql 5.0, with their respective jars & driver classes. But the result was same. Test connection is successful, but when i hit the next button to see the CMP attributes, it doesnot give me the list of tables under that schema & says that CMP has no attributes. Please help.

RahulNimbargia at 2007-7-12 14:58:15 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...
# 3
i was wondering if you attempted a select on your table (and any relevant system table) during your connection testbeing able to connect to the database doesn't guarantee you can query the table or system tables that are required
developer_jbsa at 2007-7-12 14:58:15 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...