Hi, I think your have a problem with the primary key of the Product entity, not the database. Do you have a compound primary key ? (Why the primary key class is declared as cmptest.ProductPK ?) The error says that probably there is no field between SELECT and FROM:the SQL query is like this "SELECT FROM products t0_a WHERE (t0_a.productId IS NOT NULL)"
The container mismatch with your primary key definition. PS : I use myself JBoss 3.2.3 and MySQL 4.0.17 and it works fine. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836321#3836321 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836321 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
